Category Archives: SQLServerPedia Syndication
-
All triggers have to be able to handle multiple row operations.
1September 3, 2020 by Kenneth Fisher
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s …
Continue reading -
SQL Homework – September 2020 – More DML Triggers
Leave a commentSeptember 1, 2020 by Kenneth Fisher
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all …
Continue reading -
As a DBA, am I a gatekeeper?
6August 27, 2020 by Kenneth Fisher
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
Continue reading -
SQL Homework – August 2020 – More DML Triggers
Leave a commentAugust 13, 2020 by Kenneth Fisher
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was …
Continue reading -
What goes around comes around : T-SQL Tuesday #129
2August 11, 2020 by Kenneth Fisher
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. …
Continue reading -
HAL0004 – I don’t feel well Dave
Leave a commentJune 29, 2020 by Kenneth Fisher
It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for …
Continue reading -
Azure SQL Database Query Editor
3June 24, 2020 by Kenneth Fisher
I was working on a couple of Azure databases the other day. One was an Azure SQL DB and the …
Continue reading -
Adding people’s names to a blog post can be rather tedious.
Leave a commentJune 18, 2020 by Kenneth Fisher
I blog a fair amount and do you want to know what the most annoying part of the process is? …
Continue reading -
Non-SQL Tips and tricks – #tsql2sday 127 Rollup
3June 16, 2020 by Kenneth Fisher
I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now …
Continue reading -
End an ALTER DATABASE immediately if anyone is in the database.
5June 11, 2020 by Kenneth Fisher
The development team has told me they’ve shut down the application, there are no more connections and I can go …
Continue reading
