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

For me, I point out things I've did and give an analysis of what could be better, or would have prevented issues.

The more I document and point things out, the...

Yes, the db is in use, so...

Sorry, typo here. Mixed up the explanation with another question in a poor copy/paste error.

The distance is 10. Points awarded back

thx dbruton, i have a feeling that when folks throw micro services at challenges like this to push rather than pull data, its completely possible that pooling isnt happening. ...