Configure Azure SQL Server firewall

Hi Scripters! Today want to show you how in easy way configure Azure SQL Server firewall for multiple IP addresses. Last time I was working on IaaS configuration to allow connections from virtual machines to Azure SQL Server and decided to share my code with you. Script which I prepared is configured in following way. In first step it gathers all of the virtual machines in subscription and prepare rule …

Check firewall rules remotely using PowerShell

In past few days I had to check firewall rules setting on several machines. It was a good opportunity to write PowerShell function for this and share it with you. It’s just another simple function which will help you to gather the following firewall information from servers remotely: – Server – Direction – Action – Rule Name – Profile – Enabled – Protocol – Local Ports Below you can find …