Notes from the Field: A Guide to Modern SQL Server Availability Architectures

Whether you are deploying SQL Server on premises, up in one of the public clouds, or hybrid, instances and databases must be made highly available. There are many different ways to solve that challenge, including built-in features such as Always On Availability Groups (AGs), Always On Failover Cluster Instances (FCIs), log shipping, platform-based options such as vMotion or Live Migration, and more. While there are many possibilities, what are the methods along with their corresponding best practices to achieve business continuity with SQL Server?

Based on over twenty years of customer deployments, this full day session will cover the most common availability scenarios from simple to complex to ensure SQL Server is up and running when you need it to be. The topics that will be discussed include:

* Understand the availability options in SQL Server as well as at a platform level and where they should (or should not) be used
* Learn the patterns and practices for making SQL Server available
* Understand how the location of choice (on premises or up in the public cloud) affects deployments - that includes IaaS and PaaS
* Learn how to avoid or minimize the impact of events that affect uptime
* Usable, real-world best practices, tips, and tricks

Get the most out of your SQL Server investment and be an availability hero by signing up today.

feedback link:

Starts: 09:00 8th Mar 2022
Ends: 17:00 8th Mar 2022


Short Description
- This full day session will ensure you know what it takes to ensure SQL Server meets your uptime requirements no matter how or where you are deploying it.
Should delegates bring a laptop with them?
- No
If so what Spec?
- N/A
What software and licences do they need?
- N/A
What is the structure of the day?
- 1. Understand the non-technical factors that influence SQL Server availability 2. Understand the built-in and platform-based availability options (pros, cons, etc.) and what everything brings to the table 3. See/understand real architectures and get tips/tricks/pros/cons on each - especially where combining features/technologies. This would be on premises, physical, virtual (including IaaS), hybrid, and cloud.
What internet requirements do the delegates have?
- N/A
What will the delegates get out of the day?
- With less and less focus on physical, how to make SQL Server available is both similar and different to the way it used to be. This full day will show them how to do it in the modern landscape.
Other technologies
- Virtualization

Slidedeck Link

Notes from the Field A Guide to Modern SQL Server Availability Architectures.pdf


Allan Hirt


AWSAzureGCPMoving to the CloudOn PremisesIAAS VM BasedOperational DatabasesDeploymentManagingMonitoringOptimisingSecurityManaged InstanceSQL 2019SQL 2022SQL LinuxIntermediate

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.