NEW: Microsoft SQL Server 2008 R2 Administration Cookbook

Robert Pearl, 2011-06-02

I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitter for several years now, and found him to be a real genuine person, awesome fellow, professional and chalk full of innate and in-depth knowledge of the workings of SQL Server technology.  Continuously sharing his knowledge and experiences from the field with the larger SQL Community, he has written many articles, presented in the US, Europe and Asia, and maintains his knowledge sharing network and blog on   You can directly access his blog entries by clicking on the highlighted link.  If you are interested in resolving or helping others resolve their issues, SSQA is the right place for every professional by sharing their invaluable knowledge. It is an evolving site that features advice and knowledge from most valued & experienced technology professionals.

 In addition, he also contributes to and is forum moderator for  Without a doubt, Satya is a top-notch MVP and community contributor.  His contributions to the SQL World do not stop here.  This is why it really is a profound satisfaction to announce the recent release of his book, the “Microsoft SQL Server 2008 R2 Administration Cookbook”!  I truly am happy for him.  This authorship was 8-months in the making, and has a unique approach as a task based real-world best practices in a cookbook style.  The discussions here apply to SQL Server 2008 R2, and SQL 11 CTP (aka Denali – not yet released).  It is available as a paperback edition or downloadable as an e-book. Either form, it is worthwhile to consider having this in your library collection or kindle. 

But, don’t take just my word.  Get In more detail with Table of contents and quite a detailed Sample chapter for download, have a look at PacktLib for more information on this book (and various other selection of books.)

The foreword of this excellent work, is by another well-known industry expert and published SQL MVP, Brad McGehee – also Director of DBA Education at Red Gate software.

Satya personally thanked Brad, as well as Microsoft’s Vinod Kumar for serving as his technical reviewer.  Satya relays to us that it was all of Vinod’s guidance as Technical Reviewer for this book that helped him a lot

It definitely looks like there’s something in it for everyone – like any recipe from a cookbook; it starts out with basic ingredients and simple dishes, to a more flourished display of exquisite in-depth delicacies.

So, what do we have to look forward to?   Indeed the SQLMaster’s R2 cookbook will talk in-depth about new features, best practices for upgrading, migrating, deploying, administering, managing and more!  What readers will learn from this book is:

·         Discover best practice solutions for upgrading to SQL Server 2008 R2

·         Employ the new enhancements in SQL Server 2008 R2

·         Build a strategic multi-server management

·         Automate administration tasks

·         Implement the inter-operability of SQL Server Analysis Services and SQL Server Reporting Services with SharePoint 2010 services

·         Manage and administer core SQL Server 2008 R2 Business Intelligence Services

·         Implement and manage essential Availability and Programmability enhancements

·         Implement best practices and build troubleshooting techniques on a multi-instance and multi-database environment

·         Provides Advanced Administration techniques for SQL Server 2008 R2 as a book or eBook

·         Covers the essential Manageability, Programmability, and Security features

·         Emphasizes important High Availability features and implementation

·         Explains how to maintain and manage the SQL Server data platform effectively


One of the things notable in the book, is that it contains a comprehensive checklist for upgrading to SQL Server 2008 R2.  Not too long ago, I blogged on such a checklist, which was based on one of Satya’s awesome presentation at  a TechEd SQL conference in which he gave us the “why, what, how and when” to upgrade.  I believe that it is referenced in his book.

  If you want to learn a little more about Satya, you can actually read his recent interview  on  Despite my burning curiosity how a nice Indian boy ended up in Scotland/UK, we’ll have to wait for another time to find out J.  Nonetheless, a very interesting read.


I was very proud of him when I received his email announcement, “I’m delighted to announce one of my career achievements (biggest), and it gives me immense pleasure and happiness to share the news about my first book release.”

Indeed this is a celebratory time for Satya’s personal achievement as a new book author.  Ask him about how he feels about his accomplishment and he will tell you, “It’s a happy moment in my career and dream come true, to see my first book (eBook and paperback format) on SQL Server technologies topic.” 

See publisher details below on how to get your copy today!  Let’s all congratulate Satya on his triumphant technical tome.  Let’s get cooking with R2 🙂

Publisher Details:

Detailed Information

Language : English
Paperback : 468 pages  –
Release Date : May 2011

ISBN : 1849681449
ISBN 13 : 978-1-84968-144-5
Author(s) :
Satya Shyam K Jayanty








Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads