Speaker – Andrew J. Kelly (view bio)
Session – Getting your Daily Debrief
We will walk thru the code and process to automate the collection of several key aspects of your SQL Server instance that you should be aware of each day. This will include parsing the SQL Server Error logs, extracting key DDL / Audit events and finding the top offending SQL statements. The automation will include scheduled jobs that use standard TSQL, Extended events and PowerShell to gather and extract the necessary information so they can be loaded into tables for easy reporting.