Auditing data changes requires choosing whether you need old values, new values, actor identity, or a change feed, then testing the cost.
Append-Only Ledger Tables for Audit Logs That Cannot Be Edited
Can someone quietly edit your audit table? With an append-only ledger and a stored digest, the answer becomes no, and you can prove it.
SQL SERVER – How to Chang Audit Location?
SQL Server auditing is a hidden gem. Learn how to change the audit location after it is created, for example when a network share fails.
SQL SERVER – User Defined Audit with SQL Server
Bank security checks taught me patience about audits. Here is how a user defined Audit in SQL Server lets you write your own events to the audit log.
Audit Triggers That Record the Real User Behind EXECUTE AS
Your audit table says dbo for every change, and nobody can tell who really did it. Here is how to capture the person behind EXECUTE AS.
Tracking Recent Object Changes With modify_date
Use modify_date to find recent SQL Server object changes, compare databases, and understand which audit questions need event capture.
UPDATE() in a Trigger Is True Even When Nothing Changed
Understand why UPDATE() in a trigger fires for unchanged SET values and log only real changes with inserted and deleted row comparisons.