Azure SQL Database Auditing

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.

Last Accessed Datetime for table - Easiest way

This function is used to get the complete table lists are particular table and its last access datetime.

Disconnecting Auditing

Currently we have system administrators responsible for securing our systems, including the auditing capabilities. However that's not the best way to ensure that we can protect our systems.

Auditing Matters

We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.

Event Notification on Server

Double Compliance

Sometimes auditing for one certification might help you pass another, but don't count on it.

Acing an Audit

Audits for technology groups can be time consuming and stress employees out. An article Steve Jones finds says an insurance company only needed 30 minutes to ace their audit.