ARM Template to deploy server with Auditing and Threat Detection turned ON

I would like to share an example of a template that can be used to deploy server with multiple databases and to turn ON Auditing and Threat Detection at server and individual database levels. A few guidelines: Auditing server policy can be set after creation of all databases, so you should add dependency on all databases to…

0

ARM template – turning on blob auditing

Azure SQL Database Auditing is a popular feature which helps to track events on the databases. Recently Blob Auditing was introduced, at the time of writing this post it is still a preview feature. The advantages of blob auditing over table auditing are higher performance and higher granularity. To turn on blob auditing you can…


ARM template outputs for Azure SQL Database

Azure Resource Manager (ARM) templates are a common way to deploy Azure Resources. One of the less often used features is the output. You may want to use this with linked templates to pass variables between templates, or if you like to print out some information. Here I describe how you can display Azure SQL…