Category Archives: Microsoft SQL Server

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

  2. SQL Homework – May 2021 – Extended Events.

    1

    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

  3. Right sizing int : T-SQL Tuesday #136

    4

    March 9, 2021 by Kenneth Fisher

    Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. …
    Continue reading

  4. What is the CONTROL permission?

    1

    January 19, 2021 by Kenneth Fisher

    One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
    Continue reading

  5. “They need help, we must help.” #forGarethSwan

    1

    January 14, 2021 by Kenneth Fisher

    We just finished a memorial for Gareth Swanepoel. He was an amazing person and someone I wish I’d gotten to …
    Continue reading

  6. Sometimes a change is as good as a break : T-SQL Tuesday #134

    Leave a comment

    January 12, 2021 by Kenneth Fisher

    James McGillivray (blog|twitter) wants us to give him a break. Well. Actually I guess he wants to know how we …
    Continue reading

  7. SQL Homework – January 2020 – Create an End of Year/New Year checklist.

    Leave a comment

    January 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

  8. SQL Homework – December 2020 – Participate in the Advent of Code.

    Leave a comment

    December 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

  9. How do I tell what compression level my tables/indexes are?

    1

    November 17, 2020 by Kenneth Fisher

    It’s been a while since I worked with compression and the other day I needed to check which of my …
    Continue reading

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

    5

    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

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

Join 3,516 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013