Customer Reviews

SQL Server 2005 Bible

5 star:		(6)
4 star:		(4)
3 star:		(0)
2 star:		(1)
1 star:		(2)

 

 

There are really three kinds of database professionals:

-Administrators
-Architects/Designers
-Developers

Now, some people play all three roles or two of the three roles. This book is definitely not the best book for people who are strictly developers as is reflected by some of the reviews at this site. Of course, the book is not intended for that class of database professional (in fact, they are really not database professionals if they are strictly developers, but are more developers who have to have a database for their application).

For those who play the role of the Administrator only - and there are thousands of you out there because I teach many of you in my classes - or a combination of administrator/designer this is the best single book you will find. (That's right, the author of another book on SQL Server is suggesting that his book is not the best single book... my book helps you specifically in preparing for the 70-431 exam and is not intended to have the breadth of coverage of this book.) Some developers just don't realize that most small businesses with an IT staff of less than twenty do not have dedicated database people and this book is for those people in those businesses. They are not going to write a lot of applications, if any, from the ground up, but they must support SQL Server databases that have been developed by others.

They need to understand backups and restorations, data export, data import, data tranformation (ETL), security, performance issues and other administrative tasks. All if this is covered sufficiently in the SQL Server 2005 Bible.

I must say that I have not always been a fan of the "Bible" series, but this book has been great since the SQL Server 2000 level when I started recommending it.

I hope this helps you make your decision.

I have the author's SQL Server 2000 book and this book, and it is definitely a major upgrade: 350 more pages, 23 more chapters.

OBXKites is still in here, and David still gets his drivers license on 11/30/2005, but there are as many new topics as there are new features in 2005.
I can imagine that a bible series book is responsible for taking the reader from their "genesis" of being a novice to their "revelation" of advanced topics.

This can be a daunting task for one volume, especially when the subject is as vast as SQL Server! To accomplish this, the book has 10 chapters dedicated to variations of the Select Command. [...]

Nielsen's chapter introductions give you the feel that you're sitting down with a real person, so you know he's going to explain things instead of listing the syntax.

And experienced insight is what I crave when learning a new language. For instance, instead of slogging through all the features of cursors and finding out for myself that they're inefficient, Nielsen explains that while MSDN says "[SQL Server] implements a performance optimization called a fast forward-only cursor", the reality is that SQL Server is a set-based language and cursors should be used as a last-resort. He then shows how to convert a complex cursor to set-based code.

The chapter on indexing explains how indexes work and offers sound advice on how to plan effective indexes - probably the most effective way to optimize an application before having to start changing table structures.

Business Intelligence is the latest requirement for potential employers, so any book that has a chapter on how to use the BI Suite in 2005 is a must-read. There are 3 chapters on Analysis services (including Data Mining and MDX), 2 on RS, 1 on IS, and even one on BI using Excel.

This book is an excellent SQL Server 2005 Reference. There are millions of Code snippets to be used immediatly. The author refers mainly to AdventureWorks, the sample included at SQL 2005. The style of writing is not too serious and the author takes time to introduce - when needed - some database fundamentals. I personally think that this book is ideal for those who don't need a step-by-step book, but an complete reference with not too specialized topics. Of course - if you are specialized in a specific area, there are obvious books around covers topics much more deeper. But 99.5% of everything you find in this book.

I guess I didn't buy this book from the perspective of a programmer, but rather a strict DBA. That is, I don't do much programming... I only manage the database server and help programmers when they need something done on the server. For this reason, I don't have some of the complaints of those who were concerned about lacking information from a developer's perspective.

As a DBA, I feel this is one of the best two books written on SQL Server 2005. I also used Tom Carpenter's 70-431 study guide to prepare for that exam and, while it's not as lengthy as this book, it is my other in that pool of two.

Certainly, if I could only get one book, it would be this one. There are things in Tom Carpenter's book that are not in this book, but since Mr. Carpenter's book is intended to prepare for an exam, there are also things in Mr. Nielsen's book that are not in the other. Overall, there is more detailed information and lengthy explanations in teh SQL Server 2005 Bible. It and Mr. Carpenter's book sit on my shelf alone in the SQL Server 2005 category. I highly recommend the SQL Server 2005 Bible and hope you wear yours out like I am beginning to do with mine.

Paul Nielsen's book, SQL Server 2005, is the among the best references on the topic. For the application developer, unfortunately, it is woefully inadequate. Mr. Nielsen omits most of Microsoft's complex security management, saying (on page 877), "it's almost a maze." Yes, indeed, it is. That's why we pay Mr. Nielsen and his publisher a hefty price for the book, to disentangle mazes; and that's why we feel shortchanged, because he and they fail to do so.

SQL Server 2005 recognizes sixty distinct database permissions, of which Mr. Nielsen briefly mentions only six. He also fails to explain how these are related to standard database management roles, and he fails to explain how an application developer can set permissions declaratively and how an application can determine them programmatically. He fails to explain what happens when an application exceeds its permissions.

Mr. Nielsen's book provides an excellent and thorough SQL Server 2005 reference for novices but a nearly useless one for professionals. An adequate, professionally oriented book has yet to be written.

Unlike SQL Server 2000 Bible, this book doesn't come with e-book version. What a disappointment. If you are a developer and want to keep an e-version of SQL Server book handy then look elsewhere. If you can drag 1300 pages book with you everywhere then I highly recommend this book.

First off, my biggest complaint is the discrepancies between code listed in the text book, and the sample databases downloaded from the author's web site. If you are providing sample databases for download, please make sure the column names referenced in your SQL statements actually exist in the tables!
I found it very difficult to follow the logical flow of the book. It always seemed like I was getting to a lecture half way thru, wondering if what I missed in the first 10 minutes would help my understanding of what the author is talking about. Tools are often explained, but the author never shows you how to open the tools, or set them as defaults. There is no logical flow from one topic to the next, again, you feel like you're ten minutes late to the lecture.
I would wager that half of my time reading this book is spent on trying to follow the author's train of thought, then applying it to SQL. Perhaps the most common expression I make reading this text is, "WTF?!" I'll definitely be purchasing some other text.
Definitely not for SQL beginners, and if you are advanced, this probably won't help you.

On a side note: This lack of attention to detail and inability to connect to the reader seems to be a "Bible" book theme. I also have a Red Had Linux Bible book that suffers the exact same complaints. At first I thought it was the author, but now that I've got my hands on a second "Bible" publication with the exact same problems, I'll be steering clear of these!

This book is a good reference guide for any SQL server user. The book gives alot of good techniques to follow and help troubleshoot problems that may arise.

I recently started using SQL Server 2005. I have some programming and database experience, but none with SQL Server. I am very pleased with the book. It provided a quick refresher of basics, and a clear description of the Server tools. It has already helped greatly, pointing out some of the places where SQL Server varies from standard SQL, and additional commands/tools I would not have found for a long time. I am happy with the writing style, and find the book easy to follow.

This book is well written, easy to follow and easy to apply the code as presented. I would give it a "5" if it had the code samples for creating SQL for a report that includes multiple fields and a subtotal by grouping and a grand total for the report. While there is some information in this book, it does not assist well in solving this particular problem.

Overall, worth the money for a reference if you are a SQL Developer, DBA, BSA, or an instructor or trainer.