Azure SQL Elastic Pool resources must use standard naming

November 27, 2025 ยท View on GitHub

SYNOPSIS

Azure SQL Elastic Pool resources without a standard naming convention may be difficult to identify and manage.

DESCRIPTION

An effective naming convention allows operators to quickly identify resources, related systems, and their purpose. Identifying resources easily is important to improve operational efficiency, reduce the time to respond to incidents, and minimize the risk of human error.

Some of the benefits of using standardized tagging and naming conventions are:

  • They provide consistency and clarity for resource identification and discovery across the Azure Portal, CLIs, and APIs.
  • They enable filtering and grouping of resources for billing, monitoring, security, and compliance purposes.
  • They support resource lifecycle management, such as provisioning, decommissioning, backup, and recovery.

For example, if you come upon a security incident, it's critical to quickly identify affected systems, the functions that those systems support, and the potential business impact.

For Azure SQL Elastic Pool, the Cloud Adoption Framework (CAF) recommends using the sqlep- prefix.

Requirements for Azure SQL Elastic Pool resource names:

  • Between 1 and 128 characters long.
  • Letters, numbers, and special characters except: <>*%&:\/?
  • Can't end with period or a space.
  • Must be unique for each logical server.

RECOMMENDATION

Consider creating Azure SQL Elastic Pool resources with a standard name. Additionally consider using Azure Policy to only permit creation using a standard naming convention.

EXAMPLES

Configure with Bicep

To deploy resources that pass this rule:

  • Set the name property to a string that matches the naming requirements.
  • Optionally, consider constraining name parameters with minLength and maxLength attributes.

For example:

@minLength(1)
@maxLength(128)
@description('The name of the resource.')
param name string

@description('The location resources will be deployed.')
param location string = resourceGroup().location

resource pool 'Microsoft.Sql/servers/elasticPools@2024-05-01-preview' = {
  parent: server
  name: name
  location: location
  properties: {
    perDatabaseSettings: {
      minCapacity: 0
      maxCapacity: 2
    }
    maxSizeBytes: 34359738368
    zoneRedundant: true
    licenseType: 'BasePrice'
    maintenanceConfigurationId: maintenanceConfigurationId
  }
}

Configure with Azure template

To deploy resources that pass this rule:

  • Set the name property to a string that matches the naming requirements.
  • Optionally, consider constraining name parameters with minLength and maxLength attributes.

For example:

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 128,
      "metadata": {
        "description": "The name of the resource."
      }
    },
    "location": {
      "type": "string",
      "defaultValue": "[resourceGroup().location]",
      "metadata": {
        "description": "The location resources will be deployed."
      }
    }
  },
  "resources": [
    {
      "type": "Microsoft.Sql/servers/elasticPools",
      "apiVersion": "2024-05-01-preview",
      "name": "[format('{0}/{1}', parameters('name'), parameters('name'))]",
      "location": "[parameters('location')]",
      "properties": {
        "perDatabaseSettings": {
          "minCapacity": 0,
          "maxCapacity": 2
        },
        "maxSizeBytes": 34359738368,
        "zoneRedundant": true,
        "licenseType": "BasePrice",
        "maintenanceConfigurationId": "[parameters('maintenanceConfigurationId')]"
      }
    }
  ]
}

NOTES

This rule does not check if Azure SQL Elastic Pool resource names are unique.

Rule configuration

To configure this rule set the AZURE_SQL_ELASTIC_POOL_NAME_FORMAT configuration value to a regular expression that matches the required format.

For example:

configuration:
  AZURE_SQL_ELASTIC_POOL_NAME_FORMAT: '^sqlep-'