Auditing SQL Server – Part 3 – SQL Server Configuration Audit

This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. The next section went over server hardware configuration and audits. This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.

The format follows the server audit format. A general template is presented first, followed by interpreting those configuration items and ends with methods to explore and list those configurations.

General Audit Template