SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback)

SQL Server 2005 Management and Administration (Paperback)
by Ross Mistry (Author), Chris Amaris (Author), Alec Minty (Author), Rand Morimoto (Author)

SS2K5MandA SQLAuthority News   Book Review   SQL Server 2005 Management and Administration (Paperback)

Link to Amazon

Short Summary:
SQL SERVER 2005 is a trusted database platform that provides organizations a competitive advantage by allowing them to obtain faster results and make better business decisions. This book covers all the topics which can help Database Administrators to be successful and effective.

Detail summary:

This book is covers all the topics and modules of the SQL Server 2005, e.g. database engine, Analysis Services, Integration Services, replication, Reporting Services, Notification Services, services broker and full text search. This book improves the experience these professionals have working with SQL Server. Book also provides detailed guidance on management, administration, and monitoring.

Role of DBA does not end when SQL Server is already deployed. The real task of DBA begins when SQL Server is successfully deployed. This book assumes the reader has experience with installing SQL Server 2005, so it goes far beyond the basic installation and setup methods. One thing I really liked about this book is that it focuses on day-to-day administration, best practices, and industry case scenarios. Another interesting fact about this book is all topics and examples covered in this book are based on the new features and functionality included with SQL Server 2005 Service Pack 2.

The topic of SQL Server 2005 administration and management is huge and this book covers almost all of those important topics. This book is divided in total of six parts. Part 5 and part 6 are available online only. Around 300 pages are available online only and it can be downloaded by registering the book. When registered this book it also enables 45 day free subscription of Safari.

Rating: 4 stars

In Summary, This is great concise book which all DBA should keep on desk for frequent reference.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

8 thoughts on “SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback)

  1. Great review Pinal. I was very impressed with this book. Hands down, this is the greatest SQL Server book I have come across in a long time. Our organization leveraged the High Availability chapters to configure a multiple instance SQL Server 2005 failover cluster with Windows Server 2003. In addition, we also loved the chapter on PKI encryption and how to configure SCOM 2007 to proactively monitor the SQL Server infrastructure.



  2. I’m sorry to disagree, but I bought a copy of this book and I think it’s total garbage. It is full of misinformation. For example, check out the section on clustered vs. nonclustered indexes, where the authors claim that a nonclustered index is sorted based on the order of the clustered index. Clearly, this book was not properly tech reviewed and should not be trusted.


  3. Pingback: SQL SERVER - 2005 - Best Practices for SQL Server Health Check Journey to SQL Authority with Pinal Dave

  4. Hi Pinal,

    I found this book to be very helpful. The chapter dedicated to understanding and configuring System Center 2007 Operations Manager assisted us as we were implementing OpsMGR 2007 at our organization to proactively monitor our SQL Server infrastructure.

    Thanks and keep up the great site



  5. Pingback: SQLAuthority News - MVP Summit 2009 - Day 2 - Most Contributing MVP of Year Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s