22-25 April 2026 
SQLBits 2011
Hey PowerShell Eventing, can you notify me ?
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a balloon notification in Windows task bar showing immediately what happened? Or an email ? and using the same PowerShell session
In this session will see the power of the events in PowerShell, with WMI and SMO events.
How to type code these events in PowerShell, thinking as PowerShell.
Create advanced functions to work with the features of PowerShell as consistency (Pipeline)
Understand how the pipeline works and how it can be really useful to you, as not working with loops, but with objects.
How to work with background Powershell Jobs
Create permanent WMI events with these notification, in other words, notification still alive if you restart the server.
In this session will see the power of the events in PowerShell, with WMI and SMO events.
How to type code these events in PowerShell, thinking as PowerShell.
Create advanced functions to work with the features of PowerShell as consistency (Pipeline)
Understand how the pipeline works and how it can be really useful to you, as not working with loops, but with objects.
How to work with background Powershell Jobs
Create permanent WMI events with these notification, in other words, notification still alive if you restart the server.
Speakers
Laerte Junior's previous sessions
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.
The Posh DBA: Troubleshooting SQL Server with PowerShell
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
Hey PowerShell Eventing, can you notify me ?
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?