The way to lock this would be a semphore of sorts. Then your proc needs a check. So you could insert a value into a table when you start, and...

I responded, and while I think the OP overreacted, keep in mind there are people trying to solve a problem. They have a narrow view, and they often balance other...

I like the synonyms, maybe with an Agent job that does the work to check/repoint. I'd think the Java app wouldn't need to know, just load the empty table. The...

I'm torn. I like AGs because I think they're more robust and reliable than replication. Repl works great until it doesn't, and then it's a pain. However, this is reporting,...

Yeah, I think there's something going on here, but not completely sure of the process. I need to get a complete explanation of how things work.

It would also be nice if they could tell me when I create an account how long it will remain active. Should I be able to force a renewal...

Money is deprecated, but never going away. I wouldn't worry about it.

Could be server load, but I'd lean towards network issues.

I like B, though you can also use a secret and store this for use as a credential in the script. I've had this be flaky, but it is what's...

It is. I find functions to be a bit strange in R, especially nested ones. I'll get a question on those at some point. Or one of you can write...

You might also implement Query Store to get plans to watch and examine. There is a project port of this here: https://github.com/OpenQueryStore/OpenQueryStore/releases/tag/v2.1.0

You can implement AGs between to IaaS systems in Azure. This is the same as on prem, though you'll need the networking set correctly for the listener and each to...

I blame professors are unis for this. That's the...

I came across a stored procedure recently where there were 2 developers clearly arguing we didn't have source control for sql at the time of the argument (way before...

Changing monitoring intervals, or suppressing additional alerts, is something that needs to happen as well. Too easy to keep sending the same thing over and over. However, that's a complex...