Saturday, August 13, 2011

Book Review–Microsoft SQL Server 2008 R2 Administration Cookbook

 

Brief Review:

Microsoft SQL Server 2008 R2 Administration Cookbook is a collection of recipes that help database administrators with day-to-day tasks.  The recipes from this book have a broad spectrum of topics, including  Piecemeal Restores, Optimistic Concurrency, Data-Tier Applications, Master Data Services, Replication, Multi-Server Management, Utility Control Point etc..  This book is a great reference on how to accomplish daily administrative tasks and challenges.

Detailed Review:

Microsoft%20SQL%20Server%202008%20R2%20Administration%20CookbookThere are few books available that can keep your technical curiosity engaged, while presenting the information in a easy to understand manner.  Microsoft SQL Server 2008 R2 is one such book.  This book delivers quality content in a simplistic manner that will benefit all database administrators.  My favorite thing about this book is that it delivers real world solutions to real world problems.  In today’s IT environment, the database administrator can be a seasoned IT professional with 10 to 20 years of database experience, or what some people call an accidental DBA.  An accidental DBA is a database administrator that assumes the role of database administrator, either through necessity or circumstance, and usually has little to no real world experience as a database administrator.  This book caters to both the seasoned and the accidental database administrator. 

As the name implies, Microsoft SQL Server 2008 R2 Administration Cookbook focusing on the administrative side of SQL Server.  This book contains over 70 quality recipes that database administrators can use in their day-to-day duties.  The great thing about this book is the diversity of the recipes.  The author does a great job of covering SQL Server administration from a lot of different angles using different immerging technologies.  The recipes include Resource Governor, Multi-Server Administration, Business Intelligence, High Availability and more.  There is an enormous amount of information spanning a broad spectrum of topics. Without sounding cliché, there is something for everybody, in this book.

The author’s writing style is clear and concise.  You do not have to be a Microsoft Certified Master to understand the fundamental concepts presented in each recipe.  Another thing I like about this book is the code samples.  I cannot tell you how many times I have cracked open a book and have to analyze and reread the code sample to understand what it is doing.  This book does not have that problem. The code samples are very easy to understand and follow.  By keeping the samples simple, the author delivers a better experience to the reader.

My favorite chapters in this book are Chapter 7 – Managing The Core Database Engine, Chapter 5 – Managing Core SQL Server 2008 R2 Technologies because these chapters contain a lot of useful information that a lot of database administrators do not know about, including Utility Control Point, SQL Azure, StreamInsight, and Master Data Services. 

The Verdict: 5/5

I recommend Microsoft SQL Server 2008 R2 Administration Cookbook to any IT Professional currently working as a database administrator or wants to get into database administration, with SQL Server 2008 R2.  This book is a great administrative reference that you will want to keep close to your desk, regardless of experience level.

6 comments:

Blagoy Peev said...

blaj777@hotmail.com PSYHOTRON WEAPON FROM 2003 A.D. ?? PEOPLE ..GOTSE DELCHEV
Subject: HELO ? I AM FRANKENSTAIN BULGAR,SOFIA,GOTSE DELCHEV SOS I Am Man Robot Computer REMOTE CONTROL ..INTERNET FROM BULGARIA SOFIA GOTSE DELCHEV ZIP2900
AND SPINYARUS ,LAWMAKER FROM BROADCASTING TV MEDIA ,RADIO,,WELT,,
UNDER SIEGE FROM ,,I N Q U S I Z I, ,OBSADA OCCUPY ,FROM 2003 YEARS
25 MART .SOS EGN 5006130124 WELT WAR ,KRIEG .VOINA 10 000 SOLDATI VOINIZI .SA TUKV GOTSE DELCHEV OT 2003 GODINA MILITARS blaje29@yahoo.com blajko@pirincom.com
Tel 359 0895108256

Blagoy Peev said...

21:12:16] Blagoy Peew says: PROCESORI CAMERI HARDOVE TELEVIZII
[21:12:56] Blagoy Peew says: RAZBIRA6 LI?
[21:13:22] Blagoy Peew says: ANDROID BRA4EDE
[21:13:41] Blagoy Peew says: TAM LI SI??
[21:14:21] Blagoy Peew says: KUKLA S REMOTE CONTROL BRA4EDE??
[21:16:25] Petar Raduchev says: Nishto ne razbiram. Ti da ne si piinal?
[21:16:40] Blagoy Peew says: PUSNI CAMERA TA BRA4EDE
[21:17:13] Petar Raduchev says: Niamam. Az sam na rabota. Tuka niama kamera.
[21:17:44] Blagoy Peew says: IMAM COP4ETA BUTONI SA VSI4KI EMOTIKONI (rofl)
(clap)(emo):O8-)

PrissyLou said...

I love reading your post. Nice share. Nice. Thanks for posting this.

http://sqlsolutions.com

MindqOnline said...

Fantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.

http://sqlservermasters.com/

sqlservermasters said...

My partner and i actually enjoy this post and the internet site all in all! Your piece of writing is really plainly composed as well as simply understandable. Your current Blog design is awesome as well! Would be awesome to know where I are able obtain it. Please maintain up the very good job. We all require far more such website owners like you on the net and much fewer spammers. Fantastic mate!
http://sqlservermasters.com/

Avinash Sharma said...

Nice article, I enjoined it, its very helpful also.

Helm Analytics