SQL SERVER December 23, 2023

SQL Server Track Data Changes #1: Trigger-based

Words count 33k Reading time 30 mins.

SQL Server tracking changes data is useful for auditing purposes, troubleshooting, and data analysis. By tracking changes, you can easily identify what data has been modified, who made the changes, and when the changes were made. Aside with other solutions like CT (Change Tracking), CDC (Change Data Captured), Temporal Table (System-versioning). The...

Read article

SQL SERVER December 23, 2023

SQL Server Track Data Changes #1: Trigger-based

Words count 33k Reading time 30 mins.

SQL Server tracking changes data is useful for auditing purposes, troubleshooting, and data analysis. By tracking changes, you can easily identify what data has been modified, who made the changes, and when the changes were made. Aside with other solutions like CT (Change Tracking), CDC (Change Data Captured), Temporal Table (System-versioning). The most common and simple method for implementing tracking in SQL Server is by using Triggers (Stored...

Read article
0%