Create NetFirewall Rules for SQL Server and SQL Browser executables

Create-NetFirewallRuleSQL.ps1

# get SQL services and path to executable
$services = Get-CimInstance -query 'select * from win32_service where name="sqlbrowser" or name="mssqlserver"'

# Create Firewall Rule for each of the services executables
# use splatting for better readability
foreach ($service in $services) {
    $params = @{
        DisplayName = $service.Name;
        Action = "Allow";
        Description ="Allow $($service.name)";
        Enabled = 1;
        Profile = "Any";
        Program = $service.pathname.replace('"','')
    }
    New-NetFirewallRule @params
}