Running SQL Faster

Learn how to make your SQL Server perform better from MVP Gail Shaw.

Decoding the SQL Server Index Structure

A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!

Insider Insights

Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.

Busy Work

Run this fun script when you're bored.

Voice of the DBA Podcast

Independence Day

SQL Server

SQLServerCentral To Take Over PASS

After intense negotiations with CA and Microsoft, the founding sponsors of PASS, SQLServerCentral has agreed to take over the organization.

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.