Azure Q&A #4 – Azure SQL Auditing


This content was proof-read by Grammarly. You can Try Grammary for FREE

Problem

You want to store the Audit information of your SQL Azure database to Azure storage account.

Solution

One of the uses of auditing in Azure SQL and Azure Synapse Analytics is that it allows the users to track database events and then writes them to the audit log to various destinations. The destinations include


Are you a .NET Developer planning to integrate GraphQL for .NET in your Application? Check out this book BUY & DOWNLOAD GRAPHQL.NET COOKBOOK
  • Azure Storage Account
  • Log Analytics workspace
  • Event Hubs etc

You can enable Azure SQL Auditing by navigating to your SQL database and the selecting Auditing in the left sidebar. In the Azure SQL Auditing screen , check/enable “Enable Azure SQL Auditing” and select “Storage” for example. You will be prompted to select the subscription and the storage account to select. Next, click on the Save button to save the selection.

You can enable the auditing for SQL database in SQL Azure but ensure that destination i.e. storage account is in the same region as your SQL Azure database and server.

For example, if your database is in the Region EastUS , ensure that the storage account where you want the auditing information to be stored to the same location too.

References

Check the SQL Auditing docs in Azure to know more about auditing in Azure SQL.

%d bloggers like this: