Brad's Sure Guide to SQL Server Maintenance Plans,
This review is from: Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks) (Paperback)
This book is aimed at what the author calls "accidental database administrators". I certainly qualify in this classification. Having used SQL Server for many years and having been coerced into being responsibile for DB maintenance I wish the book had been available many years ago. The book contains very simple to following instructions (with diagrams) on the configuration tasks necessary to create very usable maintenance plans. The author is very clear about the dos and don'ts of using the tools.
The book starts with a very important discussion on why DB maintenance is important before explaining the two different approaches described in the book - those being the Maintenance Plan Wizard (MPW) and the Maintenance Plan Designer (MPD)
Chapter 3 starts with an introductory (simple) example of the use of the MPW which results in a very usable maintenance plan. This is followed by 12 chapters that give details of the various components that can be configured using the (MPW). Very few stones are left unturned related to the available options.
Chapter 16 then introduces the MPD. The MPD is graphical tool that enables maintenance plans to be created in a dynamic fashion. The final few chapters then cover the detail on the MPD including amending exists plans created by using the MPW.
This book is a very welcome aid to help the amateur become a more fully rounded professional. The explanations are clear the reading style is very easy. The clear guidelines on the pros and cons of each tool on top of the recommendations on things to avoid will save much time both in one's learning curve and on the eventually performance and effectiveness of created maintenance plans.