Table of Contents

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.

About the Author

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.