SQL Saturday 617 - The Enterprise Maintenance Lifecycle: Problems & Solutions

Sean McCown and Jen McCown are SQL Server Microsoft Certified Masters and consultant. Through our company, MidnightSQL Consulting, LLC, we perform a full range of databases services that revolve around SQL Server.  We’ve got over 30 years of experience between us and we’ve seen and done almost everything there is to do.  We have two decades of experience managing large enterprises, and we bring that straight to you.We also own and run MinionWare, LLC - our SQL Server software company. See www.MinionWare.net for free, outstanding backup and maintenance utilities, and our premium SQL management system - Minion Enterprise.

MinionWare, LLC

<A HREF="https://www.youtube.com/watch?v=Lp35mjZpDN4" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Here's a quick video of us, telling you about this class</A>!
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:
<UL>
<LI>Deploy maintenance routines to hundreds of servers, effortlessly</LI>
<LI>Standardize configuration throughout the enterprise</LI>
<LI>Set up custom alerts and reports.</LI>
<LI>Manage HA/DR failover scenarios and keep your maintenance intact.</LI>
<LI>Minimize the number of jobs</LI>
<LI>Tune backups and database integrity checks</LI>
</UL>
 
For maintenance, you'll learn how to:
 
<UL>
<LI>Order index operations to maintain the most important tables first</LI>
<LI>Maximize your maintenance window by fine-tuning your routine.</LI>
<LI>Easily deal with special circumstances like indexes with settings that conflict with maintenance.</LI>
<LI>Make reindex operations fully dynamic to meet your changing environment.</LI>
<LI>Handle the most difficult CheckDB scenarios with dynamic custom snapshots, multi-threading and CheckDB offloading using auto-restore and remote CheckDB operations.</LI>
</UL>
 
 
And for backups specifically, you'll learn to:
<UL>
<LI>
Automate management of failed backups
</LI>
<LI>
Ensure that certificates and encrypted passwords are securely backed up
</LI>
<LI>
Automate configuration changes between HA/DR sites, in case of failover.
</LI>
<LI>
Turn trace flags on or off automatically.
</LI>
<LI>
Dynamically archive end of month or end of year backups.
</LI>
<LI>
Tune the backups for your entire enterprise and keep them tuned as the environment changes.
</LI>
</UL>
 
This will be the most complete class on enterprise maintenance you'll ever have.   
 Sign up now!
 
Event Schedule
<UL>
<LI>08:30 AM - 09:00 AM - Check In</LI>
<LI>09:00 AM - 12:30 PM - Seminar Training</LI>
<LI>12:30 PM - 01:30 PM - Lunch and Networking</LI>
<LI>01:30 PM - 05:00 PM - Seminar Training</LI>
</UL>

Hilton Garden Inn Pensacola Airport

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

SQL Saturday 617 - The Enterprise Maintenance Lifecycle: Problems & Solutions

More events from MinionWare, LLC

Discover more events from MinionWare, LLC, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Pensacola and filter by date, category, and more to find the perfect fit.

SQL Saturday 617 - The Enterprise Maintenance Lifecycle: Problems & Solutions

More events from MinionWare, LLC

Discover more events from MinionWare, LLC, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Pensacola and filter by date, category, and more to find the perfect fit.