$129 – $149

SQL Saturday 617 - The Enterprise Maintenance Lifecycle: Problems & Solutio...

Event Information

Share this event

Date and Time

Location

Location

Hilton Garden Inn Pensacola Airport

1144 Airport Boulevard

Pensacola, FL 32504

View Map

Friends Who Are Going
Event description

Description

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.
  • Easily deal with special circumstances like indexes with settings that conflict with maintenance.
  • Make reindex operations fully dynamic to meet your changing environment.
  • Handle the most difficult CheckDB scenarios with dynamic custom snapshots, multi-threading and CheckDB offloading using auto-restore and remote CheckDB operations.



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.

  • Dynamically archive end of month or end of year backups.

  • Tune the backups for your entire enterprise and keep them tuned as the environment changes.


This will be the most complete class on enterprise maintenance you'll ever have.

Sign up now!

Event Schedule

  • 08:30 AM - 09:00 AM - Check In
  • 09:00 AM - 12:30 PM - Seminar Training
  • 12:30 PM - 01:30 PM - Lunch and Networking
  • 01:30 PM - 05:00 PM - Seminar Training
Share with friends

Date and Time

Location

Hilton Garden Inn Pensacola Airport

1144 Airport Boulevard

Pensacola, FL 32504

View Map

Save This Event

Event Saved