Track and Record Data Changes with Change Data Capture (CDC) in Azure SQL | Data Exposed

Change data capture (CDC) records insert, update, and delete activity that applies to tables in SQL Server, Azure SQL Managed Instance or Azure SQL Databases. In this Data Exposed episode with Mara-Florina Steiu, we will cover common use cases and scenarios for CDC, discuss key technical implementation details, and try out a CDC demo.

0:00 Show begins
0:37 Introductions
1:19 What is Change Data Capture (CDC)
3:43 Why use CDC
5:08 Enabling/disabling CDC in Azure SQL Databases
7:22 Performance Considerations for CDC
9:00 Demo: How CDC works on Azure SQL Database
14:00 Getting started

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer #ChangeDataCapture #DataExposed

[MrMondaypercent]

Excellent demo and presentation. At 12:10 to 12:30 there is a small error in wording, the retention parameter value is actually minutes not seconds. The default being 4320 minutes which is 72 hours which is 3 days. As always check the docs as this may change in future versions (hopefully not though!).

[daniyalahsan]

Is there a way to use CDC to upsert values into a table based on a primary key? if so can someone please advise or share a link if you have one. Thanks

[allenbabu]

I have installed sql server 2019 in Linux with multiple databases created on it. I have multiple tables across different databses with CDC enabled. But the SQL server gets hanged very often due to this cdc. KIndly let us know, if Linux having any issue with cdc enabled.

[jordannyc]

Any way to use elastic/kibana against CDC to monitor stored procedures or any scheduled sql inserts/updates ?

[sintetico]

Can you prived more concrete examples about these scenarios "propagate changes to downstream subscriber" and "event-based programming that provides instantaneous responses based on data change".

I would like to connect SQL Server 2019 CDC events to a message broker like RabbitMQ but look like there isn't anything already developed.

[harry]

When to use CDC vs Database Ledger? If your requirements are just table auditing.

[samuelgit]

Hi, How I can identify which user did each change using CDC?

[walterlonso]

Hi, Is this feature delivered in all regions? for example China?

[hydtechietalks]

why does Microsoft always get a Non Inglis speakers .. all the complexity lies in there 🤣

[praveennakka]

Not a good presentation guys sorry.... Step up please