Posted in Azure PowerShell SQL Server

Azure SQL Database – Get users and role members for all databases

I ran into a concern to quickly audit all current users and role members for a set of Azure SQL databases, spread across multiple resource…

Continue Reading... Azure SQL Database – Get users and role members for all databases
Posted in Azure SQL Server

SQL Login Failures and Azure SQL

We ran into an issue recently with a large number of SQL Login failures triggering an alert for our sysadmins. This was in one of…

Continue Reading... SQL Login Failures and Azure SQL
Posted in Azure

Azure DB, ROUTE ADD, and VPNs

One of the things that I have to content with every now and then with Azure SQL is accessing our Azure SQL databases through the…

Continue Reading... Azure DB, ROUTE ADD, and VPNs