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.