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.
Auflage
Sprache
Verlagsort
Zielgruppe
Illustrationen
323
2 s/w Abbildungen, 323 farbige Abbildungen
XX, 272 p. 325 illus., 323 illus. in color.
Maße
Höhe: 254 mm
Breite: 178 mm
Dicke: 17 mm
Gewicht
ISBN-13
978-1-4842-1894-5 (9781484218945)
DOI
10.1007/978-1-4842-1895-2
Schweitzer Klassifikation
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.
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.
