SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event...
SQL Server Triggers: DML Triggers
In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
SQL Server Bulk Insert – Part 2
In the previous part of this article, we discussed how to import CSV files to SQL Server with the help of BULK INSERT statement. We...
Logon Triggers in SQL Server
A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL...
SQL Server Trigger: Understanding and Alternatives
The SQL Server trigger is a special type of stored procedures that is automatically executed when an event occurs in a specific database...
Don’t like database triggers? You just don’t know how to work with them!
When designing large relational databases, we often make a decision to diverge from a normal form, i.e. denormalization. The reasons for...
