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 1
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