SQL Server Resources
SQL Server Tools
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_CheckAG: Check Your SQL Server Availability Groups
This is a free SQL Server availability group check tool for SQL Server Database Administrators (or people who play DBA at their organization) to check their SQL Server high availability.
Learn Moresp_CheckBackup: Check Your SQL Server Backup
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_CheckSecurity: Check Your SQL Server Security
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_CheckTempdb: Check Your SQL Server tempdb Database
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 More