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:
About Change Data Capture (SQL Server): https://aka.ms/CDCOverview?WT.mc_id=d...
Enable and Disable Change Data Capture (SQL Server): https://aka.ms/CDCEnableDisable?WT.mc...
Work with Change Data (SQL Server): https://aka.ms/CDCWork?WT.mc_id=datae...
Administer and Monitor Change Data Capture (SQL Server): https://aka.ms/CDCAdminister?WT.mc_id...
Change Data Capture and Other SQL Server Features: https://aka.ms/CDCInteroperability?WT...

📌 Let's connect:
Twitter: Mara-Florina Steiu,   / msteiu  
Twitter: Anna Hoffman,   / analyticanna  
Twitter: AzureSQL, https://aka.ms/azuresqltw

🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt

#AzureSQL #SQLServer #ChangeDataCapture #DataExposed