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
Posted by Ramy Mahrous 
