Always On Availability Groups Microsoft introduced Always On Availability Groups in SQL Server 2012, and has been making improvements to the feature in each release since.

SQL Server’s other HA/DR feature, Always On Availability Groups, is a more robust solution capable of providing rapid recoveries with no data loss. Among its other advantages are inclusion in SQL ...

Always on availability groups This feature enables database-level protection by replicating each database transaction on another SQL instance, configured in standalone mode or as a failover cluster.

A notable disadvantage with application-specific options like Always On Availability Groups is the need for administrators to implement other HA or DR solutions for all non-SQL Server applications.

Microsoft introduced a laundry list of new features today for Windows Azure, including general availability of SQL Server AlwaysOn support, notification hubs and autoscale improvements.

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.