Pro SQL Server 2005 Database Design and Optimization (Pro)

  Author:    Kevin Kline, Louis Davidson, Kurt Windisch
  ISBN:    1590595297
  Sales Rank:    193904
  Published:    2006-03-27
  Publisher:    Apress
  # Pages:    500
  Binding:    Paperback
  Avg. Rating:    5.0 based on 6 reviews
  Used Offers:    15 from $34.88
  Amazon Price:    $53.99
  (Data above last updated:  2008-10-10 08:15:21 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Pro SQL Server 2005 Database Design and Optimization (Pro)
  

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

                  Reader Reviews 1 - 6 of 6                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
01-17-08 5 4\5
(Hide Review...)  Great Book, Easy Read
Reviewer Permalink
I'll keep it short and simple, it's worth the price. It will allow you to make the jump from Application Developer to DBA.
(Review Data Last Updated: 2008-10-08 06:46:20 EST)
09-12-07 5 1\4
(Hide Review...)  Great instructional book
Reviewer Permalink
What can I say? This book gives me exactly what I needed. I'm a self-taught DB guy and this book filled in a lot of holes in knowledge.
(Review Data Last Updated: 2008-01-18 12:46:40 EST)
08-13-06 5 7\9
(Hide Review...)  A Database Design and Optimization "must-have"....
Reviewer Permalink
I highly recommend this book to anyone working with SQL Server 2005. The material presented is made more understandable (not to mention entertaining!) by the examples used by the author throughout the book. The new features for SQL Server 2005 that the author covers are very relevant to my job, especially Chapter 7, Securing Access to the Data. The continuity of the material presented is excellent. Each chapter serves as a reference guide to complex topics that the author successfully explains through a combination of expertise, experience and a sense of humor.
(Review Data Last Updated: 2007-09-13 07:50:28 EST)
06-30-06 5 (NA)
(Hide Review...)  A great read
Reviewer Permalink
This book is very well written and does a good job explaining new functionality and design of SQL 2005 as well as contrasting with SQL 2000 implementation. Definitely a book to add to your library.
(Review Data Last Updated: 2006-08-13 11:02:51 EST)
06-19-06 5 (NA)
(Hide Review...)  A must-have
Reviewer Permalink
I have the 2000 version of this book, which I thought was outstanding. Not only does it have excellent content, but it's written as if you were sitting at a table talking to Mr. Davidson directly.

This updated version should be a staple on any database developer or administrator's bookshelf. There is a solid discussion of design, securing the database (new encryption capabilities of 2005) and much more. But these aren't the reasons why you should own this book. It is as much a "how-to" book as it is a "what-to" book. You get real advice, not just screenshots and step-by-step examples. I wish more books were written this way, as technical knowledge without a procedural "framework" is a recipe for disaster.

Do yourself a favor and make the investment. Personally I know that any custom database design course I teach from this point on will include this book as reference for my students.
(Review Data Last Updated: 2006-07-11 04:51:26 EST)
06-01-06 5 (NA)
(Hide Review...)  An essential guide for SQL Server database designers
Reviewer Permalink
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.
(Review Data Last Updated: 2006-07-11 04:51:26 EST)
  
                  Reader Reviews 1 - 6 of 6                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)