SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Free eBook on SQL Server Maintenance Plans Now Available

BRAD_MAINTENENCE_PLANS_135My 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.


Posted by Jason Brimhall on 15 January 2010

Thanks Brad.

Posted by Dugi on 15 January 2010

Seems to be nice collection for the Maintenance Plans, thnx for info!

Posted by Anonymous on 16 January 2010

Pingback from  Developing for the iPhone ??? what you need to know ?? Kumar's Blog | DevBlogr

Posted by Anonymous on 16 January 2010

Pingback from  Free eBook on SQL Server Maintenance Plans Now Available « DBA – keep learning

Posted by matthew.lang on 22 January 2010

Thanks Brad

Posted by Brad M. McGehee on 22 January 2010

Matthew, let me know what you think of the book.

Posted by rashmiranjansahoo1234 on 27 January 2011

Hello, I am rashmi. Organize is a good ebook book. so it is a good side.


<a href="www.plrprivatelabelrights.com/.../business-ebooks" rel="dofollow">ebooks</a>

Leave a Comment

Please register or log in to leave a comment.