Microsoft SQL Server 2008 R2 Unleashed and over one million other books are available for Amazon Kindle. Learn more
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images
Sell yours for a Gift Card
We'll buy it for $9.47
Learn More
Trade in now
Have one to sell? Sell on Amazon

Microsoft SQL Server 2008 R2 Unleashed Paperback – September 26, 2010

ISBN-13: 978-0672330568 ISBN-10: 0672330563 Edition: 1st
Buy used
Buy new
Used & new from other sellers Delivery options vary per offer
63 used & new from $20.60
Rent from Amazon Price New from Used from
"Please retry"
Paperback, September 26, 2010
"Please retry"
$34.15 $20.60
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$42.06 FREE Shipping. Only 10 left in stock (more on the way). Ships from and sold by Gift-wrap available.

Frequently Bought Together

Microsoft SQL Server 2008 R2 Unleashed + Microsoft SQL Server 2008 Bible + Microsoft SQL Server 2008 Reporting Services
Price for all three: $124.63

Buy the selected items together

Editorial Reviews

From the Back Cover

Thoroughly updated to reflect Microsoft SQL Server 2008's newest features and best practices,Microsoft SQL Server 2008 Unleashedis the latest edition of the most comprehensive, best-selling independent reference to Microsoft SQL Server. This book presents comprehensive, real-world guidance for professionals who work with SQL Server, from DBAs to developers, consultants to users. The Authors present detailed, realistic coverage of all aspects of SQL Server, including Installation and upgrades; Management and administration; Data protection and security, including new Transparent Data Encryption and advanced auditing; Creating and managing tables, views, stored procedures, triggers, and user-defined functions; Performance monitoring, troubleshooting, and optimization, including new Performance System Analysis tools; Transactions, transaction management, and distributed transactions; High availability, clustering, and replication; The newest versions of SQL Server Management Studio and other tools and utilities; and Improvements to reporting, including visualization and improved Microsoft Office integration.


  • Comprehensive, independent, and practical coverage for everyone who works with SQL Server 2008: DBAs, developers, architects, users, consultants, and more
  • Covers all of SQL Server 2008's most important improvements, in areas ranging from analysis to security to performance Designed to help experienced professionals build on their current knowledge as they move to SQL Server 2008

About the Author

Ray Rankins (Saratoga Springs, NY), owns and leads Gotham Consulting Services, and has worked with Sybase and Microsoft SQL Server for 20+ years. Paul Bertucci founded Database Architechs, a database consultancy based in the U.S. and Paris, France. He has 26+ years' experience in database design, architecture, replication, tuning, integration, high availability, and related areas. Chris Gallelli (Albany, NY), president of CGAL Consulting Services, specializes in database administration, tuning, and programming. Alex T. Silverstein (Saratoga Springs, NY) is managing principal and chief architect of the Unified Digital Group, LLC, a developer of custom SQL Server and Microsoft .NET solutions.

Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 1704 pages
  • Publisher: Sams Publishing; 1 edition (September 26, 2010)
  • Language: English
  • ISBN-10: 0672330563
  • ISBN-13: 978-0672330568
  • Product Dimensions: 7 x 2.3 x 9 inches
  • Shipping Weight: 4.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (30 customer reviews)
  • Amazon Best Sellers Rank: #366,853 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

4.5 out of 5 stars

Most Helpful Customer Reviews

46 of 46 people found the following review helpful By charles pyle on November 28, 2010
Format: Paperback
Microsoft keeps adding new functionality to SQL server so the latest version, SQL 2008 R2, has become vastly complex. So much so that Microsoft has divided up their DBA certifications into three specializations: core DBA and developer and BI. Correspondingly, technical books on SQL 2008 tend to be divided up along the same lines. Thus I would have thought it would be impossible to cover the whole in a single book. But this book attempts to do just that. And it does a pretty good job, in my opinion. Of course it cannot go into great depth on any one subject, but it goes into enough depth to be useful to a practicing DBA in any of the three categories.

