From the Real World: On Call Again

TJay Belt has a great story of the nightmare DBA situation.

The Concept of Cardinal Reciprocity- A Primer

Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.

Preferred singer for expert DBA

SQL Queries Are Coming To Town

The holiday classic updated for SQLServerCentral.

SQL Queries Are Coming To Town

An updated holiday classic from SQLServerCentral.

SQL Queries Are Coming To Town

An updated holiday classic from SQLServerCentral.

SQL Server Queries Are Coming To Town

An updated Christmas poem from SQLServerCentral.

Halloween

A Halloween Tale

A while back, in a Simple-Talk editorial meeting, someone bet Phil that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth.

Reformat via query?