Everyone agrees that great database performance starts with a great database design. Unfortunately, not everyone agrees which design options are best. Data architects and DBAs have debated database design best practices for decades. Systems built to handle current workloads are unable to maintain performance as workloads increase.

Attend this engaging and sometimes irreverent session about the pros and cons of database design decisions. This debate includes topics such as logical design, NULLS, surrogate keys, GUIDs, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to deal with them.
Prerequisites: Opinions, lots of them, even wrong ones.
Presented by Karen Lopez and Thomas LaRock at SQLBits 2017