Short Auditing Retention Period for SQL Servers
Auditing retention period should be greater than defined days. Default 90 days.
Auditing retention period should be greater than defined days. Default 90 days.
Enable auditing for all SQL Servers.
Enable threat detection for all SQL servers.
Do not disable alerts related to threat detections.
Specify email addresses and ensure that alerts are sent to them.
Threat detection retention period should be greater than defined days. Default 90 days.
Set an Azure Active Directory admin for every SQL server.
Auditing retention period should be greater than defined days. Default 90 days.
Enable auditing for all SQL Databases.
Enable threat detection for all SQL Databases.
Enable alerts related to threat detections.
Specify email addresses and ensure that alerts are sent to them.
Threat detection retention period should be greater than defined days. Default 90 days.
Enable transparent data encryption for all SQL databases.
Configure the 'AuditActionGroups' property to appropriate groups to capture all the critical activities on the SQL Server and all the SQL databases hosted on the SQL server.