Configure SQL MI HA tiers, distributed availability groups, and automated failover for SQL MI on Azure Local.