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

OLE Automation: Just As Much Vulnerability As xp_cmdshell

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. It’s … Read more

Why Enabling TRUSTWORTHY Is an Untrustworthy SQL Server Security Practice

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. If … Read more

5 Key Backup Strategies for Unbeatable SQL Server Security

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. There … Read more

SQL Server Security: Best Practices with CLR

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. What … Read more

Dedicated Admin Connection (DAC): Your Key to Troubleshooting and SQL Server Security

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. In … Read more

How Database Mail XPs Can Become a SQL Server Security Liability

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. If … Read more

Local Windows Administrators Are Basically SQL Server sysadmins, Too

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. If … Read more

4 Reasons Why the Owner of SQL Server Agent Jobs Should Not Be User Logins

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. In … Read more

SQL Server Security Best Practices for Linked Servers

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

SQL Server Security: Best Practices for db_accessadmin, db_securityadmin, and db_ddladmin Roles

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. Understanding … Read more