10 Big Ideas in Database Design


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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: