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” […]