Ryan Cooper rdc-112
rdc-112
/ UpdateAzureFirewallRule.ps1
Created
September 22, 2020 21:19
Update SQL Server Firewall Rule Using Powershell
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| param | |
| ([Parameter(Mandatory)][string]$resourceGroupName, | |
| [Parameter(Mandatory)][string]$sqlServerName, | |
| [Parameter(Mandatory)][string]$ruleName) | |
| <# | |
| TODO: | |
| - Add option to create firewall rule if it doesn't exist already | |
| - Wrap wxternal method calls in try/catch blocks | |
| - Add option to use PC name as rule name. Reduces the number of params that need to be provided | |
| - Improve log messages |