Practical Maintenance Plans in SQL Server

Automation for the DBA
1. Auflage 2016
ISBN: 978-1-4842-1894-5
Verlag: Apress

Buch, Englisch, 272 Seiten, Format (B × H): 178 mm x 254 mm, Gewicht: 5598 g

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. 

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Beard, Bradley

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

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.

Über Autor(innen)

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.