Using SQL Monitor Groups in PowerShell

Not only are SQL Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them.

Blogs

ASF 030: Benni De Jagere interview

By

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...

Going Dark in SSMS

By

I haven’t been a big fan of dark mode in many tools, but I’ve...

Figuring Out How To Hide Production Data

By

There’s a really simple conundrum that we go through all the time. The best...

Read the latest Blogs

Forums

Query Optimization Level

By Grant Fritchey

Comments posted to this topic are about the item Query Optimization Level

Now Is a Good Time for Choices

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Now Is a Good Time...

Design ideas for hostoric data & trending

By kazim.raza

Hi everyone, I have a use case (below) for which I am considering multiple...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers