Query: Ensure that Microsoft Defender for SQL is set to 'On' for critical SQL Servers

Description

Enable "Azure Defender for SQL" on critical SQL Servers.

Query

Tables used in this query:

• azure_sql_server
• azure_subscription

Controls using this query:

• 4.2.1 Ensure that Advanced Threat Protection (ATP) on a SQL server is set to 'Enabled'
• 4.2.1 Ensure that Advanced Threat Protection (ATP) on a SQL server is set to 'Enabled'
• 4.2.1 Ensure that Microsoft Defender for SQL is set to 'On' for critical SQL Servers
• 4.2.1 Ensure that Microsoft Defender for SQL is set to 'On' for critical SQL Servers
• Ensure that Microsoft Defender for SQL is set to 'On' for critical SQL Servers

SQL