The ABCs of SQL Server Availability

Allan Hirt

Your applications and end users need SQL Server instances and databases that both perform well and are online when they need to be. Additionally, the solution must be manageable and cost-effective. No big deal, right? Wrong.

Deploying, managing, and maintaining highly available SQL Server instances and databases is more than choosing one of the features in SQL Server and running a wizard or script to get it configured. There are many aspects to consider when making decisions which will ultimately become the solution that balances all necessary aspects.

This full day with SQL Server availability expert and Microsoft MVP Allan Hirt will demystify what it really takes to achieve your expected uptime from SQL Server … and when to reset expectations because others have unrealistic availability goals. You will also learn:

  • The building blocks of availability, including how to define RTOs, RPOs, and SLAs
  • The difference between high availability and disaster recovery, and how to approach solutions that encompass both
  • An understanding of the built-in availability features of SQL Server (up to and including SQL Server 2016) such as failover cluster instances, availability groups, log shipping, and more
  • How virtualization and the public cloud impact SQL Server high availability
  • Why backups and restores still matter even if you use other methods for primary availability
  • Methods for approaching solution design that balance availability, performance, and cost.
  • Best practices, tips, and tricks that you can put to work immediately

Whether you are new to SQL Server and want to learn about how to make it highly available, looking to refresh your skills for an upcoming project, or trying to prevent the next outage, this session will have something for you.