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 …

PowerShell Tip of the Week: SQL Server Native Client version

Recently I had to extract SQL Server Native Client version from all of my SQL machines. I would like to share simple script for extracting that information remotely from registry. SQL Server Native Client To find version using PowerShell we need to know where is it located. Easiest way for me was extracting this from registry: SQL Server 2008/2008 R2:– HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion SQL Server 2012/2016:– HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI11\CurrentVersion You …