Azure SQL firewall access

Some things were easier in the good old days before Dyn365 and Azure and some are better. Often the things that were better before tends to be things we need to relearn. Allowing firewall access to Azure SQL (for example regarding BI) is easily scripted and here are 3 useful scripts for that purpose: List current firewall rules: SELECT * FROM sys.firewall_rules If you need to grant access to the IPs to EXEC sp_set_firewall_rule N'The_Name_That_Will_Be_Shown_On_The_List... Read the full text.
Comment List