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,830 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
Getting References for GenAI Results
By Steve Jones
I wrote an editorial on the view of GenAI tech from execs and someone...
SQL Server 2025 Is Here – AI Just Changed Everything!
By Rohit Garg
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...
SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!
They run, they return data. So what? Some SQL queries just waste your time...
Forums
High Availability Reversed - Force secondary unless failure
Hi I have sql2022 in H/A with a primary and a secondary server. My...
Question of the Day
Calculating Month End
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers