Azure Resource Manager templates for Azure SQL Database & SQL Managed Instance

APPLIES TO: Azure SQL Database Azure SQL Managed Instance

Azure Resource Manager templates enable you to define your infrastructure as code and deploy your solutions to the Azure cloud for Azure SQL Database and Azure SQL Managed Instance.

The following table includes links to Azure Resource Manager templates for Azure SQL Database.

Link Description
SQL Database This Azure Resource Manager template creates a single database in Azure SQL Database and configures server-level IP firewall rules.
Server This Azure Resource Manager template creates a server for Azure SQL Database.
Elastic pool This template allows you to deploy an elastic pool and to assign databases to it.
Failover groups This template creates two servers, a single database, and a failover group in Azure SQL Database.
Threat Detection This template allows you to deploy a server and a set of databases with Threat Detection enabled, with an email address for alerts for each database. Threat Detection is part of the SQL Advanced Threat Protection (ATP) offering and provides a layer of security that responds to potential threats over servers and databases.
Auditing to Azure Blob storage This template allows you to deploy a server with auditing enabled to write audit logs to a Blob storage. Auditing for Azure SQL Database tracks database events and writes them to an audit log that can be placed in your Azure storage account, OMS workspace, or Event Hubs.
Auditing to Azure Event Hub This template allows you to deploy a server with auditing enabled to write audit logs to an existing event hub. In order to send audit events to Event Hubs, set auditing settings with Enabled State, and set IsAzureMonitorTargetEnabled as true. Also, configure Diagnostic Settings with the SQLSecurityAuditEvents log category on the master database (for server-level auditing). Auditing tracks database events and writes them to an audit log that can be placed in your Azure storage account, OMS workspace, or Event Hubs.
Azure Web App with SQL Database This sample creates a free Azure web app and a database in Azure SQL Database at the "Basic" service level.
Azure Web App and Redis Cache with SQL Database This template creates a web app, Redis Cache, and database in the same resource group and creates two connection strings in the web app for the database and Redis Cache.
Import data from Blob storage using ADF V2 This Azure Resource Manager template creates an instance of Azure Data Factory V2 that copies data from Azure Blob storage to SQL Database.
HDInsight cluster with a database This template allows you to create an HDInsight cluster, a logical SQL server, a database, and two tables. This template is used by the Use Sqoop with Hadoop in HDInsight article.
Azure Logic App that runs a SQL Stored Procedure on a schedule This template allows you to create a logic app that will run a SQL stored procedure on schedule. Any arguments for the procedure can be put into the body section of the template.
Provision server with Azure AD-only authentication enabled This template creates a SQL logical server with an Azure AD admin set for the server and Azure AD-only authentication enabled.