Category Archives: Problem Resolution

  1. Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.

    Leave a comment

    May 20, 2020 by Kenneth Fisher

    The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using …
    Continue reading

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

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

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

  5. Debugging techniques (focusing on T-SQL)

    12

    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

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

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

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

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

  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,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013