Tag: Change Data Capture
Disabling Change Data Capture in SQL Server
This post contains a demo on how to disable CDC (Change Data Capture) in SQL Server 2022. The sp_cdc_disable_table and sp_cdc_disable_db in-built MSSQL SPs are what we should use to disable CDC in SQL Server which is explained more below. The sp_cdc_disable_table and sp_cdc_disable_db are the in-built MSSQL SPs to do this which are explained…
How to Enable CDC in SQL Server
This is a post on how to enable Change Data Capture (CDC) in SQL Server. Enabling this on a database and table will allow the recording of activity when tables and rows have been modified. This is a feature available for us to configure within SQL Server and Azure SQL out of the box. CDC…
Recent Posts
- How to Open SSMS as a Different Domain User
- Troubleshooting Database Mirroring Issues in SQL Server
- What’s New in SQL Server 2025
- Time To Revive This Blog
- How to Set Environment Variables in PowerShell
Categories
- AWS (5)
- DBA Stories (1)
- Linux (34)
- MySQL (5)
- Other (2)
- Postgres (7)
- PowerShell (48)
- RedShift (7)
- SQL Server (81)
- Windows Admin (64)
Tags
Active Directory (AD) AWS CLI CDC Certificates & Encryption Change Data Capture CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Featured Git Git Commands Git Log Installing SQL Server Linked Servers Linux Admin Measuring Databases MSSQL SPIDs NetFirewallProfile New-Item PowerShell PowerShell Create Folder PowerShell Delete Files PowerShell ForEach PowerShell Tips PowerShell Version Restoring Databases SQL Server Agent SQL Server ETL SQL Server Management Studio (SSMS) SQL Server Processes SQL Server Scripts SQL Tips SSH SSMS Tips Temp DB Windows Admin Windows Firewall WordPress Tutorials WSL WSL1 WSL2 WSL Ubuntu WSL Version