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)
557 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)
370 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)
20,187 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)
619 reads
Blogs
SQL in the City Back in London
By Steve Jones
It’s just a couple weeks until the SQL in the City Summit comes back...
Azure Fundamentals 12th December
By Gethyn Ellis
Certified Microsoft Azure Fundamentals - AZ-900 1 day Web based Course - 12th December 2019 Its...
"Think Like a Certification Exam" at the PASS Marathon!
By Will Assaf
Thanks to the 56 of you who joined and actively answered my nerdy sample...
Forums
A bit of mathematics...
Hi all, I'm just doing some work on my own bank statements imported from...
Need Help: On Query with Case Statement
Hi, As part of development task I have to write a SQL logic for...
Value of extended property in T4 script returns a quoted, escaped string?
Hi, I have a T4 script which reads extended properties. The value of...
Ask SSC