Here at Straight Path Solutions, we’re big fans of community SQL Server tools. As database administrators who are constantly looking at new clients and new servers, we wished there was a tool to quickly give a SQL Server security check – an overview of any potential security issues. We didn’t find one, so we made one: sp_CheckSecurity. We’ve added two more since then: sp_CheckBackup and sp_CheckTempdb.
sp_CheckSecurity
This is one of our free SQL Server tools for SQL Server Database Administrators (or people who play DBA at their organization) to check the security of their SQL Servers. It is used to detect security vulnerabilities and discrepancies in SQL Server instances.
Learn Moresp_CheckBackup
This is a free SQL Server backup check tool to check SQL Server recoverability. It is used to detect recoverability vulnerabilities and discrepancies in the backups of SQL Server instances.
Learn Moresp_CheckTempdb
This is a free SQL Server tool to check SQL Server tempdb configuration and performance. It is used to quickly detect issues as well as for immediate troubleshooting when tempdb appears to be a current point performance issues.
Learn MoreIf you’d like to be notified when we publish new tools or blog posts, be sure to sign up for our newsletter…
Subscribe for Updates
Community SQL Server Tools
Here are some of our favorite community tools from other SQL Server experts: