SQL Server Administration & Maintenance

SQT01 Availability Fundamentals for SQL Server


9:15am - 10:30am

Level: Introductory

Allan Hirt



How to make SQL Server instances and databases available often vexes many regardless of role and how long the person has been working with SQL Server. This session will demystify what it really takes to keep SQL Server up and running to give you a solid foundation of SQL Server availability. You will learn about the built-in features that SQL Server provides for availabilty such as Always On Availability Groups and Failover Cluster Instances, how applications need to be coded to account for availability, and much more. If you're responsible for SQL Server, this session is one you cannot miss.

You will learn:

  • The availability features of SQL Server
  • About things like RTOs and RPOs
  • How many factors -- technical and non-technical -- affect availability