Category Archives: Problem Resolution
-
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
Leave a commentMay 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 -
SQL Homework – May 2020 – Forum Lurking.
Leave a commentMay 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 -
Help! My restore has finished but the database still has a status of recovering.
Leave a commentJanuary 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 -
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
7December 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 -
Debugging techniques (focusing on T-SQL)
12September 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 -
Why is as important as How
6August 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 -
Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?
1May 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 -
SQL Homework – May 2019 – SQLCMD and the DAC
5May 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 -
How do I let someone execute a SQL Agent job they don’t own?
3April 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 -
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
Leave a commentSeptember 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