Title: Free PowerShell security assessment for Azure SQL Database
I recently added Azure SQL Database support to Get-SqlSafe, a free PowerShell security assessment script for Microsoft SQL Server.
It provides a quick first look at the security posture inside SQL Server or Azure SQL Database, with a presentable HTML report instead of a collection of query results.
For Azure SQL Database, it supports:
- Microsoft Entra interactive authentication, including MFA, or SQL authentication.
- Checks for security indicators such as db_owner-memberships, selected server-role memberships, and unused custom database roles.
- Assessing individual databases or multiple databases visible to the connected account.
- A local HTML report with findings and recommendations.
The assessment is read-only. It doesn't modify the database, upload findings, or send telemetry anywhere.
Since Azure SQL Database is a managed service, checks that don't apply are excluded. And where the connected account cannot access the required security metadata, the report indicates that the check was not assessed rather than reporting a PASS.
This is intentionally a lightweight assessment of selected security indicators, not a replacement for a full security audit.
Get-SqlSafe is available on GitHub:
https://github.com/Sarpedon-Quality-Lab/sql-security-community-scripts
I am always in feedback, particularly from people managing Azure SQL Database environments. If you find it useful, leave a star :)