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.

13 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

Anonymous 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/

Unknown said...

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

Helm Analytics

bish said...

Hey Adam, nice article.

Pass Microsoft Certification Without Taking Exam said...

The book mentioned in this article is very useful. I have studied it prior getting MCTS certification. It cleared most of my doubts about the technology. Thanks for mentioning its name.

Unknown said...
This comment has been removed by the author.
Anonymous said...

Thanks for such a great article here. I was searching for something like this for quite a long time and at last, I’ve found it on your blog. It was definitely interesting for me to read about their market situation nowadays.iot certification chennai | iot training courses in chennai | iot training institutes in chennai | industrial iot training chennai

Unknown said...

Thanks for this sharing information.

Web designing trends in 2020

When we look into the trends, everything which is ruling today’s world was once a start up and slowly begun getting into. But Now they have literally transformed our lives on a tremendous note. To name a few, Facebook, Whats App, Twitter can be a promising proof for such a transformation and have a true impact on the digital world.

we have offered to the advanced syllabus course web design and development for available join now.

more details click the link now.

https://www.webdschool.com/web-development-course-in-chennai.html

Anonymous said...

The book mentioned in this article is very useful. I have studied it prior getting MCTS certification, one of my teachers over CertProxyWizard suggested similar, It cleared most of my doubts about the technology.

evoseedbox said...

I am glade that you have shared such a helpful expected article, this will be very important for those who are looking for this type of blog.WEB Designing Services in Jaipur

Anonymous said...

How to pass Microsoft exam without studying and sitting for exam