Chapter 1. Louis and Paul’s 10 key relational database design ideas
Paul Nielsen and Louis Davidson
Even though the database world is more stable than the app dev world, which seems to have a hot new language every other week (our procs written in SQL Server T-SQL 4.21 still run, for the most part), there are still controversies and key ideas that are worth examining. For the 24 Hours of PASS, we presented a session on Ten Big Ideas in Database Design:
- Denormalization is for wimps
- Keys are key
- Generalize, man!
- Class <> table
- Data drives design
- Sets good, cursors bad
- Properly type data
- Extensibility through encapsulation
- Spaghetti is food, not code
- NOLOCK = no consistency
1. Denormalization is for wimps
A common database development phrase ...
Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
