Industrial-Sized Deals Books Gift Guide Books Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon $5 Albums egg_2015 All-New Amazon Fire TV Get Ready for the Winter Gifts Under $50 Amazon Gift Card Offer minions minions minions  Amazon Echo Starting at $84.99 Kindle Black Friday Deals TheGoodDinosaur Shop Now Tikes
Microsoft SQL Server 2008 R2 Unleashed and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Microsoft SQL Server 2008 R2 Unleashed 1st Edition

31 customer reviews
ISBN-13: 075-2063330562
ISBN-10: 0672330563
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$14.03 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$14.61 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$38.20 On clicking this link, a new layer will be open
More Buying Choices
32 New from $34.20 37 Used from $6.39
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks
$38.20 FREE Shipping. In Stock. 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
Total price: $115.04
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.

Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

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 (31 customer reviews)
  • Amazon Best Sellers Rank: #399,477 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

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.
Sorry, we failed to record your vote. Please try again
Report abuse
57 of 64 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.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Sorry, we failed to record your vote. Please try again
Report abuse

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: $38.20
Ships from and sold by

Want to discover more products? Check out these pages to see more: sql server integration services tuning, m is for data monkey