Microsoft SQL Server 2008 R2 by Ray Rankins, Paul Bertucci, Chris Gallelli and Alex T. Silverstein

Amazon Link

Brief Review

SQL Server 2008 R2 brings several breakthrough capabilities that will enable organizations to scale database operations with confidence, will allow them to obtain faster results and will help in decision-making. This book covers all the topics that can make Database Administrators efficient and successful.

Detailed Review

This is one of the best book for the intermediate to advanced level SQL server Professionals. The best part of this book is that it has everything for both Database Administrator as well as Database Developer who are new SQL Server 2008 R2. It explains all the new features of SQL Server 2008 R2 and compares it to the previous versions to make us understand how Microsoft is trying to make our lives easier by introducing these new features. It elaborates the GUI-based tools and all the underlying SQL Commands. It covers a wide array of topics and modules of the SQL Server 2008 R2, for instance, database engine, Analysis Services, Integration Services, replication, Mirroring, Clustering, Reporting Services, Notification Services, services broker, and full text search. The book provides elaborated guidance on management, administration, and monitoring. Besides, new features such as Policy-Based Management, Compressed Backup, and Fail-over Clustered are covered in-depth. The book even has a chapter dedicated to newly introduced concept Powershell and Resource Governor.

This book presents all the topics in a very detailed and organized manner which helps the reader to grasp each and every concept thoroughly. It contains some key new features that will help you manage multiple servers at one time using Policy-Based Management, scale your I/O load using compression. This information will certainly have a huge impact in our methodology and experience.

This book shows all the steps to install SQL Server 2008 R2 and all the other features or how to migrate to SQL Server 2008 or SQL Server 2008 R2 from previous versions. It presents all the best practices and the case scenarios which is very relevant to SQL Server users.

The best chapters I found in this book are – Chapter 21-“SQL Server Clustering”, Chapter 22- “Administering Policy-Based Management”, Chapter 35- “Understanding Query Optimization”, Chapter 40- “Managing Workloads with the Resource Governor”, Chapter 41-“A performance and Tuning Methodology”. All these chapters are advanced level topics yet the author managed to present these topics in a simple way which in itself is a great job.

I recommend this information-rich book to every SQL Server user.

Rating: 5 Stars

In the end, this a great book for both developers and DBAs. They should definitely keep this book handy for frequent reference.


Subhro Saha