The Intelligent Enterprise Weblog – SQL Puzzlers, by Joe Celko

All Articles By Joe Celko

Celko on SQL: Auxiliary Tables vs. Declarative Coding
Auxiliary tables are not only portable across SQL environments and adaptable to external software, they're often a faster, better choice than SQL with computations. And as chips and hardware get faster and cheaper, the auxiliary table approach will make even more sense.

Celko on SQL: Natural, Artificial and Surrogate Keys Explained
SQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.

Celko On SQL: Identifiers and the Properties of Relational Keys
He's back! Author, SQL expert, puzzlemaster and Ming the Merciless look-alike Joe Celko offers his sage (if offbeat) advice on unique identifiers, validation, verification, trusted sources and relational keys.

CSI: Data Warehouse
Armed with a knowledge of patterns, you can root out bad data.

CSI: Data Warehouse
Data often has patterns that are fairly easy to find in a modern database. Armed with a knowledge of patterns, you can root out bad data.

Keys to the Database
Please stay on that side of the database.

A Question of Quality
Data quality is today's obsession. How good does the data really have to be?

Stepping Up to the Plate
Many small companies live with the legacy of dutiful employees who assumed IT roles for which they weren't prepared.

Over There
Why would anyone think being a "code monkey" has a future?

Are We There Yet?
Are we there yet? No, but quality programming is within reach.

MORE INTELLIGENT ENTERPRISE CONTRIBUTORS

Doug Henschen on the Intelligent Enterprise

Kimball Group on Data Warehousing

Cindi Howson on Business Intelligence

Seth Grimes on Analytics

Neil Raden on Business Intelligence

Mark Smith on Performance Management