I am working on the outline of a new book I am writing, tentatively called Mastering SQL Server Database Maintenance. It will loosely be based on a similar presentation I give at user groups and conferences.
If you have the time, I would like to get your opinions on one or more of the following topics.
1) Who should the book be targeted to? Who would benefit most from reading such a book?
2) Should the book focus on getting the most out of the Database Maintenance Wizard, should it only mention the Database Maintenance Plan in passing, or should it ignore the Database Maintenance Wizard completely?
3) Should the book emphasize using the Management Studio GUI to get work done, or should it emphasize using T-SQL scripts, or a combination of them both?
4) What topics do you think should be included in the book? Below I have provided a “starting” list. Do you think these topics are important, or not? What topics have I left out?
- Physical File Fragmentation
- Database and Log File Management
- tempdb Maintenance
- msdb Maintenance
- Index Maintenance
- Statistics Maintenance
- Data Corruption Detection
- Database and Log File Protection (Backups)
- Database Maintenance Monitoring
5) What other suggestions do have for such a book?
If you have the time, I would greatly appreciate your feedback. Thanks.
|Share this post :|