Monthly Archives: May 2021

  1. The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.

    3

    May 27, 2021 by Kenneth Fisher

    I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the …
    Continue reading

  2. What account is xp_cmdshell using?

    2

    May 25, 2021 by Kenneth Fisher

    It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
    Continue reading

  3. #PowershellBasics: Writing to the screen

    8

    May 20, 2021 by Kenneth Fisher

    Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is …
    Continue reading

  4. Creating a configurable SSMS script

    1

    May 18, 2021 by Kenneth Fisher

    Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
    Continue reading

  5. #PowershellBasics: Comments and comment based help

    4

    May 13, 2021 by Kenneth Fisher

    I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the …
    Continue reading

  6. What do you do when technology changes? : T-SQL Tuesday #138

    Leave a comment

    May 11, 2021 by Kenneth Fisher

    Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes …
    Continue reading

  7. All jobs that ran during a given time frame.

    Leave a comment

    May 6, 2021 by Kenneth Fisher

    Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of …
    Continue reading

  8. SQL Homework – May 2021 – Extended Events.

    2

    May 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

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

Join 3,545 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013