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

    Leave a comment

    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

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

    3

    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

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

  4. Adding a user to an Azure SQL DB

    1

    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

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

  6. What do they want to hear?

    3

    October 29, 2020 by Kenneth Fisher

    I was helping my 16yo write his first college essay the other day. He’s always struggled a bit with writing …
    Continue reading

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

    4

    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

  8. SQL Virtual Machines

    Leave a comment

    October 22, 2020 by Kenneth Fisher

    I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) …
    Continue reading

  9. My 800th post!

    Leave a comment

    October 20, 2020 by Kenneth Fisher

    It took me a little bit longer to get here than I expected but I finally made it. 800 posts. …
    Continue reading

  10. Permissions script for Azure Synapse

    2

    October 15, 2020 by Kenneth Fisher

    I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
    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