Tag Archives: ddl triggers
-
DDL Trigger to log database level security commands.
4June 24, 2021 by Kenneth Fisher
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
Continue reading -
Performance is bad. Did you change anything recently? No. Are you sure?
5July 26, 2017 by Kenneth Fisher
Ever have this conversation? Dev: Hey, can you help me? The performance on my application is terrible all of a …
Continue reading -
It greatly pleases me to announce, HAL0003!
27November 23, 2016 by Kenneth Fisher
I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal …
Continue reading -
Can we get a license for DDL Triggers?
4December 14, 2015 by Kenneth Fisher
There are several types of triggers. Logon triggers – Fired when someone tries to connect to the instance. DML triggers …
Continue reading -
Tales of a DBA fed up with NOLOCK. Part 1
44February 16, 2015 by Kenneth Fisher
Nov 12, 2014 Dear Diary, They asked for help again. Every now and again everything slows down and they see …
Continue reading
SQL Studies 