Azure SQL Auditing

Question

Hello

I need to configure Azure SQL Auditing for SQL Servers and their databases, in order to verify Login records, security records and others in SQL engines in Azure and its databases.

Thanks!

Answer 1

Hello,

Welcome to Microsoft Q&A,

You can use Azure SQL Database Auditing to configure auditing in Azure SQL Server or databases. This feature tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs.

Here are the steps to configure auditing in Azure SQL Server or databases using Azure SQL Database Auditing:

1. Create an Azure storage account, Log Analytics workspace, or Event Hubs to store the audit logs.
2. Enable auditing for your Azure SQL Server or database using the Azure portal, PowerShell, or Azure CLI.
3. Configure the audit logs to be written to your Azure storage account, Log Analytics workspace, or Event Hubs.
4. Define the audit actions and groups to be audited.
5. Review the audit logs to monitor database activity.

Here is reference document https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql

YouTube Video- https://youtu.be/HeKDc-ndlYc?si=3QDdruDnBpKpVrBY

Please Upvote and Accept the Answer if it helps!!