Mike Fal shows how to create Azure SQL Database alerts using Powershell:
So let’s get down to brass tacks and actually create an alert. To do this, we need some info first:
The Resource Group we will create the alert in.
An Azure location where the alert will live.
An Azure SQL Database server and database we are creating the alert for.
What metric we will monitor and what is the threshold we will be checking.
(optional) An email to send an alert to.
Mike follows this up with code and shows it’s not scary at all to create these alerts from within Powershell.