2016-11-14 (first published: 2016-11-06)
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login
2015-12-30 (first published: 2015-12-15)
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.
2019-03-26 (first published: 2015-09-23)
It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.
2018-10-26 (first published: 2015-05-05)
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.
2015-02-03 (first published: 2015-01-25)