Skip to main content

MssqlServer


Resource Icon​

Resource Overview​

Azure SQL Database is a fully managed relational database service provided by Microsoft Azure, based on the widely used Microsoft SQL Server engine. It allows you to create and manage SQL Server databases in the cloud without the need to manage hardware or software infrastructure. With Azure SQL Database, you can benefit from features such as automatic patching, backups, high availability, and disaster recovery. It also offers advanced functionalities like intelligent performance monitoring, automatic tuning, and advanced security features to optimize database performance and protect critical data.

Associated Resources​

Parent Resource​

Connected Resources​

Resource Setting Values​

  • version : The version of Microsoft SQL Server to use - 2.0, 12.0

  • admin_username : The administrator login for the Microsoft SQL Server

  • admin_password : The password associated with the administrator login

  • minimum_tls_version : The minimum TLS version to support on the server - 1.0, 1.1, 1.2

  • public_network_access_enabled : Allow public network access for the Server - true, false

  • firewall_rule

    • start_ip_address : The Start IP Address asscociated with the Firewall Rule
    • end_ip_address : The End IP Address asscociated with the Firewall Rule

  • security_alert_policy

    • alert_policy_state : The activation state of policy to be applied
    • disabled_alerts : List of notifications to be disabled - Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action
    • alert_retention_days : The number of days to keep in the threat detection audit logs - 0 ~ 3265
    • alert_email_account_admins : Enable sending alerts to e-mail - true, false
    • alert_email_addresses : List of e-mail addresses to which the alert is sent

  • auditing_policy

    • enable_storage_destination : Enable Storage account as destination - true, false
    • enable_log_analytics_destination : Enalbed Auditing policy by Log analytics workspace - true, false

  • tag : Tag to categorize resources - up to 512 characters, key:value

Reference Materials​