Category Archives: Microsoft SQL Server

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

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

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

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

  5. Permissions script for Azure Synapse

    3

    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

  6. A table is like a library : T-SQL Tuesday #131

    Leave a comment

    October 13, 2020 by Kenneth Fisher

    Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like …
    Continue reading

  7. All triggers have to be able to handle multiple row operations.

    1

    September 3, 2020 by Kenneth Fisher

    Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s …
    Continue reading

  8. SQL Homework – September 2020 – More DML Triggers

    Leave a comment

    September 1, 2020 by Kenneth Fisher

    Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all …
    Continue reading

  9. As a DBA, am I a gatekeeper?

    6

    August 27, 2020 by Kenneth Fisher

    TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
    Continue reading

  10. SQL Homework – August 2020 – Write a SELECT statement.

    Leave a comment

    August 13, 2020 by Kenneth Fisher

    Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was …
    Continue reading

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

Join 3,519 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013