Ben Johnston 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.

Ben Johnston in SQL Server

How to master a database configuration audit in SQL Server: a complete guide

A SQL Server database configuration audit is where most issues are found — from compatibility levels and file locations, to…

20 August 2024 16 min read

Ben Johnston in SQL Server

SQL Server Configuration Audit: Complete Checklist and T-SQL Scripts

Complete SQL Server configuration audit checklist with T-SQL scripts: edition and patch level, file locations, sp_configure settings, logon triggers, login…

25 July 2024 22 min read

Ben Johnston in SQL Server

How to successfully execute a SQL Server hardware audit (complete guide)

Learn how to audit SQL Server hardware and Azure cloud configuration — covering CPU, memory, storage, OS version, and backups…

17 July 2024 14 min read

Ben Johnston in SQL Server

SQL Server Audit Checklist: Discovery & Setup

Audit SQL Server with a structured discovery checklist. Covers server configuration, disk and memory, backups, security, database settings, and code…

06 June 2024 30 min read