It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
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 ?
This exciting session will be delivered by PowerShell expert James Boother and Clustering expert Mark Broadbent where we will demonstrate how to use PowerShell to perform SQL Failover Cluster administration and automate simple and complex operations.
I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)