Database

Why You Absolutely Need Alternate Keys: A Unique Constraint Story

Why You Absolutely Need Alternate Keys: A Unique Constraint Story

Although often forgotten, alternate keys are an essential part of  database design especially if you’re using surrogate keys. Alternate keys protect your database from duplicate data and can even speed up your application. For the past few years I’ve been presenting on the top database design mistakes that I’ve seen “in the wild”. One of those “mistakes”(…)

The A, B, C’s of Table Aliases

Dear Developers, DBA’s and Power Users, There is something that I’ve been seeing in your SQL that it annoys me so much that it’s forcing me to bring it to your attention. Developers, DBA’s and power users hear my plea. Table aliases are wonderful things. They make SQL easier to read and more compact. I’m(…)

Quick and Dirty Data Dictionary

Recently, I’ve been working on databases that I’ve never touched before. Of course, when dealing with a “new to you” database there some are challenges. What’s the schema of the database? What’s the “cleanliness” of the data? Is there any useful metadata? When I look at a database for the first time I want to(…)

Free SQL Server 2008 Courses From Microsoft

Microsoft is offering free SQL Server 2008 online courses. The offered titles are: What’s New in SQL Server 2008 for Enterprise Data Platform What’s New in SQL Server 2008 for Business Intelligence What’s New in SQL Server 2008 for Database Development We’ve been keeping our ear pretty close to the ground on SQL Server 2008(…)

Idiot!

I just did something that was bound to happen. I deleted data from a production database. But it wasn’t just any data; it was the user’s role information on our website.  It wasn’t just some, a little, or most of the data; I deleted the whole freakin’ table. Good job. Yay me. I was performing(…)