I need 2 SQL servers at different locations with ... If I understand correctly, even Always On availability groups where both nodes use synchronous commit, the secondary node/db is read-only.

The public cloud offers a myriad of options for providing high availability and ... region-wide disasters are rare. SQL Server offers two of its own HA/DR features: Always On Failover Cluster ...