Azure SQL Auditing of Microsoft support operations is now generally available

Published Mar 15 2021 05:08 AM 1,718 Views
Microsoft

Microsoft has always had a strong commitment to provide full transparency for every operation performed during incidents. When customers open support request, Microsoft support engineers may eventually proceed to investigate the databases and those operations must be surfaced to our customers.

 

We are delighted to announce the general availability of the capability to audit operations performed by Microsoft support engineers when they need to access customer’s SQL assets during a support request. The use of this capability, along with the regular auditing, enables more transparency into customers’ workforce and is sometimes required for compliance with regulatory standards.

 

How to enable Azure SQL Auditing of Microsoft support operations?

 

This functionality can be enabled on every Azure SQL Server by turning the feature to ON and configuring the desired destinations or programmatically (API, Azure CLI and PowerShell cmdlet). Customers can also enable Azure SQL Auditing of Microsoft support operations on every Azure SQL Managed Instance by configuring their Audit log and specifying OPERATOR_AUDIT = ON. We are now allowing customers to use a single audit configuration for their SQL audit logs and the Auditing of Microsoft support operations.

 

DavidTrigano_0-1615807871784.png

 

 

How to investigate SQL audit logs of Microsoft support operations?

 

When Azure SQL Auditing of Microsoft support operations is configured to a storage account destination, customers can access the audit logs in the same way for Azure SQL Auditing or Azure SQL Auditing of Microsoft support operations.

When Azure SQL Auditing of Microsoft support operations is configured to a Log Analytics Workspace or an Event Hub destination, the audit logs will be audited under a new category called "DevOpsOperationsAudit".

 

 

For more details on Auditing of Microsoft support operations for Azure SQL Server and Azure SQL Managed Instance, see Auditing for Azure SQL Database and Auditing for Azure SQL Managed Instance documentation.

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2210771%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Auditing%20of%20Microsoft%20support%20operations%20is%20now%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2210771%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20has%20always%20had%20a%20strong%20commitment%20to%20provide%20full%20transparency%20for%20every%20operation%20performed%20during%20incidents.%20When%20customers%20open%20support%20request%2C%20Microsoft%20support%20engineers%20may%20eventually%20proceed%20to%20investigate%20the%20databases%20and%20those%20operations%20must%20be%20surfaced%20to%20our%20customers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20delighted%20to%20announce%20the%20%3CSTRONG%3Egeneral%20availability%3C%2FSTRONG%3E%20of%20the%20capability%20to%20audit%20operations%20performed%20by%20Microsoft%20support%20engineers%20when%20they%20need%20to%20access%20customer%E2%80%99s%20SQL%20assets%20during%20a%20support%20request.%20The%20use%20of%20this%20capability%2C%20along%20with%20the%20regular%20auditing%2C%20enables%20more%20transparency%20into%20customers%E2%80%99%20workforce%20and%20is%20sometimes%20required%20for%20compliance%20with%20regulatory%20standards.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EHow%20to%20enable%20Azure%20SQL%20Auditing%20of%20Microsoft%20support%20operations%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20functionality%20can%20be%20enabled%20on%20every%20Azure%20SQL%20Server%20by%20turning%20the%20feature%20to%20ON%20and%20configuring%20the%20desired%20destinations%20or%20programmatically%20(API%2C%20Azure%20CLI%20and%20PowerShell%20cmdlet).%20Customers%20can%20also%20enable%20Azure%20SQL%20Auditing%20of%20Microsoft%20support%20operations%26nbsp%3Bon%20every%20Azure%20SQL%20Managed%20Instance%20by%20configuring%20their%20Audit%20log%20and%20specifying%20OPERATOR_AUDIT%20%3D%20ON.%20We%20are%20now%20allowing%20customers%20to%20use%20a%20single%20audit%20configuration%20for%20their%20SQL%20audit%20logs%20and%20the%20Auditing%20of%20Microsoft%20support%20operations.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22DavidTrigano_0-1615807871784.png%22%20style%3D%22width%3A%20619px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263723i5C5C74EA773AF908%2Fimage-dimensions%2F619x795%3Fv%3Dv2%22%20width%3D%22619%22%20height%3D%22795%22%20role%3D%22button%22%20title%3D%22DavidTrigano_0-1615807871784.png%22%20alt%3D%22DavidTrigano_0-1615807871784.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EHow%20to%20investigate%20SQL%20audit%20logs%20of%20Microsoft%20support%20operations%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20Azure%20SQL%20Auditing%20of%20Microsoft%20support%20operations%20is%20configured%20to%20a%20storage%20account%20destination%2C%20customers%20can%20access%20the%20audit%20logs%20in%20the%20same%20way%20for%20Azure%20SQL%20Auditing%20or%20Azure%20SQL%20Auditing%20of%20Microsoft%20support%20operations.%3C%2FP%3E%0A%3CP%3EWhen%20Azure%20SQL%20Auditing%20of%20Microsoft%20support%20operations%20is%20configured%20to%20a%20Log%20Analytics%20Workspace%20or%20an%20Event%20Hub%20destination%2C%20the%20audit%20logs%20will%20be%20audited%20under%20a%20new%20category%20called%20%22%3CSTRONG%3EDevOpsOperationsAudit%3C%2FSTRONG%3E%22.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20details%20on%20Auditing%20of%20Microsoft%20support%20operations%20for%20Azure%20SQL%20Server%20and%20Azure%20SQL%20Managed%20Instance%2C%20see%20%3CA%20title%3D%22Auditing%20for%20Azure%20SQL%20Database%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fdatabase%2Fauditing-overview%23auditing-of-microsoft-support-operations%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAuditing%20for%20Azure%20SQL%20Database%3C%2FA%3E%20and%20%3CA%20title%3D%22Auditing%20for%20Azure%20SQL%20Managed%20Instance%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fmanaged-instance%2Fauditing-configure%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAuditing%20for%20Azure%20SQL%20Managed%20Instance%3C%2FA%3E%20documentation.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2210771%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20delighted%20to%20announce%20the%20general%20availability%20of%20the%20capability%20to%20audit%20operations%20performed%20by%20Microsoft%20support%20engineers%20when%20they%20need%20to%20access%20customer%E2%80%99s%20SQL%20assets%20during%20a%20support%20request.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2210771%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Managed%20Instance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Security%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Mar 15 2021 05:08 AM
Updated by: