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
Requirements
- Resource group must been created with a valid name and location.
Input values
- tagBillingIdentifier : BillingIdentifier tag.
- sqsAdminLogin
- sqsAdminLoginPassword
Output values
- sqsName
- sqsResourceId
Compliance Advisor details
Resource Health Result
| Message | ResourceType | Severity |
|---|---|---|
| Azure Defender for SQL server should be enabled | Microsoft.Sql/servers | 3 |
| 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 | 2 |
| Your current API Version i.e.2019-06-01-preview for the resource Microsoft.Sql/servers is outdatedconsider updating to new recent version available i.e. 2022-11-01-preview or 2022-08-01-preview | Microsoft.Sql/servers | 2 |
| It is recommended to use tags for your resource, which is currently missing | Microsoft.Sql/servers | 1 |
| To help other contributors understand the purpose of the resource, specify comments for each resource in the template | Microsoft.Sql/servers | 1 |
| Auditing on SQL Server should be enabled | Microsoft.Sql/servers | 1 |
| Enable SQL Vulnerability Assessment, its a service that provides visibility into your security state. Vulnerability Assessment includes actionable steps to resolve security issues and enhance your database security. | Microsoft.Sql/servers | 1 |
| It is recommended to use SQL Azure with elastic pools for multiple databases, Elastic pools enable you to purchase resources for a pool shared by multiple databases to accommodate unpredictable periods of usage by individual databases. You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based purchasing model. The resource requirement for a pool is determined by the aggregate utilization of its databases | Microsoft.Sql/servers | 1 |
| It is recommended to parameterized your tag and make it as object type | Microsoft.Sql/servers | 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. sqscutomnameRead 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. sqscutomnameRead 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. sqsAdminLoginRead More | 1 |
TemplateVariableHealthResult
| Message | Severity |
|---|---|
| It is recommended to make your variable as camel case, wherever possible for e.g. environmentRead More | 1 |
Sustainable Advisor details
| Message | ResourceType | Severity |
|---|---|---|
| It is recommended to use SQL Azure with elastic pools for multiple databases, Elastic pools enable you to purchase resources for a pool shared by multiple databases to accommodate unpredictable periods of usage by individual databases. You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based purchasing model. The resource requirement for a pool is determined by the aggregate utilization of its databases | Microsoft.Sql/servers | 1 |