Are you a Database Administrator or a Database Developer looking for a comprehensive guide to SQL Server 2005? Look no further! In this blog post, we will be reviewing the book “Microsoft(R) SQL Server 2005 Unleashed” by Ray Rankins, Paul Bertucci, Chris Gallelli, and Alex T. Silverstein.

This book is a valuable resource for anyone involved in the day-to-day administrative management of SQL Server. It goes beyond the basics and provides in-depth coverage of various Database Administration tasks, making it an essential reference for Database Administrators.

One of the standout features of this book is its focus on providing additional information, tricks, and tips that go beyond what is covered in the official SQL Server documentation (Book On-line or BOL). This behind-the-scenes look into SQL Server is particularly valuable for experienced DBAs who are looking to optimize their workflows and automate routine tasks.

The book covers a wide range of topics, including database backup, recovery, maintenance tasks, and the new features introduced in SQL Server 2005. It also provides a detailed exploration of SQL Server Management Studio (SSMS), which is a must-read for those who are new to this tool.

Furthermore, “Microsoft(R) SQL Server 2005 Unleashed” offers a comprehensive introduction to SQL Server Business Intelligence (BI) features such as Analysis Services, Integration Services, and Reporting Services. This makes it a valuable resource for those looking to expand their knowledge in this area.

The authors have done an excellent job of keeping each chapter independent, making it easy to navigate and read. The book is filled with figures and syntax examples that help illustrate the concepts being discussed.

While the book is quite extensive, with 1752 pages and weighing 5 lbs, it also includes a CD with additional chapters on Transact-SQL Programming Guidelines, Tips, and Tricks, as well as SQL Server Full-Text Search. The index of the book also includes references to the CD chapters.

One minor drawback of the book is the lack of examples or quizzes at the end of each chapter for readers to test their knowledge. Additionally, some readers may find the chapter organization could be improved.

In conclusion, “Microsoft(R) SQL Server 2005 Unleashed” is a highly recommended book for Database Administrators and Database Developers alike. Its in-depth coverage of Database Administration tasks, comprehensive introduction to SQL Server Business Intelligence features, and behind-the-scenes insights make it a valuable addition to any SQL Server professional’s bookshelf.

Get your copy of “Microsoft(R) SQL Server 2005 Unleashed” on Amazon today!