Change Data Capture Learning Resources

Everything Old Is New Again


If I have to suffer, you all have to suffer. I should probably rephrase that: if I have to suffer, I want you to suffer less. Learn from my suffering, or something.

Recently I’ve been doing some work with Change Data Capture. I’ve done stuff with it before, but I never thought to round up places I’ve picked up tips, tricks, and knowledge for dealing with it. All of the information in these is relevant today, despite most being from 10 or more years go. The only real change I’ve seen is a __$command_id column added to the cdc.<schema>_<table>_CT table in SQL Server 2012-2016.

First, Change Data Capture vs Change Tracking

Second, Tuning the Performance of Change Data Capture

Third,

Fourthly, from the comments:

Blog posts by the repltalk team on CDC https://repltalk.com/tag/cdc/

I hope you find these useful.

Actually, I hope you don’t, because you never have to deal with Change Data Capture. Ha ha ha.

Let me know in the comments if I missed anything!

Thanks for reading!



4 thoughts on “Change Data Capture Learning Resources

  1. I’m with you with a slight difference.
    “…if I have to suffer, I *usually* want you to suffer less. Learn from my suffering, or something. *If you fail to learn from my suffering, you will suffer greatly and I will go full Nelson Muntz*”

    A Full Nelson should never be underestimated.

    That was a lot of work for a cheap pun.

Leave a Reply

Your email address will not be published. Required fields are marked *