Deploy an Azure SQL Server with Auditing enabled to write audit logs to a blob storage
{"type": "microsoft.sql/servers", "name": "[concat(variables('targetservername'))]", "apiversion": "2020-02-02-preview", "location": "[parameters('location')]", "properties": {"administratorlogin": "[parameters('targetsqldbadministratorlogin')]", "administratorloginpassword": "[parameters('targetsqldbadministratorpassword')]", "version": "12.0"}, "resources": [{"type": "databases", "sku": {"name": "s3", "tier": "standard"}, "name": "[variables('databasename')]", "apiversion": "2020-02-02-preview", "location": "[parameters('location')]", "dependson": ["[resourceid('microsoft.sql/servers", concat(variables('targetservername')))]"], "properties": {"collation": "sql_latin1_general_cp1_ci_as", "maxsizebytes": 2147483648, "zoneredundant": false}, "resources": [{"name": "import", "type": "extensions", "apiversion": "2014-04-01", "dependson": ["[resourceid('microsoft.sql/servers/databases", variables('targetservername'), variables('databasename'))]"], "properties": {"storagekey": "[parameters('_artifactslocationsastoken')]", "storagekeytype": "sharedaccesskey", "storageuri": "[uri(parameters('_artifactslocation'), "templatefiles/adventureworks2016.bacpac')]", "administratorlogin": "[parameters('targetsqldbadministratorlogin')]", "administratorloginpassword": "[parameters('targetsqldbadministratorpassword')]", "operationmode": "import"}}]}, {"type": "firewallrules", "name": "allowallwindowsazureips", "apiversion": "2020-02-02-preview", "location": "[parameters('location')]", "dependson": ["[resourceid('microsoft.sql/servers", concat(variables('targetservername')))]"], "properties": {"endipaddress": "0.0.0.0", "startipaddress": "0.0.0.0"}}]} 