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

Find out who has been on my server using the Default trace.  Read more...

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.  Read more...

Is auditing in use in your applications? Steve Jones wants to know as he thinks it will be more important in the future for most software.  Read more...

A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.  Read more...

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...

If you are bound by HIPAA regulations, you may have more auditing in your future. If you're not, perhaps you should still pay attention to the criteria being used for auditing.  Read more...

One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...  Read more...

Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...  Read more...

Welcome back, folks! Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...  Read more...

I've been charged with coming up with a quick solution to audit login changes on my SQL Servers. However, there's no budget so I'm going to have to come up with basic scripts and the like to do the work. Is this tip we cover a solution for you to audit login changes.  Read more...

Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in...  Read more...

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...

In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...  Read more...

In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.   Read more...

This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.  Read more...

This script will return all permissions on the server.  Read more...

Second part of two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports. I uploaded the entire Word document that includes the images.  Read more...