• RRP: £31.99
  • You Save: £10.24 (32%)
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Trade in your item
Get a £0.50
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server 2005 Bible Paperback – 3 Nov 2006

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£16.48 £2.87

Frequently Bought Together

SQL Server 2005 Bible + Microsoft SQL Server 2005: A Beginner's Guide
Price For Both: £42.68

Buy the selected items together

Trade In this Item for up to £0.50
Trade in SQL Server 2005 Bible for an Amazon Gift Card of up to £0.50, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 1344 pages
  • Publisher: John Wiley & Sons; 1 edition (3 Nov 2006)
  • Language: English
  • ISBN-10: 0764542567
  • ISBN-13: 978-0764542565
  • Product Dimensions: 19 x 5.8 x 23.6 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 615,665 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Develop and manage a SQL Server 2005 database like a pro Seasoned database developers think inside the box, because that′s where the cool code is. This comprehensive reference takes you inside the latest, coolest, and most powerful box, Microsoft′s SQL Server 2005. Each of the book′s seven sections focuses on key elements in a logical sequence, so you can easily find what you need—including all the basics, best practices, dozens of targeted examples, and sample code. If you develop, manage, or maintain SQL Server 2005 databases, this in–depth book is what you need to succeed! Master the fundamentals of SQL Server technology Write better logic queries for greater success Manage and secure a production database 24/7/365 Integrate with .NET CLR and XML Understand SOA and emerging technologies Meet business intelligence goals with new tools Measure performance, lock transactions, and scale very large databases

About the Author

Paul Nielsen , Microsoft SQL Server MVP, is an author, hands–on database developer, and trainer specializing in data architecture and Microsoft SQL Server tech?nologies. Besides holding several certifications, he is the Subject Matter Expert (SME) for the Microsoft Official Course, 2784: Tuning and Optimizing Queries using Microsoft SQL Server 2005 . Visit www.sqlserverbible.com, where he hosts screencasts that walk readers through many tasks in the SQL Server 2005 Bible . The site also includes sample databases, sample code, hot SQL Server links, and additional articles and white papers.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

Format: Paperback
As an experienced web developer and database programmer, but who hasn't used SQL Server very much, I was looking to grow my understanding of the capabilities of SQL Server as much as for a detailed reference. This book didn't really achieve the former, but has turned out to be the most useful paper reference we've got.

It seems to have an overview of all the functionality available in the SQL Server suite, though I don't understand all the terminology used. Although the logic behind the organisation of such a large book is difficult for me to understand, there's an extensive index which enabled me to find the things I've been looking for over the past six months.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 4 people found the following review helpful By Aries Budi Susilo on 17 Feb 2007
Format: Paperback
This book is very help to understand what is the inside of Microsoft SQL Server 2005. This book is for anyone, novice or experienced who wants to learn about query tuning. It has enough beginning discussion to be useful to the novice, and it has enough detail to be useful to experienced DBAs and developers.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 13 reviews
37 of 38 people found the following review helpful
The best book available for the strict DBA 7 Sep 2007
By Tom Carpenter - Published on Amazon.com
Format: Paperback
There are really three kinds of database professionals:


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.
12 of 12 people found the following review helpful
New features; new chapters 20 Jan 2007
By Phillip Senn - Published on Amazon.com
Format: Paperback
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.
6 of 6 people found the following review helpful
Excellent universal SQL 2005 Reference 9 Jan 2007
By T. Gröhlich - Published on Amazon.com
Format: Paperback
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.
3 of 3 people found the following review helpful
This is a great book 30 Aug 2007
By Billy Forsythe - Published on Amazon.com
Format: Paperback
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.
12 of 16 people found the following review helpful
Inadequate for professionals 8 Dec 2006
By Application Software Developer - Published on Amazon.com
Format: Paperback
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.
Were these reviews helpful? Let us know