Category Archives: Problem Resolution

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

  2. Debugging techniques (focusing on T-SQL)

    11

    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

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

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

  5. SQL Homework – May 2019 – SQLCMD and the DAC

    5

    May 1, 2019 by Kenneth Fisher

    Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC …
    Continue reading

  6. How do I let someone execute a SQL Agent job they don’t own?

    2

    April 15, 2019 by Kenneth Fisher

    In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
    Continue reading

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

  8. SQL Puzzle: Advent of Code

    Leave a comment

    August 29, 2018 by Kenneth Fisher

    A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
    Continue reading

  9. Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104

    Leave a comment

    August 14, 2018 by Kenneth Fisher

    Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started …
    Continue reading

  10. Processes can dramatically improve your work until they don’t.

    Leave a comment

    July 23, 2018 by Kenneth Fisher

    As always with something like this, I like to start with a definition so we are all starting in the …
    Continue reading

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

Join 3,084 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013