Tag Archives: Microsoft SQL Server
-
SQL Homework – May 2021 – Extended Events.
4May 4, 2021 by Kenneth Fisher
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to …
Continue reading -
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
Leave a commentJanuary 5, 2021 by Kenneth Fisher
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true …
Continue reading -
SQL Homework – December 2020 – Participate in the Advent of Code.
Leave a commentDecember 3, 2020 by Kenneth Fisher
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect …
Continue reading -
A quick and dirty scan of a list of instances using a dynamic linked server.
5November 12, 2020 by Kenneth Fisher
Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently …
Continue reading -
SQL Homework – November 2020 – Help!
Leave a commentNovember 3, 2020 by Kenneth Fisher
If you ask any senior IT person What is the most important tool you have? there is a decent chance that …
Continue reading -
All triggers have to be able to handle multiple row operations.
2September 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 -
SQL Homework – August 2020 – Write a SELECT statement.
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 -
HAL0004 – I don’t feel well Dave
1June 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 -
I created a table and SQL created a schema and a user.
1June 22, 2020 by Kenneth Fisher
Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick …
Continue reading
SQL Studies 