Did you know you have more than one option to set the SQL firewall settings on an Azure SQL Database? Most people know you can set firewall rules on the server level:
Allow Azure services and resources to access this serveropens up connection from anywhere inside of the Azure Cloud: this is not limited to your own subscription!
There is one extra option, which is very helpful if you want more control per database, instead of opening the firewall for all databases on the same server.
You can set the firewall rules on the database level as well! These will be checked after the server level settings, so you can mix and match.
There is no editor available, you’ll need to edit the settings in the database itself, for example with the Query editor or through a query or table editor with the SQL Server Management Studio or Azure Data Studio
To open the connection from other Azure resources (note: not limited to your subscriptions), you can toggle the setting for IP-address