SQL Server - Change Tracking vs CDC: When and how to implement lightweight data tracking December 31, 2025 15 min read Continue reading
SQL Server - How to Use Auditing to Map Real Required Permissions for a User January 20, 2019 8 min read Continue reading
SQL Server - How to recover the source code of deleted objects (View, Stored Procedure, Function and Trigger) July 8, 2018 9 min read Continue reading
SQL Server - How to monitor and audit data changes in tables using Change Data Capture (CDC) February 7, 2018 9 min read Continue reading
SQL Server - Trigger to Prevent and Block Changes in Tables February 4, 2018 3 min read Continue reading
SQL Server - Audit Trigger for Permissions and Privileges at Database and Instance Level (GRANT / REVOKE) July 19, 2017 2 min read Continue reading
SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage February 28, 2017 5 min read Continue reading
SQL Server - How to copy/replicate a user's permissions February 19, 2017 11 min read Continue reading
SQL Server - How to audit permission errors on objects using SQL Profiler (Trace) September 10, 2016 5 min read Continue reading
SQL Server - How to create a data change history for your tables (audit logs) July 17, 2016 7 min read Continue reading
Using the Default SQL Server Trace to Audit Events - fn_trace_gettable() April 23, 2016 5 min read Continue reading
SQL Server - How to Implement Login Audit and Control (Logon Trigger) July 19, 2015 9 min read Continue reading
How to create an audit trigger to log object manipulation in SQL Server July 18, 2015 6 min read Continue reading
How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server June 5, 2015 4 min read Continue reading