Allow acces to Azure services by region
On the SQL Firewall page have an option that says Allow access from Azure Services in Region where each azure region is listed and you select which ones to whitelist. The reason for this in my case is that I have functions on a function app that is on a consumption plan and so I had to get the azure data center up range for Canada central, Convert them to IPv4 start and end IPs and then manually enter them into the whitelist. And I’d expect they change over time. The Boolean allow access to azure services option currently available did not allow us enough control. Thanks!