Auditing and Compliance

Beneficial SQL Server Auditing and Compliance tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
Identify Orphaned Windows Logins and Groups in SQL Server Tim Ford2026-05-10
SQL Server – the password of the account has expired Jeremy Kadlec2025-05-20
Auditing Windows Groups from SQL Server Amit Watwe2025-04-21
SOC 2 Audits to Analyze Policies and Technology for Data Protection Terri Hurley2024-12-02
Create Custom Audit Specifications using SQL Server Audit Derek Colley2024-06-11
SQL Server DDL Trigger to Capture for Create, Alter and Drop Commands Muhammad Kamran2024-03-18
SQL Server Audit Filtering with a Predicate Nico Botes2023-05-12
Auditing Failed SQL Server Transactions Using Table Variables Sergey Gigoyan2019-06-14
Custom Intrusion Detection Reporting for SQL Server Svetlana Golovko2018-08-07
Auditing your SQL Server database and server permissions Greg Robidoux2018-06-02
Audit and Prevent Unwanted SQL Server Table Changes John Miner2018-01-26
Audit SQL Server Logins without filling up the Error Log K. Brian Kelley2017-10-27
Audit SQL Server Logins Using SQL Profiler Ben Snaidero2017-02-24
Automate Import of SQL Server Audit Files Using PowerShell Ahmad Yaseen2015-02-02
What Windows Server Groups Should I Audit on my SQL Servers? K. Brian Kelley2014-10-23
Prevent Confidential Data at the Application Layer from getting into SQL Server Tim Smith2014-09-12
What does PCI DSS mean for your SQL Server environment? Tibor Nagy2014-04-25
Use Extended Events to Get More Information About Failed SQL Server Login Attempts Aaron Bertrand2014-04-17
Identify SQL Server databases that are no longer in use Brady Upton2014-02-25
What to Audit at the SQL Server Instance Level K. Brian Kelley2013-07-30
SQL Server Login Management using LOGINPROPERTY function Svetlana Golovko2013-03-21
SQL Server Security Audit Scripts Svetlana Golovko2013-03-07
SQL Server Encryption To Block DBAs Data Access K. Brian Kelley2012-12-19
SQL Server Database Security Audit (Part 1): What to expect? Svetlana Golovko2012-11-21
Auditing SQL Server 2012 Server Roles K. Brian Kelley2012-11-14
Using a Backup to Find SQL Server Security Changes K. Brian Kelley2012-09-11
How to Audit Login Changes on a SQL Server K. Brian Kelley2012-07-30
Identifying What Runs at Startup on SQL Server K. Brian Kelley2012-01-30
Auditing sysadmin on multiple servers using PowerShell K. Brian Kelley2012-01-23
Steps to restore a database that has a SQL Server Audit defined Matteo Lorini2011-12-26
Auditing SQL Server Password Age K. Brian Kelley2011-05-11
Auditing SQL Server User and Role Permissions for Databases K. Brian Kelley2010-10-20
SQL Server Security Auditing to Match Logins And Users K. Brian Kelley2010-08-13
Auditing SQL Server Permissions and Roles for the Server K. Brian Kelley2010-06-29
Tables and Views for Auditing SQL Server Logins K. Brian Kelley2010-05-24
SQL Server 2008 Audit Change Group Thomas LaRock2010-03-10
SQL Server 2008 Auditing Feature Thomas LaRock2010-03-03
SQL Server Security Audit Report Kun Lee2009-11-16
Script to auto generate a security report for your SQL Server instance Michelle Gutzait2009-08-18
Automate collection and saving of failed logins for SQL Server K. Brian Kelley2009-05-13
Auditing Failed Logins in SQL Server K. Brian Kelley2009-04-22
How to find out what SQL Server rights have been granted to the Public role Tim Ford2009-02-24
SQL Server 2008 TSQL Auditing Commands for SELECT statements Edwin Sarmiento2008-12-30
Auditing SELECT statements in SQL Server 2008 K. Brian Kelley2008-12-18
Designing Tables for Audit Data in SQL Server Jeremy Kadlec2008-04-02
SOX for SQL Server DBAs Jay Dave2007-08-02
Password management options for the SQL Server sa login Jeremy Kadlec2007-01-10
Auditing Products for SQL Server Jeremy Kadlec2006-12-06
How do I enforce SQL Server 2000 password changes? Jeremy Kadlec2006-09-05