Tag Archives: problem resolution

  1. Viewing errors with extended events


    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

  2. Running dynamic SQL in a different database


    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

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

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

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

  6. #PowershellBasics: Writing to the screen


    May 20, 2021 by Kenneth Fisher

    Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is …
    Continue reading

  7. SQL Homework – May 2020 – Forum Lurking.

    Leave a comment

    May 4, 2020 by Kenneth Fisher

    A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among …
    Continue reading

  8. Help! My restore has finished but the database still has a status of recovering.

    Leave a comment

    January 8, 2020 by Kenneth Fisher

    I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, …
    Continue reading

  9. Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.


    December 5, 2019 by Kenneth Fisher

    I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone …
    Continue reading

  10. Debugging techniques (focusing on T-SQL)


    September 23, 2019 by Kenneth Fisher

    tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: …
    Continue reading

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013