Tag Archives: problem resolution

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

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

  3. #PowershellBasics: Writing to the screen

    8

    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

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

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

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

    7

    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

  7. Debugging techniques (focusing on T-SQL)

    13

    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

  8. Why is as important as How

    6

    August 28, 2019 by Kenneth Fisher

    I recently had someone tell me, and I’m paraphrasing a bit here: We know how to fix this now, so …
    Continue reading

  9. Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?

    1

    May 8, 2019 by Kenneth Fisher

    If you have to deal with linked servers then you probably have or will run into the following error: Login …
    Continue reading

  10. What happens in a trigger stays in the transaction: T-SQL Tuesday #106

    Leave a comment

    September 11, 2018 by Kenneth Fisher

    Anything that happens in a trigger happens within the same transaction of the command that called it. Part of me …
    Continue reading

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

Join 3,570 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013