Introducing sp_CheckTempdb: Check Your SQL Server tempdb for Performance Issues

Free SQL Server DBA tool - sp_CheckTempdb

Most database folks might know the tempdb database in SQL Server is used for temporary tables, but many folks don’t realize all the other things that use this critical system database. It’s also used by table variables, cursors, aggregations, joins, and sorts. And by memory spills when you don’t have enough memory. And by integrity … Read more

Introducing sp_CheckBackup: Check Your SQL Server Backups for Recoverability Issues

SQL Server database backup tool for checking recoverability issues

Whether you are backing up your SQL Server databases with Ola Hallengren’s scripts, Maintenance Plans, or some third-party software, your backups are your lifeline for recovering your data in case of a disaster. So…are your databases recoverable? Do you know WHERE your most recent backups were written? Do you know WHEN they were written? Did … Read more

The Real Danger Regarding the xp_cmdshell Setting

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

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

OLE Automation: Just As Much Vulnerability As xp_cmdshell

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

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