Practical Maintenance Plans in SQL Server

Practical Maintenance Plans in SQL Server speaks directly to the need for database administrators to automate their workload and manage more databases than ever before. One key to doing that is automation, including automated early warnings of performance problems and database outages.
Practical Maintenance Plans in SQL Server sets a new standard for SQL Server Database Administrators by providing examples and explanations for the most-used yet least understood portion of database administration: the Maintenance Plans. The book directly enables database administrators to manage more databases with less effort. The book also enables a proactive approach in which administrators are not all the time scrambling to react in panic-mode when a problem occurs.

Helps SQL Server database administrators automate their workflow Enables early-warning alerts to outages and other imminent problems Provides a roadmap by which readers can implement their own plans

Autorentext
Bradley Beard is a professional software developer residing in the lovely city of Palm Bay, Florida. He started off designing websites using PHP and MySQL in the late 90's, and gradually moved on to ColdFusion and SQL Server. His breadth of SQL Server experience began with SQL Server 7, mainly concentrated on SQL Server 2000, and then picked up again in SQL Server 2008. He earned his MCSA: SQL Server 2012 certification in July 2013, and he was the Technical Reviewer for Mike McQuillan's Introducing SQL Server , also available by Apress.

Zusammenfassung
Practical Maintenance Plans in SQL Server speaks directly to the need for database administrators to automate their workload and manage more databases than ever before. One key to doing that is automation, including automated early warnings of performance problems and database outages.
Practical Maintenance Plans in SQL Server sets a new standard for SQL Server Database Administrators by providing examples and explanations for the most-used yet least understood portion of database administration: the Maintenance Plans. The book directly enables database administrators to manage more databases with less effort. The book also enables a proactive approach in which administrators are not all the time scrambling to react in panic-mode when a problem occurs.

Inhalt
Introduction.- 1. Backing Up a Database.- 2. Checking Database Integrity.- 3. Executing SQL Server Agent Jobs.- 4. Purging Log History.- 5. Clearing Old Backup Files.- 6. Rebuilding Indexes.- 7. Reorganizing Indexes.- 8. Shrinking Database Files.- 9. Updating Object Statistics.- 10. Executing T-SQL Statements.- 11. Notifying Database Operators.- 12. Tying It All Together.