10 Big Ideas in Database Design

September 8, 2009

Session #1: 10 Big Ideas in Database Design

Event: 24 Hours of PASS

Presenters: Paul Nielsen / Louis Davidson

1- Normalize your database.
2- Use keys (Primary, Foreign, Surrogate)
3- Generalize
4- Class not a table
5- Data Dives Design
6- Sets good, Cursors bad
7- Good datatype
8- Abstract\Encapsulate -> Extensibility
9- Don’t make your T-SQL code spaghetti
10- No lock no consistency

Resources: www.nycsqlusergroup.com