Database Design Contentious Issues

2014

TL; DR

Let's debate database design issues: NULLs, surrogate keys, datatypes, RI and more

Session Details

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as:

Natural vs. Surrogate keys
NULL/NOT NULL
DBA vs Dev vs DA
Data Type Lengths
RDBMs vs. NoSQL
the CLOUD
Who Calls the Shots and Who Does What?
...and others.

Bring your votes, your debates, and your opinions.

3 things you'll get out of this session

Karen Lopez's previous sessions

Graphs Are Everywhere - Graph DB Support in SQL vNext

Learn about graph databases and how they are implemented in SQL Server vNext

7 Databases in 70 Minutes

Learn about 7 SQL and NoSQL databases: how they work, when to use them, and how they form a modern data architecture

5+ Database Design Blunders and How to Avoid Them

Karen discusses five (plus a few more) database design blunders with tips on how to avoid them. Audience members will also be able to contribute their war stories of design fails, WTHs and D'ohs.