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

[2018-07-31] Note: new template version is now available. It includes 3 changes: There is no reason to enable both server policy and database policy. It is enough to enable only server policy. No need to supply storage account for Threat Detection policy. It is needed only for auditing Use the updated API version for auditing…

0

Lesson Learned #34: Does Azure SQL Database support OPENJSON?

The answer is Yes! but your database needs to have in the compatibility level 130 or above. If your database compatibility level is less than 130 you could get an error about “incorrect syntax near the keywork with” or “invalid syntax”.   Please, follow these steps to read a JSON file from a Azure Blob…