Surrogate Key Abuse is a horrible crime which must be stopped in our lifetimes. Josh Berkus, president of the Society to Stop Surrogate Key Abuse, explains what surrogate key abuse is, why it is so evil, and how we can stop it.
Want to make sure your database loses data, duplicates records, and can only handle 5 transactions a minute? Want to make your application developers curse you, your sysadmin hate you, and get yourself fired without a reference? These ten database design techniques will set you on the road to downtime perdition and maintenance hell.