Tag Archives: Microsoft SQL Server

  1. A quick and dirty scan of a list of instances using a dynamic linked server.

    3

    November 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

  2. SQL Homework – November 2020 – Help!

    Leave a comment

    November 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

  3. All triggers have to be able to handle multiple row operations.

    1

    September 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

  4. SQL Homework – September 2020 – More DML Triggers

    Leave a comment

    September 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

  5. SQL Homework – August 2020 – More DML Triggers

    Leave a comment

    August 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

  6. HAL0004 – I don’t feel well Dave

    Leave a comment

    June 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

  7. I created a table and SQL created a schema and a user.

    Leave a comment

    June 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

  8. End an ALTER DATABASE immediately if anyone is in the database.

    5

    June 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

  9. SQL Homework – June 2020 – DML Triggers

    Leave a comment

    June 4, 2020 by Kenneth Fisher

    Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds …
    Continue reading

  10. TSQL Tuesday #127 Invite – Non SQL Tips and tricks

    37

    June 2, 2020 by Kenneth Fisher

    How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,154 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013