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…

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…