ITWire

iTWire - Using database triggers for alerting and auditing

We create a trigger using the T-SQL 'create trigger' command, specifying both the table to monitor (PurchaseOrders) and the actions that cause it to fire (insert, update). Within the program code we ...
InfoQ

AWS Enables Lambda Function Triggers from RDS for SQL Server Database Events

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ludi Akue discusses how the tech sector’s ...
Ars Technica

Getting the SQL statement that caused a trigger to fire [T-SQL]

I have a 3rd party app that I suspect is behaving badly (actually, I'm about 99.9% sure it is). When I save changes to the database, it executes what should be (as near as I can tell) about 20 SQL ...
ITWire

Using database triggers for alerting and auditing

The 'magic' for want of a better word that makes this happen is triggers. This is a feature of high-end database systems like Oracle, SQL Server and MySQL that causes program code to execute via the ...