My new eBook, Brad’ Sure Guide to SQL Server Maintenance Plans is now available as a free, 269 page PDF eBook. The book is designed for part-time or novice DBAs who want to learn how to properly create Maintenance Plans using the tools that come with SQL Server Management Studio (SSMS) in SQL Server 2005/2008.
These two tools include:
- Maintenance Plan Wizard – a Wizard that steps the user through the process of setting up basic Maintenance Plans, with limited options.
- Maintenance Plan Designer – a drag-and-drop GUI interface in SSMS that facilitates the design and creation of more flexible, customizable maintenance plans.
Unfortunately, neither tool is especially easy to use or well documented. However, with the guidance I provide in this book, they can become powerful tools in helping the novice DBA to perform critical maintenance tasks, and so help to ensure SQL Server’s performance and availability. In addition to learning how to use these tools you will, along the way, pick up a lot of good, general advice on SQL Server database maintenance. I also tell you when not to use these tools, as there are many cases when it is more appropriate to use T-SQL or PowerShell scripts to perform database maintenance.
If you get a chance to read the book, please post your feedback here. While I spent a lot of time trying to include as much content as I could, I realize that I did not cover every possible way to use these tools, nor cover how they should be used under every possible SQL Server environment.
A paperback version of the book should become available at Amazon.com within the 60 days.
PS: If you haven’t read my blog on A Time and Place for the SQL Server Maintenance Plan Wizard, please do so. It explains why I decided to write this book.