Level: Introductory to Intermediate
Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it can take considerable time to gather the information needed.
In this session, we will go over some scripts that are used for compliance audits that make it easy to collect the information required. Even when there are multiple SQL Servers, these scripts and processes can quickly and easily identify where to focus efforts to ensure compliance. Through heavy demonstration and discussion, you will leave with a better equipped to understand and obtain compliance within your SQL Server environment.
You will learn:
DOD/NIST recommended practices for SQL Server
Review the use of a modular script process to easily customize data collection to your needs and/or requirements
Be able to quickly check the security state of your SQL Servers, no matter how many you have