Only as Good as Your Auditor

Today we have a guest editorial from Andy Warren that talks about auditing your organization.

Change Login Auditing Option

Configure Login Auditing

Auditing DDL Actions

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.

Failed and Successful Login Auditing Using xp_readerrorlog

Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login

Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.

Architecture for Auditing

The way in which auditing is build into our systems isn't the best way to implement the practice.

Native Audits

This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.

Can Auditing Fail?

It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.