Enter your mobile number 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.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Microsoft SQL Server 2008 R2 Unleashed 1st Edition

4.4 out of 5 stars 32 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.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$38.69 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$43.40 On clicking this link, a new layer will be open
More Buying Choices
41 New from $25.00 35 Used from $4.87
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$43.40 FREE Shipping. Only 15 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • Microsoft SQL Server 2008 R2 Unleashed
  • +
  • Microsoft SQL Server 2008 Bible
  • +
  • Microsoft SQL Server 2008 Reporting Services
Total price: $125.97
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 Unleashed is 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.

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See 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.4 out of 5 stars  See all reviews (32 customer reviews)
  • Amazon Best Sellers Rank: #272,425 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

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 46 people found this helpful. 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
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 58 people found this helpful. 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
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 17 people found this helpful. 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
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 10 people found this helpful. 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

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