Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

When using only an LSN to track which changes you have processed, you can lose data. This article shows how to avoid this problem.

Enables Change Data Capture (CDC) on all user databases

This script loops through all user databases, skips system DBs and any you want to exclude, and enables CDC if it’s not already enabled.

Implementing Change Data Capture

Detaching CDC

CDC and Restores

Restore a Database with CDC Enabled

In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.

Getting Started with Change Data Capture – Part 2

The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.

Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1

Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT).

Implementing SQL Server's Change Data Capture

When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.

Implementing SQL Server's Change Data Capture

When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.