Description:
Enable "Microsoft Defender for SQL" on critical SQL Servers.
Rationale:
Microsoft Defender for SQL is a unified package for advanced SQL security capabilities. Microsoft Defender is available for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It includes functionality for discovering and classifying sensitive data, surfacing and mitigating potential database vulnerabilities, and detecting anomalous activities that could indicate a threat to your database. It provides a single go-to location for enabling and managing these capabilities.
Microsoft Defender for SQL is a paid feature and will incur additional cost for each SQL server.
From Azure Portal
From Powershell
Enable 'Advanced Data Security' for a SQL Server:
Set-AzSqlServerThreatDetectionPolicy -ResourceGroupName -ServerName -EmailAdmins $True
Note: