Creating Azure SQL Database Managed Instances Via ARM Templates

Jovan Popovic shows how us how to build a Managed Instance of Azure SQL Database using Powershell and an ARM template:

Values that you need to change in this request are:

• name – name of your Azure SQL Managed Instance (don’t include domain).

• properties/administratorLogin – SQL login that will be used to connect to the instance.

• properties/subnetId – Azure identifier of the subnet where Azure SQL Managed Instance should be placed. Make sure that you properlyconfigure network for Azure SQL Managed Instance

• location – one of the valid location for Azure data centers, for example: “westcentralus”

• sku/name: GP_Gen4 or GP_Gen5

• properties/vCores: Number of cores that should be assigned to your instance. Values can be 8, 16, or 24 if you select GP_Gen4 sku name, or 8, 16, 24, 32, or 40 if you select GP_Gen5.

• properties/storageSizeInGB: Maximum storage space for your instance. It should be multiple of 32GB.

• properties/licenceType: Choose BasePrice if you don’t have SQL Server on-premises licence that you want to use, or LicenceIncluded if you can have discount for your on-premises licence.

• tags(optional) – optionally put some key:value pairs that you would use to categorize instance.

Click through for the template and a quick Powershell script which shows how to use the template.