{"id":110457,"date":"2026-05-11T09:05:19","date_gmt":"2026-05-11T09:05:19","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&p=110457"},"modified":"2026-05-11T10:32:42","modified_gmt":"2026-05-11T10:32:42","slug":"the-complete-guide-to-auditing-sql-server","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/the-complete-guide-to-auditing-sql-server\/","title":{"rendered":"The complete guide to auditing SQL Server"},"content":{"rendered":"\n

Ben Johnston<\/strong> explores all things SQL Server auditing in this 2024 series. He covers everything from the basic initial setup and audit checklist, to more detailed ‘how to’ and ‘step-by-step’ guides for configuration audits, hardware audits – and much more. T-SQL scripts and other assets are included where necessary.<\/p>\n\n\n\n

\n
\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Ben Johnston<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n How to master a database configuration audit in SQL Server: a complete guide <\/h1>\n

\n A SQL Server database configuration audit is where most issues are found \u2014 from compatibility levels and file locations, to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Ben Johnston<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server Configuration Audit: Complete Checklist and T-SQL Scripts <\/h1>\n

\n Complete SQL Server configuration audit checklist with T-SQL scripts: edition and patch level, file locations, sp_configure settings, logon triggers, login… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Ben Johnston<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n How to successfully execute a SQL Server hardware audit (complete guide) <\/h1>\n

\n Learn how to audit SQL Server hardware and Azure cloud configuration \u2014 covering CPU, memory, storage, OS version, and backups… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"Storing\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Ben Johnston<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server Audit Checklist: Discovery & Setup <\/h1>\n

\n Audit SQL Server with a structured discovery checklist. Covers server configuration, disk and memory, backups, security, database settings, and code… <\/p>\n <\/div>\n

\n