Brad’s Sure Guide to SQL Server Maintenance Plans is a comprehensive and practical guidebook for database administrators who are responsible for maintaining SQL Server environments. This book, written by Brad McGehee, an experienced database administrator and Microsoft Most Valuable Professional, provides a step-by-step approach to creating and implementing effective maintenance plans for SQL Server databases.
The book is organized in a logical and easy-to-follow format, with each chapter building on the previous one. It starts by providing an overview of SQL Server maintenance and why it is important. It then delves into the details of how to create a maintenance plan using SQL Server Management Studio and how to schedule the plan to run at the appropriate times.
One of the strengths of Brad’s Sure Guide to SQL Server Maintenance Plans is its focus on best practices. The author provides a wealth of advice on how to optimize SQL Server performance and avoid common maintenance pitfalls. He covers topics such as backup and restore strategies, database integrity checks, index maintenance, and statistics updates.
In addition to best practices, the book also includes troubleshooting tips and strategies for dealing with common issues that can arise when working with SQL Server databases. For example, the author provides guidance on how to detect and resolve disk space issues, how to identify and fix corruption problems, and how to handle long-running queries.
Another notable feature of Brad’s Sure Guide to SQL Server Maintenance Plans is its inclusion of real-world examples and case studies. The author draws on his own experience working with SQL Server environments to provide practical examples of how to apply the concepts and techniques covered in the book.
Overall, This book is an invaluable resource for anyone responsible for maintaining SQL Server databases. Whether you are a novice or an experienced database administrator, this book provides the knowledge and guidance you need to create and implement effective maintenance plans that will ensure the continued health and performance of your SQL Server environment.