Query: SQL databases transparent data encryption should be enabled

Description

Transparent data encryption should be enabled to protect data-at-rest and meet compliance requirements.

Query

Tables used in this query:

• azure_sql_database
• azure_subscription

Controls using this query:

• 4.1.2 Ensure that 'Data encryption' is set to 'On' on a SQL Database
• 4.1.2 Ensure that 'Data encryption' is set to 'On' on a SQL Database
• 4.1.5 Ensure that 'Data encryption' is set to 'On' on a SQL Database
• 4.1.5 Ensure that 'Data encryption' is set to 'On' on a SQL Database
• 4.1.5 Ensure that 'Data encryption' is set to 'On' on a SQL Database
• 5.1.5 Ensure that 'Data encryption' is set to 'On' on a SQL Database
• SQL databases transparent data encryption should be enabled

SQL