Author Archives: Kenneth Fisher

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

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

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

  4. Adding people’s names to a blog post can be rather tedious.

    Leave a comment

    June 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

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

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

  7. The Azure Portal search bar : T-SQL Tuesday #127

    Leave a comment

    June 9, 2020 by Kenneth Fisher

    Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time …
    Continue reading

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

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

    34

    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

  10. What I learned from “The boy who cried wolf”

    1

    May 28, 2020 by Kenneth Fisher

    I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons …
    Continue reading

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

Join 3,132 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013