// archive
Category: Database
-
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”…
-
Summit 2013 In Review: Overview
Recently, I had the opportunity to attend the PASS Summit in Charlotte, North Carolina. I’ve made attempts the past few years but I’ve never been able to put a trip together for one reason or another. This was my first PASS Summit which some have described as the Super Bowl of SQL Server conferences. The…
-
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…
-
Unraveling the mysteries of NewSequentialID
A few months ago we started development on a new system. From the ground up we redesigned everything from our business processes to how we store data. Part of the redesign was deciding on using SOA technology in our middle tier. This will allow us to separate our UI from our middle tier even further.…