Driven by the 9s – Do You Need a Highly Available Data Platform?

Gethyn Ellis

Once upon a time, there was a DBA called Berry Wand. Berry had just landed a job for a large emergency response organization as a Site Reliability Engineer, a fancy new term for SQL Server DBA.

Berry now has responsibility for the availability of the data platform and the mission-critical databases that need to be available to the business 24x 7. Berry has experience being a DBA, but she doesn’t have too much experience in the data platform high-availability options available to her to help her achieve her Service Level Agreements (SLAs)

Every day, since starting her new job, Berry has been researching the high-availability features. She has learned about Log-Shipping, Clustering, and Availability Groups. Disaster recovery is also on the roadmap, and she has read recently that changes in SQL Server 2022 will mean she can better use the cloud for DR.

If this sounds familiar, this session will look at how we can combine SQL Server Availability Groups and SQL Server Failover cluster instances to keep our servers highly available and maintain a secondary disaster recovery. We will look at the Azure SQL Databases option for this too.