Channel 9 artwork

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

Channel 9

English - July 01, 2021 16:00 - 15 minutes - 14.2 MB - ★★★★ - 38 ratings
Technology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: Bring your Edge device logging and monitoring to the next level with IoT ELMS | Internet of Things Show

Next Episode: Learn how to build bots with Azure Bot Service's comprehensive development experience | AI Show

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. [00:37] Introductions
[01:19] What is Change Data Capture (CDC)
[03:43] Why use CDC
[05:08] Enabling/disabling CDC in Azure SQL Databases
[07:22] Performance Considerations for CDC
[09:00] Demo: How CDC works on Azure SQL Database
[14:00] Getting started Resources:
About Change Data Capture (SQL Server)Enable and Disable Change Data Capture (SQL Server)Work with Change Data (SQL Server)Administer and Monitor Change Data Capture (SQL Server)Change Data Capture and Other SQL Server Features