Configuring systems to a standard and maintaining those standards is a key aspect for meeting audit & compliance requirements. While the Windows operating system now has tools like Desired State Configuration through PowerShell and has had Group Policy Objects (GPOs) since Windows 2000, SQL Server is a little harder to maintain. While there are tools available, these tools often aren't as well known or as heavily used as their counterparts for the OS.
In this presentation we'll look at what tools are available out of the box for your SQL Server farm, where you will likely need to augment checks and corrective actions using scripts, and how to plan a custom reporting architecture to be able to show an auditor you're performing these actions regularly.
To access materials please fill out the form below.