|
 |
|
 |
 |
Pro SQL Server 2005 Database Design and Optimization (Pro)
|
by Louis Davidson, Kevin Kline, and Kurt Windisch
Sales Rank: 42819
|
Discount: 37 %
$38.54
At Amazon
|
|
Paperback: 672 pages
Publisher: Apress May 1, 2006
Language: English
ISBN-10: 1590595297
ISBN-13: 978-1590595299
Product Dimensions:
9 x 7 x 1.2 inches
Shipping Weight: 2.2 pounds
http://www.sqlmag.com,
and is a resident expert at SearchSQLServer.com. Kevin is a top-rated speaker, appearing at
international conferences such as Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum,
and SQL Connections. When he's not pulling his hair out over work, he loves to spend time
with his four kids and in his flower and vegetable gardens. Kurt Windisch is a senior technical specialist with Levi, Ray & Shoup, Inc., a global provider
of technology solutions with headquarters in Springfield, Illinois. He has more than 15 years of
experience in IT, and is a DBA and technical architect for the internal IT department at LRS.
He spent 5 years serving on the board of directors for PASS, has written for several SQL Server
magazines, and has presented at conferences internationally on the topic of database programming
with SQL Server.
Customer Reviews & Comments
If you need to learn how to design a SQL Server database the right way, from the bottom up (or top down, depending on your persective), you can do no better than this book. The book starts with a solid introduction/refersher on basic database concepts, which brings the reader up to the required level to start thinking about issues such as normalization and data integrity -- extremely important issues if you value your data! Past there, the book gets deep (very deep) into data modeling, including discussions of such important concepts as when to use surrogate keys, what kind of data constraints should be defined, and the increasingly important question of how best to secure your data. The book closes with a few specialized, more advanced chapters, which I found to be especially interesting. These include a chapter on concurrency, "code-level architectural decisions" (really, best practices for writing great T-SQL), and finally a VERY useful chapter on database interoperability -- a must for those who have to make SQL Server talk to other DBMSs. In short, I highly recommend this book to anyone who wants to learn to be a great SQL Server database designer.
Comment | Permalink |
(Report this)
|
Pro SQL Server 2005 Database Design and Optimization (Pro)
Discount: 37 %
Available from Amazon
Price: $38.54
| |
|
|
|
|
