適用於 Azure SQL Database 與 SQL 受控執行個體的 Azure Resource Manager 範本Azure Resource Manager templates for Azure SQL Database & SQL Managed Instance

適用於: Azure SQL Database Azure SQL 受控執行個體

Azure Resource Manager 範本可讓您定義基礎結構即程式碼,並將解決方案部署至 Azure 雲端,以供 Azure SQL Database 與 SQL 受控執行個體使用。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.

下表包含適用於 Azure SQL Database 的 Azure Resource Manager 範本的連結。The following table includes links to Azure Resource Manager templates for Azure SQL Database.

連結Link 描述Description
SQL DatabaseSQL Database 此 Azure Resource Manager 範本可在 Azure SQL Database 中建立單一資料庫,並設定伺服器層級 IP 防火牆規則。This Azure Resource Manager template creates a single database in Azure SQL Database and configures server-level IP firewall rules.
ServerServer 此 Azure Resource Manager 範本可建立 Azure SQL Database 的伺服器。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 此範本可在 Azure SQL Database 中建立兩部伺服器、單一資料庫與一個容錯移轉群組。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. 「威脅偵測」包含在 SQL 進階威脅防護 (ATP) 供應項目中,可提供一層安全性來防禦伺服器與資料庫所受到的潛在威脅。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.
將稽核資料移至 Azure Blob 儲存體Auditing to Azure Blob storage 此範本可讓您部署啟用稽核的伺服器,以將稽核記錄寫入至 Blob 儲存體。This template allows you to deploy a server with auditing enabled to write audit logs to a Blob storage. Azure SQL Database 的稽核可追蹤資料庫事件,並將其寫入至可存放在 Azure 儲存體帳戶、OMS 工作區或事件中樞的稽核記錄中。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.
將稽核資料移至 Azure 事件中樞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. 若要將稽核事件傳送到事件中樞,請設定 Enabled State 的稽核設定,並將 IsAzureMonitorTargetEnabled 設為 trueIn order to send audit events to Event Hubs, set auditing settings with Enabled State, and set IsAzureMonitorTargetEnabled as true. 此外,請在 master 資料庫上設定 SQLSecurityAuditEvents 記錄類別的診斷設定 (用於服務層級稽核)。Also, configure Diagnostic Settings with the SQLSecurityAuditEvents log category on the master database (for server-level auditing). 稽核可追蹤資料庫事件,並將其寫入至可存放在 Azure 儲存體帳戶、OMS 工作區或事件中樞的稽核記錄中。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 應用程式與 SQL DatabaseAzure Web App with SQL Database 此範本可在「基本」服務層級,於 Azure SQL Database 中建立免費的 Azure Web 應用程式與資料庫。This sample creates a free Azure web app and a database in Azure SQL Database at the "Basic" service level.
Azure Web 應用程式、Redis 快取與 SQL DatabaseAzure Web App and Redis Cache with SQL Database 此範本可在相同的資源群組中建立 Web 應用程式、Redis 快取和資料庫,並且在 Web 應用程式中針對資料庫和 Redis 快取建立兩個連接字串。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.
使用 ADF V2 從 Blob 儲存體匯入資料Import data from Blob storage using ADF V2 此 Azure Resource Manager 範本可建立能夠將資料從 Azure Blob 儲存體複製到 SQL Database 的 Azure Data Factory 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 叢集與資料庫HDInsight cluster with a database 此範本可讓您建立 HDInsight 叢集、邏輯 SQL 伺服器、資料庫與兩個資料表。This template allows you to create an HDInsight cluster, a logical SQL server, a database, and two tables. 搭配使用 Sqoop 與 HDInsight 中的 Hadoop 一文中使用了此範本。This template is used by the Use Sqoop with Hadoop in HDInsight article.
依排程執行 SQL 預存程序的 Azure 邏輯應用程式Azure Logic App that runs a SQL Stored Procedure on a schedule 此範本可讓您建立會依排程執行 SQL 預存程序的邏輯應用程式。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.