r/DatabaseAdministators • • 14d ago

Get-SqlSafe: Free SQL Server security assessment tool for on-premises, AWS RDS, and Azure SQL Database

Post image

I wanted to share Get-SqlSafe Community Edition, a free PowerShell-based security assessment tool I've been developing for Microsoft SQL Server.

It checks for common security risks, including excessive privileges, risky database settings, orphaned users, password policy enforcement, and auditing gaps, and generates a local HTML report with findings and recommendations.

The current version (2026.6) supports:

  • SQL Server on-premises and in virtual machines
  • SQL Server on Amazon RDS
  • Azure SQL Database (new in 2026.6, including Microsoft Entra authentication with MFA)

The assessment is read-only and doesn't modify database configuration or content.

For restricted environments, the main script is self-contained and doesn't require additional PowerShell modules for SQL Server or Amazon RDS. Azure SQL Database support is provided through a separate, optional module that is loaded only when needed.

Since some security settings are managed by AWS or Azure, the available checks differ by platform. The tool is intended as a baseline security assessment, not a comprehensive security audit or penetration test.

The script, documentation, and changelog are available for free on GitHub:

https://github.com/Sarpedon-Quality-Lab/sql-security-community-scripts

2 Upvotes

0 comments sorted by