Back to Azure Resource templates index <–
A SQL database engine, based on the Enterprise Edition of SQL Server, that is optimized for modern application development.
Template Locations
Infrastructure As Code Advisor (Beta)
WAF-compliance
The WAF-compliance advisor validates templates based on the Well Architected Framework practices. Every day a GitHub Action updates the templates compliance data and lists the recomendations.
Sustainbility Advisor
The sustainability advisor is based on the Sogeti Cloud Reference Architecture with sustainble practices. These sustainble practices cover application code, cloud infrastructures and data. The global Sogeti community is continously evolving the sustainble practices and every day new and tuned are added. For cloud infrastructures the sustainble practices are automatically validated and reported below.
note: when 100% it can be that there is no sustainble practices yet for this Cloud infrastructure.
Online documentation
Template reference
Service description
Related Azure Resources
| Resource | Description | Automation |
|---|---|---|
| Allows you to manage an Azure SQL Database | Allows you to manage an Azure SQL Database | TerraformModule |
Requirements
- A SQL server is required to deploy a SQL Database upon
Input values
- tagBillingIdentifier : BillingIdentifier tag.
-
sdbFreetext: 1-100 FreeText for the name of the database -
sdbEdition : Basic”,”Standard”,”Premium” “Basic” Edition for the database -
sdbPerformanceLevel : Basic”,”S0”,”S1”,”S2”,”S3”,”P1”,”P2”,”P3” “Basic” Performance level for the database -
sdbMaxSizeBytes : 1 byte - 1 Tb 1 Gb/ 1073741824 bytes Max size in bytes for the database - sdbTag : The business application name
-
sdbCollation : The collation for the database SQL_Latin1_General_CP1_CI_AS - sqsName : ServerName
Output values
- sdbName : Outputs the name of the created SQL Database
- sdbResourceId : Outputs the resourceId of the created SQL Database
Additional information
The template containes the basic settings for an Azure SQL Database, only the SQL Server name, max size, edition, performance level, collation and the resource group needs to be specified. Specfic configuration needs can be set with the [https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-cli).
Compliance Advisor details
Resource Health Result
| Message | ResourceType | Severity |
|---|---|---|
| Location for the resource should not be hardcoded, it should be parameterized and should refer from Resource Group's location i.e. [resourceGroup().location] | Microsoft.Sql/servers/databases | 2 |
| It is recommended to use tags for your resource, which is currently missing | Microsoft.Sql/servers/databases | 1 |
| To help other contributors understand the purpose of the resource, specify comments for each resource in the template | Microsoft.Sql/servers/databases | 1 |
| It is recommended to parameterized your tag and make it as object type | Microsoft.Sql/servers/databases | 1 |
TemplateParameterHealthResult
| Message | Severity |
|---|---|
| Define default values for parameters that aren't sensitive. By specifying a default value, it's easier to deploy the template, and users of your template see an example of an appropriate value i.e. tagBillingIdentifierRead More | 1 |
| It is recommended to make your parameter as camel case, wherever possible for i.e. sdbcustomnameRead More | 1 |
| Define default values for parameters that aren't sensitive. By specifying a default value, it's easier to deploy the template, and users of your template see an example of an appropriate value i.e. sdbcustomnameRead More | 1 |
| It is recommended to add description for your parameters i.e. for sdbSkuTierRead More | 1 |
| Define default values for parameters that aren't sensitive. By specifying a default value, it's easier to deploy the template, and users of your template see an example of an appropriate value i.e. sdbMaxSizeBytesRead More | 1 |
TemplateVariableHealthResult
| Message | Severity |
|---|---|
| It is recommended to make your variable as camel case, wherever possible for e.g. environmentRead More | 1 |