Recent articles by
Joe Celko
|
Celko on SQL: Dividing the Spoils
In this database programming challenge, SQL guru Joe Celko explores various ways to split commissions among multiple sales people.
September 2, 2008
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.
November 5, 2007
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.
September 16, 2007
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.
August 19, 2007
CSI: Data Warehouse
Armed with a knowledge of patterns, you can root out bad data.
December 4, 2004
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.
December 4, 2004
Keys to the Database
Please stay on that side of the database.
October 30, 2004
A Question of Quality
Data quality is today's obsession. How good does the data really have to be?
September 4, 2004
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.
June 12, 2004
Over There
Why would anyone think being a "code monkey" has a future?
April 3, 2004
Are We There Yet?
Are we there yet? No, but quality programming is within reach.
March 20, 2004
/authors/flat_files/Celko.jhtml
Code Confessions
You can teach old programmers a new trick, but they still know a better way.
by Joe Celko
December 10, 2003
The Alphabet Achievement
Will Unicode be as easy as saying your ABCs?
by Joe Celko
October 30, 2003
Commodities and Identifiers
Where's the filet mignon?
by Joe Celko
September 17, 2003
Identifiers and Barbarians
'Pardon him. Theodotus: he is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.' — G.B. Shaw's Julius Caesar
by Joe Celko
August 10, 2003
Dr. Edgar F. 'Ted' Codd (1932-2003)
Father of the RDBMS and a whole lot more
by Joe Celko
June 30, 2003
The Logic of Failure
Programmers who rationalize their decision-making logic can create suicidal situations for databases
by Joe Celko
May 31, 2003
I Will Never Have To Port This Code
Debunking shortcuts and SQL myths
by Joe Celko
April 22, 2003
Keys and History
Let's ditch the punch cards once and for all
by Joe Celko
March 20, 2003
Net Present Value Calculations
by Joe Celko
March 3, 2003
Edsger Dijkstra
A brief tribute to the logician who revolutionized programming
by Joe Celko
February 1, 2003
PC Promises
A PC on every desk and a chicken in every pot
by Joe Celko
November 15, 2002
Knowing the Difference
How well do you know your SQL and set theory?
by Joe Celko
October 8, 2002
Keeping Up With the Merkles
Cellular automata can help you model complex systems
by Joe Celko
September 3, 2002
Modeling Data Management
Experts look back at the SEI Capability Maturity Model to find modern answers to modeling information and data maturity
by Joe Celko
July 26, 2002
Cloning Confusion
Will ethics keep us from technological and medical advances?
by Joe Celko
June 13, 2002
The Road to Dystopia
As national ID smartcards become a reality, you must ask the question: How much information can the government control?
by Joe Celko
May 9, 2002
What's in a Name?
Deciding how to categorize your products may lead to better strategic advantage
by Joe Celko
March 28, 2002
Breaking Tradition
Many computing problems come down to one thing - legacy applications
by Joe Celko
February 21, 2002
This Perfect Day
The road to hell is paved with good intentions
by Joe Celko
January 14, 2002
Spontaneous Order
When dealing with adversity, spontaneous self-organization can often be the most effective way to succeed
by Joe Celko
December 5, 2001
No News Is Good News
Success stories can be found beyond the headlines
by Joe Celko
November 12, 2001
Layoff Lowdown
Let me pink slip into something more comfortable
by Joe Celko
September 18, 2001
Illegal Rhythms
The law tries to catch up with technology at the Computer and Internet Law Institute
by Joe Celko
August 10, 2001
What Time Is It?
Does the new economy need a wristwatch?
by Joe Celko
May 24, 2001
Making IT Sense in the Snow
Fear And Data Modeling In Salt Lake City
by Joe Celko
April 16, 2001
New Years's Revelations
Why Kdb is revamping the way we think about databases
by Joe Celko
March 27, 2001
Mental Model Meltdown
You need the right question in order to find the right answer
by Joe Celko
March 08, 2001
The Bored and the Restless
Sometimes you need to return to your roots in order to move on
by Joe Celko
January 30, 2001
Hollywood Couples
Relationships are harder than you think
by Joe Celko
January 01, 2000
Ten Things I Hate About You
SQL needs to break old habits and find its own voice.
by Joe Celko
December 05, 2000
