Configuring Alerts for Azure SQL

1. Log in to the Azure portal with the credentials provided.

2. Click on All resources in the navigation hub menu and familiarize yourself with the Azure resources that have been provisioned, including:

   • One Azure SQL database
   • One Azure SQL server

3. Note the naming convention of the SQL resources, particularly the 5-character lab code suffix. You'll need the suffix for the storage account creation.

4. Click on + Add and search the Azure marketplace for a storage account.

5. Create the storage account with the following parameters:

   • Subscription: Leave as default.
   • Resource group: The resource group of the lab. It will be the only one available.
   • Storage account name: saXXXXX, where XXXXX is the 5-character lab suffix you previously noted.
   • Location: (US) West US
   • Performance: Standard
   • Account kind: StorageV2 (general purpose v2)
   • Replication: Locally-redundant storage (LRS)

6. Click Review + Create and then Create to create the storage account.

In the Azure portal, under All resources, click the entry for the SQL server named sqls-XXXXX, where XXXXX is a five-character unique lab ID for this lab.

Configure Firewall

1. In the sqls-XXXXX blade, click Firewalls and virtual networks.
2. Enable the setting for "Allow access to Azure services and resources to access this server" to On.
3. Click Save.

In the Azure portal, under All resources, click the entry for the SQL database named sqldb-XXXXX, where XXXXX is a five-character unique lab ID for this lab.

Configure Alert Rule

1. Click Alerts in the database blade menu.
2. Click on + New alert rule at the top of the pane.
3. In the Create rule dialog, leave the Resource as sqls-XXXXX/sqldb-XXXXX, where XXXXX is a five-character unique lab ID for this lab.
4. Under Condition, click Add.
5. In the Monitor service dropdown box, select Activity Log - Administrative, then click Export an existing database. (Microsoft.Sql/servers/databases).
6. Click Done to finalize your selection.

Configure Action Group

1. Under Actions, click Create action group.

2. In the Add action group dialog, create an action group with the following parameters:

   • Action group name: AGroup1
   • Short name: AGroup1
   • Subscription: Leave as default.
   • Resource group: Change to the resource group for the lab. NOTE: Failing to change this group will cause a failure in the alert group creation.
   • Actions:
     • Action name: Emailme
     • Action type: Email/SMS/Push/Voice

3. In the Email/SMS/Push/Voice dialog that appears, check the box next to Email and enter your email address into the Email text box.

4. Click OK to exit the dialog and OK once more to create the action group. You will be returned to the Create rule dialog.

NOTE: Once the action group has been created, you will receive an email stating you have been added as a member of the action group.

Finalize Alert Rule

1. Back in the Create rule pane, enter an Alert rule name (e.g., "SQL Database Exported"), and then press Tab.
2. A green checkbox will appear next to the alert rule name, and a Create alert rule button will appear at the bottom of the page. Click this button to create the alert rule. NOTE: Wait approximately five (5) minutes for the alert rule to become enabled before proceeding to the next objective.

1. While remaining in the SQL database blade, click on Overview at the top of the blade menu.

2. Click Export to trigger an export of the SQL database.

3. In the Export database dialog, configure the export with the following parameters:

   • File name: Leave as default
   • Subscription: Leave as default
   • Storage: Click and select the following options:
     • Storage account: The storage account created in the first objective
     • Container: Click + Container and create a new blob container named "sqlexport". Leave the Public access level set to Private (no anonymous access). Click OK to create the container. Back in the Containers dialog, click the container to select it and click Select.
   • Authentication type: Cannot be changed
   • Server admin login: azureadmin
   • Password: LA!2019!Lab1

4. Click OK to export the database.

Open your email client and wait for an email message from Microsoft Azure with the alert details. You may receive more than one email message, as multiple entries with Export an existing database (Microsoft.Sql/servers/databases) will be written to the activity log.