On October 7 we will be presenting a full day of maintenance and backup learnin’!
Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724
And while you’re at it, register for the free SQL Saturday Orlando that follows! http://www.sqlsaturday.com/564/eventhome.aspx
Abstract for “The Lifecycle Approach”
Database maintenance isn’t a single event; it’s a lifecycle. Aside from the maintenance event itself, there’s also reporting, error management, specialized configs, HA/DR and more. In this full day session, we’ll explore the many issues surrounding maintenance and how to solve them in a way that is cohesive and comprehensive. If you’re managing more than one server, come to this session.
Learn how to:
- Deploy maintenance routines to hundreds of servers, effortlessly
- Standardize configuration throughout the enterprise
- Set up custom alerts and reports.
- Manage HA/DR failover scenarios and keep your maintenance intact.
- Minimize the number of jobs
- Tune backups and database integrity checks
For maintenance, you’ll learn how to:
- Order index operations to maintain the most important tables first
- Maximize your maintenance window by fine-tuning your routine.
- Handle the most difficult CheckDB scenarios with dynamic custom snapshots, multi-threading and CheckDB offloading.
And for backups specifically, you’ll learn to:
- Automate management of failed backups
- Ensure that certificates and encrypted passwords are securely backed up
- Automate configuration changes between HA/DR sites, in case of failover
- Turn trace flags on or off automatically