[Microsoft Learn]: never pin Azure SQL server FQDNs to specific IPs in hosts files, static CNAME records, or private DNS zones: the gateways are dynamic and change over time. If you allow-list by gateway IP, allow all gateway IP ranges for your region or use the Sql.[region] service tag. For private connectivity use Private Link or private endpoints instead of DNS overrides. Subscribe to Service Health alerts for gateway migrations in your region so a rotation does not surprise you.

Context: Hardcoded gateway IPs rot silently and produce intermittent connection failures.