The biggest challenge involved in implementing HA or DR provisions for SQL Server 2008/R2 in Azure derives from the need for failover cluster instances (FCIs) to use some form of shared storage ...

Microsoft plans to release a 'General Purpose' version of its Azure Arc-enabled SQL Managed Instance (MI) at the 'general availability' (GA) commercial-release stage, 'starting July 30, 2021.' ...

This allows the SQL Server team to have more granular control over failover operations and better interaction with Azure services. There are two availability models for the Azure SQL platform ...

The SQL1 and SLQ2 failover cluster instances use standard Windows Server 2016 images with SQL Server pre-installed, but the SQL Server software will need to be re-installed as a clustered instance ...

Making SQL Server “always on” SQL Server offers two of its own HA/DR features: Always On Failover Cluster Instances and Always On Availability Groups. FCIs afford three notable advantages: inclusion ...

Microsoft has detailed a couple of improvements to the way Azure SQL Database handles failovers in case of an outage. It works with individual databases, elastic pools, or a combination of both.