Tag: Change Data Capture

  • Disable Change Data Capture in SQL Server

    Disabling Change Data Capture (CDC) is straightforward, but it has to happen in the right order: every tracked table first, then the database. Skip a step and SQL Server tells you plainly rather than doing it anyway, which is the safe behaviour but confusing the first time you hit it. This post covers disabling CDC…

    Written by

    Peter Whyte

  • How to Enable Change Data Capture (CDC) in SQL Server

    Change Data Capture (CDC) allows SQL Server to track inserts, updates, and deletes on selected tables by reading the transaction log and storing changes in system tables. From a DBA point of view, CDC is easy to enable but easy to underestimate. It adds background jobs, ongoing storage growth, and operational overhead that needs to…

    Written by

    Peter Whyte
Major pillars
DBA Scripts180+ scripts, one page each SSMS Complete GuideInstall, shortcuts, git, Copilot, dark mode Error LibraryLook up an exact message, cause and fix Wait Types LibraryWhat the server was waiting on
Find a script
Find a ScriptSearch by name, or browse every script page DBA Scripts: The Complete GuideHow the series works, read end to end
Health check & tooling
Full Health CheckCollect 45 diagnostics, apply rules, then an AI assessment sqldba MCP ServerGive an AI assistant a verified SQL Server reference
Script areas
Server & Configuration Storage & Capacity Backup & Recovery High Availability Performance & Troubleshooting Security Maintenance & Automation Migration & Deployment
Latest posts
Browse by topic