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

Published Jul 01 2021 09:00 AM 1,449 Views
Microsoft

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.

 

Watch on Data Exposed


Resources:
%3CLINGO-SUB%20id%3D%22lingo-sub-2504205%22%20slang%3D%22en-US%22%3ETrack%20and%20Record%20Data%20Changes%20with%20Change%20Data%20Capture%20(CDC)%20in%20Azure%20SQL%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2504205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EChange%20data%20capture%20(CDC)%20records%20insert%2C%20update%2C%20and%20delete%20activity%20that%20applies%20to%20tables%20in%20SQL%20Server%2C%20Azure%20SQL%20Managed%20Instance%20or%20Azure%20SQL%20Databases.%20In%20this%20Data%20Exposed%20episode%20with%20Mara-Florina%20Steiu%2C%20we%20will%20cover%20common%20use%20cases%20and%20scenarios%20for%20CDC%2C%20discuss%20key%20technical%20implementation%20details%2C%20and%20try%20out%20a%20CDC%20demo.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FvYY1muLkNZk%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CEM%3E%3CBR%20%2F%3EResources%3A%3C%2FEM%3E%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FCDCOverview%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAbout%20Change%20Data%20Capture%20(SQL%20Server)%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FCDCEnableDisable%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EEnable%20and%20Disable%20Change%20Data%20Capture%20(SQL%20Server)%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FCDCWork%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWork%20with%20Change%20Data%20(SQL%20Server)%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FCDCAdminister%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdminister%20and%20Monitor%20Change%20Data%20Capture%20(SQL%20Server)%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FCDCInteroperability%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChange%20Data%20Capture%20and%20Other%20SQL%20Server%20Features%3C%2FA%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%3E%3CBR%20%2F%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2504205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202729i490928FF0C962B7B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20what's%20new%20in%20change%20data%20capture%20(CDC)%20in%20Azure%20SQL%20Database%20and%20Azure%20SQL%20Managed%20Instance.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2504205%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20Managed%20Instance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jul 06 2021 05:38 AM
Updated by: