locked
SQL Server Audit Feature for SQL Azure RRS feed

  • Question

  • What is the status of support for SQL Server Audit features in SQL Azure?  If auditing is supported in SQL Azure, can you point me to some resources that describe best practices for using auditing in SQL Azure?

    Monday, March 15, 2010 10:58 PM

Answers

  • Hello, one reason that server level auditing is not available is: The server you see on the SQL Azure portal is actually just a logical container for your databases. It is not a physical server. Your databases may share a physical server with other users' databases, or they may not. So server level auditing is not available (otherwise you can see other users' login events).

    Database level auditing may be available in the future. Sorry I don't have a specific time. But you can submit a feature request on http://www.mygreatwindowsazureidea.com/pages/34685-sql-azure-feature-voting.
    Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yi-Lun Luo Monday, March 22, 2010 9:43 AM
    Tuesday, March 16, 2010 2:00 AM

All replies

  • Hello, one reason that server level auditing is not available is: The server you see on the SQL Azure portal is actually just a logical container for your databases. It is not a physical server. Your databases may share a physical server with other users' databases, or they may not. So server level auditing is not available (otherwise you can see other users' login events).

    Database level auditing may be available in the future. Sorry I don't have a specific time. But you can submit a feature request on http://www.mygreatwindowsazureidea.com/pages/34685-sql-azure-feature-voting.
    Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yi-Lun Luo Monday, March 22, 2010 9:43 AM
    Tuesday, March 16, 2010 2:00 AM
  • New feature in Azure SQL Database!

    Azure SQL Database Auditing tracks database events and writes audited events to an audit log in your Azure Storage account. Auditing is available in preview for Basic, Standard, and Premium service tiers. Auditing can help you maintain regulatory compliance, understand database activity, and gain insight into discrepancies and anomalies that could indicate business concerns or suspected security violations.

    See Get started with SQL database auditing http://azure.microsoft.com/en-us/documentation/articles/sql-database-auditing-get-started/


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Monday, August 4, 2014 4:21 PM