Important points that support the idea that you are working on a team.

It seems to be hard to build teams in many organizations, which are such a powerful force.

Thanks, glad they enjoyed it.

Amazing what hardware will do. Did you add CPUs/RAM?

I'm all for optimizing code, but also for considering resource changes.

Good luck and hope it goes well.

FWIW, if you want, both of these would make neat articles. Short, focused on making a connection from an app and what works/doesn't from...

That makes sense, and no, don't think this is going to be possible anytime soon. Maybe Entra to a MI or Azure SQL, but not on premises. Arc might help...

And another aside: Is this a danger of the whole AI thing? People seem to be using AI to provide 'quick and dirty' answers to their queries instead of...

What works for me is the Disney method.  Write the ideas down, don't critique or polish at the idea stage (dreamer stage).  I was introduced to the Disney...

That's excellent. And relatable as I and my family ages.

Are you saying refresh the data? The data from prod is separated from compute, so you would need to use ADF or some other method to copy the data to...

Is this having a managed service run a connection as a client that uses user/pwd? In other words, having the MSI act as you with a SQL auth connection?

Any context,...

I tend to see with most customers that problems aren't discovered during deployment, but some time later (minutes, hours, days).

If there is a problem during deployment, most of the time...

Backward or forward? I would say it depends.

I think the most important skill for us DBA's, maybe even more than technical, is critical thinking under pressure. The ability to...

Not going to download a random file. Post the code. Most indexes will be nonclustered that are added.

I think fix-forward is the more common option when the issue has gone undetected for a period of time so that further processing has taken place that would be...

From the safety of my armchair, with no current emergency to disturb my reasoning, I would say: Get the DB to a Known State. And this will almost always...