They manage it by making the book huge. So huge that, apparently, it can't all be printed in a single book. So when you buy the book, you get a book that is around 1700 pages (1550 pages of text and about 100 pages of index and 50 of front material) and in the back of the book is a CD that contains another 800 or so pages in PDF files. To put it in other words, the first 41 chapters are printed in the book, but chapters 42-56 are in digital format in the companion CD. So technically all of the chapters are in the book but only some of them are printed in the book.

I have found that with many technical books, after you get the book, you have to hunt around on the internet for sample databases, code listings, sample files, etc., as if they hadn't finished developing the code till after the book was published. And in my experience this hunt too often ends, at the cost of too much of my time, with limited success or complete failure. It was a pleasant surprise to find that all of the code and samples referenced in this book are on the companion CD included in the back of the book.
Read more ›
4 Comments 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
56 of 63 people found the following review helpful By 1PBFOOT on January 29, 2011
Format: Paperback Verified Purchase
To be honest, I have never seen such a poor QA process for a book. The chapter I was most interested in has numerous errors in it. Let me explain...

This book comes with a CD containing another ~800 pages of supplemental chapters. Chapter 52, in PDF format on the CD, contains info on SQL Server Integration Services (SSIS). However, the CD's Chapter 52 code samples aren't for PDF Chapter 52--they're under the Chapter 46 folder. The "Chapter46_AllCodeExamples.sql" file has the correct code... For the first exercise in the chapter, if you paste the right code into the export query window & click "Parse" (like it says to do in the book), you'll get an error that says "Incorrect syntax near '`'." Unless you're already a SQL guru that knows the authors accidentally used the Unicode "open single quote" character as opposed to the standard ASCII apostrophe, you'll be lost. Once you fix that problem and click "Parse" again, you'll get the following 3 errors...
Invalid column name 'CustomerType'.
Invalid column name 'CustomerType'.
Invalid column name 'customerid'. (Microsoft SQL Server Native Client 10.0)
Apparently, the code in both the PDF and the code samples files include columns that aren't in Microsoft's "AdventureWorks2008" database. With further research, the book has multiple typos indicating to use the "AdventureWorks2008" database--the code should use be run against the "AdventureWorks" database.

Also, be forewarned that later in that chapter, if you choose to use the supplied .DTSX package to do the exercises in Visual Studio, the book doesn't include information on how to change the package's SQL Server name from the default "DBARCH-LT2\SQL08DE01" to your server name/instance.
Read more ›
1 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
17 of 17 people found the following review helpful By Lance M. Andrewes on May 14, 2011
Format: Kindle Edition Verified Purchase
I purchased the Kindle edition and am pleased to report that it does contain all 56 chapters, so no need to download "part 2" of the book as a pdf. The graphics are in colour and in all cases the text in screen-dumps is readable (if fuzzy). The index uses a notation like "CD:2331" when referring to pages that are on the pdf included with the print edition. Thankfully these links take you to the correct location in the Kindle book.

The content is wide ranging but don't expect miracles in what is now a huge platform. For example Master Data Services gets only a short overview. Overall the book is very good value.
8 Comments 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
9 of 9 people found the following review helpful By Earl D. Shaffer on January 10, 2011
Format: Paperback
As a very senior Oracle DBA, often clients have Oracle and SQL Server. In some sites, I am asked to do some SQL Server admin. So I need to keep up with SQL Server. For me, the best way, is to read books and try out things in a not-used-throw-away DB. But like Oracle books, SQL Server books vary in quality and coverage. This book gets 5-stars for both.

Its big. Very big. Its long because it covers so much. The writing style is to point, and very clear. Many of these books are too much developer-only. This is DBA and developer friends. Too many books are filled with online doc and tons of screen prints to 'burn the page count' and fill it with fluff. This has the right balance between detail and coverage.

But the biggest plus - it is not just a reference book. It has tons of examples and that helps non-SQL Server experts learn. It cover SQL Server 2008 new features, and SQL Server 2008 R2 new features. It has just the right balance of 'old' and 'new' feature details.

Just a great book for Oracle DBAs and SQL Server DBAs.
1 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 Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Microsoft SQL Server 2008 R2 Unleashed
This item: Microsoft SQL Server 2008 R2 Unleashed
Price: $42.06
Ships from and sold by

What Other Items Do Customers Buy After Viewing This Item?