Category Archives: Problem Resolution

  1. Windows Hello may cause a “SSPI Context” error

    2

    August 22, 2023 by Kenneth Fisher

    I’m going to start out by saying I don’t know a tremendous amount about this subject. I’ll tell you what …
    Continue reading

    Category: Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication | Tags: , ,

  2. Viewing errors with extended events

    3

    September 27, 2022 by Kenneth Fisher

    A little while back I came across this post: Identifying failed queries with extended events. It has a script to …
    Continue reading

    Category: Extended Events, Microsoft SQL Server, Problem Resolution, Security | Tags: , , ,

  3. Running dynamic SQL in a different database

    10

    May 19, 2022 by Kenneth Fisher

    This is one of those things that on hindsight was a stupid problem, but still cost me hours and a …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, T-SQL | Tags: , , ,

  4. Talk to the duck.

    Leave a comment

    March 31, 2022 by Kenneth Fisher

    Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is …
    Continue reading

    Category: Problem Resolution, SQLServerPedia Syndication | Tags: ,

  5. Error: Cannot continue the execution because the session is in the kill state.

    Leave a comment

    August 24, 2021 by Kenneth Fisher

    This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to …
    Continue reading

    Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication | Tags: ,

  6. Why are my permissions missing?

    Leave a comment

    June 22, 2021 by Kenneth Fisher

    You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz …
    Continue reading

    Category: Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication | Tags: ,

  7. #PowershellBasics: Writing to the screen

    8

    May 20, 2021 by Kenneth Fisher