Category Archives: SQLServerPedia Syndication

  1. What is the CONTROL permission?

    Leave a comment

    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

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

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

  4. Hope!


    December 31, 2020 by Kenneth Fisher

    2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s …
    Continue reading

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

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


    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

  7. I get by with a little help from my friends : T-SQL Tuesday #132

    Leave a comment

    November 10, 2020 by Kenneth Fisher

    Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our …
    Continue reading

  8. Adding a user to an Azure SQL DB


    November 5, 2020 by Kenneth Fisher

    Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
    Continue reading

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

  10. How do I test if a linked server works using T-SQL?


    October 27, 2020 by Kenneth Fisher

    I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
    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