Saturday, August 27th, in Omaha, NE, we are hosting a SQL Saturday event that is promising to be a great time. This is a free event ($10 lunch fee if you want lunch on us) that helps promote our local SQL PASS chapter. Register here: http://www.sqlsaturday.com/91/eventhome.aspx
I will be presenting on two topics: SSIS changes in Denali, and Using Event Notifications for Monitoring SQL Instances.
The first session, SSIS Changes in Denali, is pretty self-explanatory. Expect that I will go through each of the major changes in demo form, with some discussions around each.
The second session around Event Notifications, will be quite a bit more advanced and will talk about using the Event Notifications infrastructure in SQL Server combined with Service Broker to implement a very robust monitoring system. This infrastructure allows for capturing all kinds of audit information such as creating a table, dropping an index, rebuilding statistics, blocking, deadlocks, etc… There’s quite a bit of information that can be captured. I will show how to set this up and how to consume the information for monitoring purposes.
Don’t miss your chance at seeing me speak (!) and most importantly don’t miss your chance at learning SQL Server topics for free. See you there!
An event flyer can be found here: http://www.ssistalk.com/Flyer_updated.pdf Please distribute as you see fit!