SQL Server Logon Trigger Examples
In this tip we look at how to create SQL Server Logon Triggers and show different examples of how this can be used.
2019-08-15
In this tip we look at how to create SQL Server Logon Triggers and show different examples of how this can be used.
2019-08-15
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-06-05
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-05-29
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
2019-05-01
Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.
2019-02-19
1,676 reads
Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger. Joe Celko describes a feature of SQL that 'gets complicated fast'.
2017-01-03
3,807 reads
2016-10-20
1,122 reads
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2015-08-06 (first published: 2015-07-07)
788 reads
2014-05-05
1,723 reads
2014-04-02
2,201 reads
By Steve Jones
I delivered a talk at the ConFoo conference. I’ve never been to this live,...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
Comments posted to this topic are about the item Shortcutting Git Commands
Comments posted to this topic are about the item What's a Lot of Money?
I am using the following function: IIf([var1Title] != '', [var1Title] + ' - '...