Query: Azure Defender for Azure SQL Database servers should be enabled

Description

Azure Defender for SQL provides functionality for surfacing and mitigating potential database vulnerabilities, detecting anomalous activities that could indicate threats to SQL databases, and discovering and classifying sensitive data.

Query

Tables used in this query:

• azure_security_center_subscription_pricing
• azure_subscription

Controls using this query:

• 2.1.3 Ensure That Microsoft Defender for (Managed Instance) Azure SQL Databases Is Set To 'On'
• 2.1.4 Ensure That Microsoft Defender for Azure SQL Databases Is Set To 'On'
• 2.1.4 Ensure That Microsoft Defender for Azure SQL Databases Is Set To 'On'
• 2.3 Ensure that Azure Defender is set to On for Azure SQL database servers
• 2.3 Ensure that Microsoft Defender for Azure SQL Databases is set to 'On'
• 3.1.7.3 Ensure That Microsoft Defender for (Managed Instance) Azure SQL Databases Is Set To 'On'
• 8.1.7.3 Ensure That Microsoft Defender for (Managed Instance) Azure SQL Databases Is Set To 'On'
• 9.1.7.3 Ensure That Microsoft Defender for (Managed Instance) Azure SQL Databases Is Set To 'On'
• Azure Defender for Azure SQL Database servers should be enabled

SQL