SQL Server & Azure Database Development, Tuning & Optimization Blog

SQL Server & Azure Database Development, Tuning & Optimization Blog

Series

Audit

This series focus on Auditing and methods for Capturing Data Changes and Tracking with SQL Server.

Track Data Changes in SQL Server with Change Tracking
SQL Server provides three mechanisms to track data changes in the table objects. This mechanism is also a useful solution for implementing the audit and logging process for the SQL Server Instance. The mechanisms are Change Tracking also known as CT,...
Apr 10, 20228 min read1.7K
Auditing & Implementing Data Change Capture with Triggers in SQL Server
Database Auditing is a process of tracking and logging all events and capturing data changes in database objects, it not only helps businesses but is also a compliance requirement. In most cases when we want to implement capturing of data changes in ...
Apr 3, 20228 min read358