Build SQL Server CLR Triggers
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
2022-02-21
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
2022-02-21
SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.
2021-02-18
This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.
Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.
2019-10-15 (first published: 2019-10-10)
2,652 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
25,998 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi All, We are seeing MSDTC transactions are blocking other sessions within sql server....
Hi All, Today, I came across a blocking issue from the application. A very...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers