Database Audit Specifications in SQL Server 2008
This is the final article of a three part series on Auditing in SQL Server 2008. This article shows how to setup a Database Audit Specification.
2008-09-30
2,246 reads
Auditing
2013-04-02 (first published: 2008-09-11)
15,354 reads
SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
2008-08-04
3,369 reads
SQL Server Audit in SQL Server 2008 – Part 2
Learn how to monitor database-level actions and write audit results to files.
2008-07-22
2,557 reads
Automate Audit Requests
In this article TJay Belt describes a process to help respond to audit requests in a timely manner
2008-06-18
2,393 reads
SQL Server Audit in SQL Server 2008 – Part 1
SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.
2008-06-16
2,860 reads
Audit Database Changes in the Real World
Tjay Belt brings us a story of how auditing was actually implemented and a discussion of why particular decisions were made.
2008-06-11
9,026 reads
Audit Trails and Logging Part II
Continuing with Part II of his auditing series, Gsquared takes a look at active auditing techniques for your SQL Server.
2008-06-10
10,399 reads
Audit Trails and Logging Part I
Auditing becomes more important every day as new requirements for data access are implemented. New author Gsquared, well known in the forums, brings us a look at types of audits and some details on passive auditing techniques.
2008-06-09
14,257 reads
Using DDL triggers to audit events
Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.
2008-05-15
3,467 reads
Blogs
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Forums
Page break in multi column paginated report
Hi, I have created a multicolumn paginated report, which includes a subreport that I...
create multiple output files based on query
I have this script that puts all of the output from query to a...
what if my last resort on extracting excel is at the cell level?
Hi, after i copy in ssis my excel file to a secured folder, its...
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers