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

For sure. If you're not testing restores, you don' tknow the backups are really working.

I've seen people have issues, especially if they inherit a system that doesn't use with init....

I've had a few customers do this and they just move the load. Unless the API server caches results for its connections, you still have a lot of queries to...

This wasn't a Prompt stability issue. Prompt releases every week, and you can delay updates.

However, Microsoft changed the version or name (can't remember) of some libraries that lots of add-ins...