Alerts From Azure Automation

In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However, what I didn't show was how to generate an alert when things go south. Let's do that now. An Error Needing an Alert First, I need to generate an error. I'm going to modify the code just slightly from the previous example so that it will fail: [crayon-5a6c2035f1e34695331042/] If I modify my Runbook with the code above and then run it, I will get an error: This is from the test pane. I strongly recommend you use tests on your PowerShell scripts when writing your own automation. It'll save you a lot of pain trying to troubleshoot things later. Alert on Error Believe it or not, there's not an immediately…
Read More

SCOM As a Code Source

A friend has had an article posted over on SQL Server Central that's worth a read. Scott Abrants outlines the type of code that SCOM uses for SQL Server auditing and how you can leverage that outside of SCOM for other work you may be doing. As noted in the comments, it's also worth taking a look at how Microsoft set up it's rules and monitors as a method for setting up your own.
Read More