Why Enabling TRUSTWORTHY Is an Untrustworthy SQL Server Security Practice

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

Cross-Database Ownership Chaining in SQL Server: A Double-Edged Sword

cross-database ownership chaining

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

The Database Owner Role in SQL Server: A Call for Least Privilege

database owner role least privilege

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

When SQL Server Database Owners Are NULL or Mismatched

NULL or mismatched database owners

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

A Simple SQL Server Health Checklist

Being part of a consulting team has given me experience with many environments, and part of the work I do every week is to check for the various best practices and monitor server health across over 20 environments. This post condenses the tools that can help and the configurations that are most likely to cause … Read more