Introduction to DML Triggers : AFTER and INSTEAD OF - Video Series Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more Skill Level: 300 (Intermediate) DML triggers are database objects that fire on a praticular operation for a particular table.In this essential 6-part series, your instructor will provide you with a great overview of how,when, and why to use the AFTER and INSTEAD OF triggers for SQL Server. Highlights from this series: What are the different types of triggers (DML vs DDL)? About the two types of DML triggers AFTER INSTEAD OF When will the two triggers fire? Similarities between Triggers and Stored Procedures Creating an audit trail trigger Example of when to use an AFTER trigger for a business rule What is a ghost/virtual delete? Using the UPDATE() function to audit specific info

Videos in this Series:

Title Skill Length Download Part 1 - An Introduction to DML Triggers - AFTER and INSTEAD OF Triggers   200 11 mins. Download Part 2 - More Detail on Using AFTER Triggers in SQL Server   200 10 mins. Download Part 3 - Building AFTER Triggers for Auditing Row Changes and Table Changes   300 11 mins. Download Part 4 - Building AFTER Triggers for Enforcing Advanced Business Rules   300 14 mins. Download Part 5 - INSTEAD OF Triggers and Ghost/Virtual Deletes   400 10 mins. Download Part 6 - The UPDATE() Function, Trigger Timing, and Final Summary   300 10 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Management Tip: Automation is your friend. Make good use of SQL Server jobs and alerts to build a proactive solution. Configure alerts for common scenarios such as backup failures, log filling up, deadlocks and more. Have these alerts fire off jobs that protect and react to the situation. For example, configure an alert that fires off a log backup job if the log of database "MyDb" gets 90% full There is a version of the "Adventure Works" sample database available for SQL Server 2000. Go to any search engine and search for "AdventureWorks2000" and locate the download file. AdventureWorks2000 is a more robust sample database than Northwind and pubs Helpful Keyboard Shortcuts: "CTRL" + "TAB" navigates forward between panes/worksheets/tabs in an application (add in "SHIFT" to navigate backwards)