Database Design - Solving Problems Before They Start

Discover essential database design principles in this 59-minute conference talk from PASS Data Community Summit. Learn to anticipate future organizational needs and make smart decisions to avoid common pitfalls. Explore topics such as choosing appropriate data types, normalization, and effective column naming to facilitate easier database development and future modifications. Through live demonstrations, examine potential disasters caused by poor design choices and learn how to correct them. Gain insights into creating entity relationship diagrams, understanding NULL vs. NOT NULL, implementing constraints, and mastering normalization techniques. Equip yourself with the knowledge to create beautiful database designs that positively impact your entire team and enhance the quality of your TSQL code.

Intro
PASS SUMMIT 2015
What is Good Design?
Example: Types of Tables
Data Types
Naming Objects
The ERD: Entity Relationship Diagram
NULL vs. NOT NULL
Constraints
Tips & Reminders
Example: Normalization
Database Design: Conclusion