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?
2010-06-04
4,738 reads
This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.
2010-05-05
6,127 reads
This article examines the various methods for retrieving data from an Audit table.
2010-04-09
3,419 reads
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.
2010-03-31
2,478 reads
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.
2010-03-15
2,121 reads
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.
2010-02-17
5,905 reads
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.
2009-12-28
2,590 reads
The second in the Security Audit series looks at securing an individual database.
2009-09-01
3,028 reads
Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.
2009-07-16
5,877 reads
With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.
2009-07-08
6,271 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers