Category Archives: Microsoft SQL Server

  1. A table is like a library : T-SQL Tuesday #131

    Leave a comment

    October 13, 2020 by Kenneth Fisher

    Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like …
    Continue reading

  2. 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

  3. 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

  4. As a DBA, am I a gatekeeper?

    6

    August 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

  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. What goes around comes around : T-SQL Tuesday #129

    2

    August 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

  7. 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

  8. Azure SQL Database Query Editor

    3

    June 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

  9. 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

  10. Non-SQL Tips and tricks – #tsql2sday 127 Rollup

    3

    June 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

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