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

From the creator

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=dataexposed-c9-niner Enable and Disable Change Data Capture (SQL Server): https://aka.ms/CDCEnableDisable?WT.mc_id=dataexposed-c9-niner Work with Change Data (SQL Server): https://aka.ms/CDCWork?WT.mc_id=dataexposed-c9-niner Administer and Monitor Change Data Capture (SQL Server): https://aka.ms/CDCAdminister?WT.mc_id=dataexposed-c9-niner Change Data Capture and Other SQL Server Features: https://aka.ms/CDCInteroperability?WT.mc_id=dataexposed-c9-niner 📌 Let's connect: Twitter: Mara-Florina Steiu, https://twitter.com/MSteiu Twitter: Anna Hoffman, https://twitter.com/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.

Published 2021-07-01 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.