SQL Audit

SQL Audit

Tables and Views for Auditing SQL Server Logins

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

Finding Jobs

This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.

Retrieving Data from an Audit Table

This article examines the various methods for retrieving data from an Audit table.

SQL Server 2008 - Accessing Audit Details

Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.

SQL Server 2008 Audit Change Group

Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with.

Database Level Auditing with Microsoft SQL Server 2008

MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.

Auditing in SQL Server 2008

Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.

SQL Server Security Audit (Part 2) - Database Level Audit

The second in the Security Audit series looks at securing an individual database.