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,791 reads
Ankush Parab
usp_tableReference
Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.
2013-08-12 (first published: 2013-08-02)
1,115 reads
Blogs
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an...
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Forums
How to get result from deleted row
Hi Guys I have a store proc that delete a row from a and...
Count of Distinct Values
Hi If value is 21000030 it should return 4 not 5 . In first...
Joining against min date only
This is one of those things very hard (for me)to explain in words. See...
Question of the Day
Rolling Back CUs
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers