Azure SQL Server threat detection alerts are not enabled for all threat types TF-S1025
Security
Enabling all Threat Detection Types protects against SQL injection, database vulnerabilities, and other possible threats. We recommend you allow all types of threat detection on SQL servers.
Recommended
resource "azurerm_mssql_server_security_alert_policy" "recommended" {
...
disabled_alerts = []
}