Grant/Jeff - won't any find/replace, in source control, via synonym or otherwise, have the same issues if the columns also changed? The only real method to make sure this...

This doesn't sound like an indexing problem, unless we see an execution plan showing scans. Instead, it sounds like an I/O problem caused by the varbinary(MAX). However, I'd want some...

One thing I would add, I was really tempted to drop databases after the restore. but the number of times a developer needed to get some data back because...

1. Everything if you can, but certainly many can't, for valid reasonsY. So, triage. "We can't live without it" databases get regular and constant love through testing. Everything else gets...

First up, yes, a synonym is probably the easiest way to fix this.

Second, source control is your bestest buddy on earth. If you get all your code that defines databases...

You can't run a backup command against an Azure SQL Database. That's the core of the problem. You can export one to a DACPAC or other process, but no backups...

You simply can't get all the stuff through a T-SQL query. This is where WMI queries come into play and some kind of external language to pull that data...

Awesome points. Thanks for sharing Joe.

I am not sure that I understand what you are saying Jeff. To me, you sound like you are saying that industry standards are not a good idea. If...

I suspect that other fellow, who is in IT, will disagree. I think crazy distributes pretty evenly through society, even into IT.

Well, there was the time, on a surface ship, where I was helping a team unclog a toilet. Some bright switch (not me) decided to hook the high pressure air...

From the article:

One of the reasons I love history is because it really does teach us so much.

This is why old folks rock.  It's not "history" to them... it's...

Ah, you've hopped the great Cardinality Estimation Engine gap represented by 2014. Sounds like your system is one of those that has problems with the new CE. Prior to 2014,...

Updating a view isn't updating a join. In fact, I'm not sure how you update a join because you can't. Updating a view is using the fact that a view...

Can you clarify a little what you're looking for here please?

Do you want to compare all the tables in all the databases on a server and find a list of...