July 31, 2008 at 8:22 am
Hi there,
Are there are any high level guides on this site for designing a database properly in MSSQL 2005. In the past we created a database that had no relationships defined and was pretty much controlled by the application that used it. the result was redundant data was was not related to other data etc as no relationships where enforced!
I have an opportunity in the coming months to create a new database and get things right from the start! Does anyone have a god resource on where to start?
Cheers,
J
July 31, 2008 at 12:03 pm
Fleming & von Halle's "Handbook of Relational Database Design" is one of the best introductory books that I'm aware of.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 12:41 pm
Haven't read that one, but I did have one called "Data Modeling" that I read years ago and liked. There's a new one from Eric Johnson and Josh Jones that looks good as well. Haven't read it, but flipped through it.
Steve
July 31, 2008 at 12:51 pm
It's an ancient book. But hey, relational databases are relational databases. It's not til you get to all the funky queries and ETL and all that fun stuff that 2000/2005/2008 really matter.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 1:30 pm
How about this one guys: http://whitepapers.zdnet.com/abstract.aspx?docid=269626
Looks like it ticks the boxes?
August 1, 2008 at 5:42 am
It's just a chapter out of a larger book. The information is likely to be good, but it could be pretty light.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 8:11 am
Does anyone have a god resource on where to start?
I'm not sure how much of a hand god had in writing any of those books;)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply