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,887 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,117 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...