SQL Server Security

SQL Server security sits at the apex of the database management food chain. Performance, scalability, availability, and recoverability are all moot if you’re the victim of a ransomware attack. Here are Straight Path Solutions, securing our clients’ databases is our top priority. We’ve put together this resource page as a single point of reference for all of our SQL Server security tools and blog posts.

Jump to…

If 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

Name

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 More

SQL Server Security Blog Posts

Managing Orphaned Users in SQL Server with sp_FindOrphanedUser

Addressing orphaned users is an important piece of SQL Server security management. When left unchecked, you can accumulate an overwhelming number of users that exist in a database but do not have a correlating login in the master database, thus preventing access to the server or the database at all. There are dbatools PowerShell modules … Read more

SQL Server Security: 3 Homework Assignments to Start Today

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Thanks … Read more

SQL Injection: Deconstructing an Attack

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. As … Read more

Enhancing SQL Server Security: Reviewing and Optimizing Audits

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Audits … Read more

What the SQL Server TDE Certificate Expiration Date Does (and does not) Mean

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Transparent … Read more

The Real Danger Regarding the xp_cmdshell Setting

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. When … Read more

Fixing SQL Server Vulnerabilities With GDRs

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. For … Read more

The Case for Auditing Your SQL Server Login Failures

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Login … Read more

Understanding and Managing SQL Server Error Log

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. SQL … Read more