Trigger Based Change Data capture
This script capture INSERTs / UPDATEs / DELETEs on SQL Server table and logs to single table in JSON Format.
2017-12-22 (first published: 2017-12-01)
2,835 reads
CDC
CDC watchdog for databases in AlwaysOn AG
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
776 reads
Incremental Data Loading Using CDC
Describes a design pattern for using CDC to power fast and efficient incremental data loads.
2013-06-07 (first published: 2011-01-17)
28,722 reads
Generating Rollback Proc with CDC
This will generate a rollback procedure for any table with CDC enabled for all columns
2009-11-02 (first published: 2009-10-08)
1,004 reads
Blogs
Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025
By Daniel Janik
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering...
Techno Security East: Quantum Computing Slides
By Brian Kelley
I always try and ensure that I post my slides to my talks here...
A Basic Update Trigger: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Forums
SSIS raw file conversion
Hi, Does anyone know how to handle a raw data file where some rows...
Force Strict Encryption - SQL Agent fails
Hi, On my SQL 2022 (16.0.4195.2) test environment, I tried to enable Force Strict...
Error converting data type varchar to float
Hi everyone I have a bunch of CSV files that I need to import...
Question of the Day
How Many Nested Triggers?
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers