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…


Example Python Program Reading SQL Azure Blob Auditing Data

I recently had a case that a customer needed a way to read the blob auditing data from Linux. This was the quickest and easiest way I could think of. First install msodbcsql following the instructions here https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server You will also need to install the pyodbc module.

Database Blob Auditing Policy using .NET C#

We have a good example on how to use C# to create an Azure SQL database with the Microsoft Azure SQL Management Library for .NET at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-csharp Let extend this example and see how to set database blob auditing policy: Please replace the {removed} with your blob storage account parameters. The recommended set of action groups…