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 using Extended Events. 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.
Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and a Data Platform MVP with over 20 years’ experience with relational databases and application development specializing in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at multiple conferences.
Claim the event and start manage its content.I am the organizer