Skip to main content

MssqlDatabase


Resource Icon​

Resource Overview​

Azure SQL Database (Microsoft SQL Database) is a fully managed PaaS database engine that handles most database management functions such as upgrades, patching, backups, and monitoring without user intervention.

Associated Resources​

Parent Resources​

Connected Resources​

Resource Configuration​

Basic Settings​

  • included_mssql_server_name : Name of the Microsoft SQL Server where the database will be created
  • sku_name : Pricing tier of the Microsoft SQL database
  • max_size_gb : Maximum database size (GB) - 1 ~ 1024
  • collation : Data collation method of the Microsoft SQL database
  • license_type : License type applied to the database - LicenseIncluded, BasePrice
  • min_capacity : Minimum number of vCores for autoscaling - minimum 0.5
  • auto_pause_delay_in_minutes : Idle time (minutes) before the database is automatically paused when there is no user activity - 60 ~ 10080
  • read_scale : Enables offloading read-only workloads by using the compute capacity of one of the read-only replicas - true, false
  • zone_redundant : Enables zone redundancy for database maintenance operations - true, false

Auditing Policy (auditing_policy)​

  • auditing_policy.enable_storage_destination : Whether to enable the storage account destination - true, false
  • auditing_policy.linked_storage_account_name : Storage account name
  • auditing_policy.storage_access_key_is_second : Whether to use the secondary access key for the auditing storage account - true, false
  • auditing_policy.storage_retention_days : Number of days to retain logs in the storage account
  • auditing_policy.enable_log_analytics_destination : Whether to enable auditing policy to Log Analytics workspace - true, false
  • auditing_policy.linked_log_analytics_workspace_name : Log Analytics workspace auditing policy name
  • auditing_policy.log_analytics_diagnostic_setting_name : Log Analytics workspace name

Tags​

  • tag : Tags used to categorize resources - maximum 512 characters, key:value

References​