Azure Defender for SQL

Azure Defender for SQL groups together the advanced SQL security capabilities, vulnerability assessment and Advanced Threat Protection. Azure Defender for SQL is priced at ~$15/per server/month and has a one-month free trial.

To enable Azure Defender for SQL from the Azure portal, navigate to the SQL Server page and then select Security Center from the Security section.

Enable Azure Defender for SQL by clicking on the toggle button. Provide an Azure storage account for the vulnerability assessment and an email address to send alerts. You can choose to run periodic recurring vulnerability scans by enabling the Periodic recurring scans option:

Figure 6.84: Enabling Azure Defender for SQL

We can enable the Auditing feature for better threat investigation. We can choose to enable specific, or all, ADVANCED THREAT PROTECTION features.

The two security features under Azure Defender for SQL are as follows:

• Vulnerability...