SQL Server Administration & Maintenance

SQT02 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 demysitify 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 Availabilty 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:

  • Understand availability fundamentals
  • Understand what features are in SQL Server for availability, how they work, and where they should be used
  • Understand that backups are the fundamental building block of availability