Product DescriptionUse this comprehensive tutorial and reference to increase productivity and write stored procedures using the language with which you're most familiar. The revised content covers new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, making this book a must for any developer or database administrator transitioning to the new version of SQL Server. You'll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you'll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task. A companion Web site provides all of the code examples found in the book.
Customer Reviews
Average Rating:
Rating: - The best book available for the strict DBA
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, ... Read More
Rating: - This is a great 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 ... Read More
Rating: - Good Reference For SQL 2005 DBA's
Just finished reading the book , I do recommend it , either for professionals or beginners ! , for professionals , it does have any in depth knowledge we can gain from , all topics are not very basic and shallow, describing distributed transactions in 2 pages for example, very good indexing and performance chapter 50, For beginners there are no books compare in value , the book is written for SQL Server 2005. it is a SQL Server 2005 bible.. that it's true...
Rating: - New features; new chapters
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, ... Read More
Rating: - Excellent universal SQL 2005 Reference
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, ... Read More