RT information
| RT |
microsoft.sql/servers
|
| RT display name |
Azure SQL Server
|
RT type only
(without RP) |
servers
|
| RT sub- Resource types |
sub-Resource types: 169
|
| RT schema |
RT schema API versions: 20
|
| All Microsoft Azure RTs |
AzResourceTypesAdvertizer |
Aliases and Azure Policy
Aliases |
aliases: 37
|
Azure Policy |
Azure Policy definitions: 42
• if: 42
• then.deployment: 1
• then.details: 0
• then.existenceCondition: 0
• then.operations: 0
|
RBAC Operations and Roles & Roles related operation actions
RBAC operations |
RBAC operations: 8
• RBAC operationType action: 5
• RBAC operationType delete: 1
• RBAC operationType read: 1
• RBAC operationType write: 1
|
RBAC Roles & Operation actions |
Unique RBAC Roles: 22
• RBAC Roles with action operationType: 5
• RBAC Roles with delete operationType: 5
• RBAC Roles with read operationType: 22
• RBAC Roles with write operationType: 6
|
Capabilities & Locations
Diagnostic logs |
False
|
Diagnostic metrics |
False
|
Customer-managed key (CMK) [experimental] |
True
• Microsoft Learn
• Enforce Encryption with a customer-managed key (CMK) at scale
|
System-Assigned-Resource-Identity |
True
|
Cross-ResourceGroup-Resource-Move |
True
|
Cross-Subscription-Resource-Move |
True
|
Tags |
True
|
Extension |
False
|
Private-Endpoint |
True
|
Supported Locations for Private-Endpoint |
Supported Locations for Private-Endpoint: 44
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, jioindiawest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
|
| Non supported Locations for Private-Endpoint |
Non supported Locations for Private-Endpoint: 14
brazilus, eastusstg, centraluseuap, eastus2euap, southcentralusstg, southafricawest, australiacentral2, jioindiacentral, francesouth, germanynorth, norwaywest, switzerlandwest, uaecentral, brazilsoutheast
|
Location |
True
|
Locations |
Locations: 43
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
|
| Not locations |
Not locations: 54
asia, asiapacific, australia, australiacentral2, brazil, brazilsoutheast, brazilus, canada, centraluseuap, centralusstage, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, francesouth, germany, germanynorth, global, india, indonesia, israel, italy, japan, jioindiacentral, jioindiawest, korea, mexico, newzealand, northcentralusstage, norway, norwaywest, poland, qatar, singapore, southafrica, southafricawest, southcentralusstage, southcentralusstg, southeastasiastage, spain, sweden, switzerland, switzerlandwest, taiwan, uae, uaecentral, uk, unitedstates, unitedstateseuap, westus2stage, westusstage
|
|
|
Infrastructure as Code (IaC)
ARM (Azure Resource Manager) templates |
ARM (Azure Resource Manager) template API versions: 20
• latest
|
Bicep templates |
Bicep template API versions: 20
• latest
|
Terraform provider |
Terraform providers: 1
• mssql_server
|
AzAPI Terraform templates |
AzAPI Terraform template API versions: 20
• latest
|
Pulumi provider |
Pulumi providers: 1
• sql/server
|
OpenTofu provider |
OpenTofu TF providers: 1
• mssql_server
|
Azure Verified Modules (AVM) Bicep |
Azure SQL Server
|
Azure Verified Modules (AVM) Terraform |
• GitHub: Azure SQL Server
• Terraform registry: Azure SQL Server
|
REST-API (Representational State Transfer - Application Programming Interface)
| REST-API versions |
REST-API versions: 26
• 2024-08-01-preview
• 2024-05-01-preview
• 2023-08-01-preview
• 2023-08-01
• 2023-05-01-preview
• 2023-02-01-preview
• 2022-11-01-preview
• 2022-08-01-preview
• 2022-05-01-preview
• 2022-02-01-preview
• 2021-11-01-preview
• 2021-11-01
• 2021-08-01-preview
• 2021-05-01-preview
• 2021-02-01-preview
• 2020-11-01-preview
• 2020-08-01-preview
• 2020-02-02-preview
• 2019-06-01-preview
• 2018-06-01-preview
• 2017-10-01-preview
• 2017-03-01-preview
• 2015-05-01-preview
• 2014-04-01-preview
• 2014-04-01
• 2014-01-01
|
| REST-API version default |
n/a
|
| API profiles |
n/a
|
Resource naming
Azure Naming Tool |
The Azure Naming Tool was created to help administrators define and manage their naming conventions, while providing a simple interface for users to generate a compliant name.
|
| Resource naming details |
[
{
"property": "Azure SQL Data Warehouse",
"ShortName": "sqldw",
"scope": "global",
"lengthMin": "1",
"lengthMax": "63",
"validText": "Lowercase letters, numbers, and hyphens.",
"invalidText": "Can't start or end with hyphen.",
"invalidCharacters": "",
"invalidCharactersStart": "-",
"invalidCharactersEnd": "-",
"invalidCharactersConsecutive": "",
"regx": "^(?!-.*)(?!.*-$)[a-z0-9-]{1,63}$",
"staticValues": ""
},
{
"property": "Azure SQL Database Server",
"ShortName": "sql",
"scope": "global",
"lengthMin": "1",
"lengthMax": "63",
"validText": "Lowercase letters, numbers, and hyphens.",
"invalidText": "Can't start or end with hyphen.",
"invalidCharacters": "",
"invalidCharactersStart": "-",
"invalidCharactersEnd": "-",
"invalidCharactersConsecutive": "",
"regx": "^(?!-.*)(?!.*-$)[a-z0-9-]{1,63}$",
"staticValues": ""
}
]
|
|
Resource provider (RP) - Microsoft SQL Database [Microsoft.Sql]
