SQL Server Administration & Maintenance

SQH02 Using Modular Scripts to Perform SQL Compliance Audits in Seconds


8:00am - 9:15am

Level: Introductory to Intermediate

Chris Bell

WaterOx Consulting, Inc.

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