24 Hours of PASS: Summit 2017 Preview

Azure SQL VM - Implementing Basic AG in SQL 2016 STD

Speaker: Kenneth Urena

Duration: 60 minutes

Track: Build

For a long time Database Professionals have been asking Microsoft to make Always on Availability Groups (AG) available in Standard Edition. With SQL Server 2016 SP1, Microsoft responded with Basic Availability Groups, a limited but very functional version of Always on Availability Groups.

Basic Availability Groups enable Data Professionals to provide enterprise class High Availability solutions using SQL Server Standard Edition, which allows organizations to save money by providing High Availability (HA) for applications that require HA without paying for SQL Server Enterprise Edition features they do not need.

In this session, we will be covering:
- Limitations on Basic Availability Groups
- Components and steps necessary to configure a Basic AG for an Azure Virtual Machine (VM) running SQL Server 2016

Accompanying Material

No material found.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.

Kenneth Urena
TeamMate, Linchpin People

Kenneth UreƱa is an experienced technologist with 17 years of experience, including 14 years of experience in SQL server. He has worked on versions from SQL Server 7.0 to SQL server 2016. Kenneth... View More

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids