Microsoft SQL Server 2005 For Dummies [Paperback]

Andrew Watt (Author)

Book Description

Publication Date: February 6, 2006 | ISBN-10: 0764577557 | ISBN-13: 978-0764577550 | Edition: 3

• Now updated to reflect the much-anticipated "Yukon" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast
• Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance
• Covers the major new features of the "Yukon" release-including analysis services, reporting services, and notification services

Editorial Reviews

From the Back Cover

Check out enhanced security, Integration Services, Reporting Services, and more

What's new in SQL Server 2005? Plenty, and this guide will help make it all clear! You'll get the rundown on how to create databases, create queries using the traditional Transact-SQL language, work with the Common Language Runtime, use the new user interface to manage SQL Server 2005, generate business intelligence applications, and more — in plain English.

Discover how to:

• Formulate and run queries
• Create databases, tables, and relationships
• Create stored procedures and triggers
• Secure your data and protect it from loss
• Create business intelligence applications
• Maintain a SQL Server system

About the Author

Andrew Watt (Scotland, UK) is a Microsoft Most Valuable Professional (MVP). He specializes in Microsoft technologies, including the SQL Server database and InfoPath. He is an independent consultant and experienced computer book author. He first used SQL Server in version 7.0. He is using SQL Server 2005 beta in the beta programs since August 2003.

Product Details

• Paperback: 432 pages
• Publisher: For Dummies; 3 edition (February 6, 2006)
• Language: English
• ISBN-10: 0764577557
• ISBN-13: 978-0764577550
• Product Dimensions: 9.2 x 7.4 x 1 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 1.7 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #866,202 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

17 of 18 people found the following review helpful:

1.0 out of 5 stars Confusing, September 15, 2006

By 

R. D. Giles (Salt Lake City, UT) - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2005 For Dummies (Paperback)

This author often forgets who he is talking to. At one point he describes in painful detail on how to join tables and yet in other places he introduces terminology with no explanation. One chapter is devoted to creating a windows application in VS 2005 to display data and the description is incorrect. Is this a book about SQL Server or Visual Studio? I think the publishers of this book would do well to recall this book and rewrite with a particular audience in mind. Is the book an introduction for newbies or a reference for those coming from some other platform or for programmers looking to familiarize themselves with SQL Server? The fact that this is a dummies book would seem to indicate to me that it should be for newbies. I have always been a fan of the Dummies series of books but this one falls flat on its face.

11 of 11 people found the following review helpful:

2.0 out of 5 stars Hard to follow, October 1, 2006

By 

JD "amazon233" (United States) - See all my reviews

This review is from: Microsoft SQL Server 2005 For Dummies (Paperback)

I agree with the previous reviewer. This book is not focused and not targeted to an audience. Most of the features are not covered with enough depth and background to make the information useful. The chapter on replication, which is an advanced feature, was pretty good, but the chapters on backup and recovery where poorly explained.

2 of 2 people found the following review helpful:

1.0 out of 5 stars Not a good dummies book, May 31, 2009

By 

spliceguys "Brian" (FL) - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft SQL Server 2005 For Dummies (Paperback)

A 'dummies' book is supposed to be written for a person that has no knowledge of the subject. This book is a poor example of that. It assumes, for instance, that you already have a correct installation of SQL server. It does not go into the installation process at all. Many of the 'features' are specifically mentioned followed by a sentence that 'I don't cover XX in this book. For people who are going to look through the table of contents, this is totally misleading.. These are a few items that are 'shown' in the table of contents that this book specifically does NOT cover. Installation, the Profiler, T-SQL, online indexing, Online Page and File Restore, Database Engine Tuning Advisor, Full Text Search, SQLCMD.. Many other features are just briefly described.. To look at the table of contents you would think this book covered it all. I give it a DON'T BUY based on it deceptive practices alone.