SQLBits 2015

Challenge Me! Capturing SQL Server Data with PowerShell

Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees are encouraged to send challenges to the presenter via email for demonstration purposes.
Any data professional who is responsible for performance tuning, has their way of gathering data to troubleshoot and solve issues. But what if I told you there was a different way, a better way, to collect the data you need without consuming additional SQL Server resources?

Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees will learn about some .Net classes to control timer events and the PowerShell Register-Objecteven cmdlet.

Attendees are encouraged to send their challenges to me by email. They can find additional details and instructions in my blog post -> http://goo.gl/Q2GjH3   I will review their scripts and select some of them to demonstrate in the session by offering an alternative using PowerShell and the event subsystem.