This is one seriously powerful feature, and until now it's also been one of our best-kept secrets.
If you know PowerShell, you know how powerful it is. When coupled with SQL Diagnostic Manager, it can:
Add servers to SQL Diagnostic Manager as part of a deployment/go-live script
Turn on maintenance mode before reboot and turn off
again when back online
Add/remove users to SQL Diagnostic Manager application
security in standard permission scripts
Turn on query monitoring at the beginning of a job and off
again when finished
We're sure you can come up with even more exciting uses.
Grab a trial of SQL Diagnostic Manager and take this package of PowerShell scripts on us to get you started. Get the most out of our advanced SQL Server diagnostic, alerting, and monitoring software, and get it from that sweet command line.
See SQL Diagnostic Manager’s full list of features