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,157 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)
691 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)
25,731 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)
708 reads
Blogs
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Forums
Display columns from multiple rows in single
Hello, Im looking for assistance. I have this query and need to display the...
Azure Dataware or Azure SQL Pools and equivalent to profiler in Azure...
I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL...
Reset launchpad service to use default account
I have an issue with SQL Server Launchpad service. Initially it wouldn't start (configured...
Ask SSC