I'll certainly update the article with the link, as this might not be an issue, but still, exposing dev databases live is an issue. These are refreshed, and it's entirely...

An important trend as workloads increase. Most of us would prefer more machines to grow a load than a larger single machine.

2a. Set the instance to pause to drain connections (or dbs to restricted user)

2b. Tail log backup of databases

2c. script out all logins/linked servers/jobs (This could be done ahead of...

No auditing I know of for this. You could restore old backups as a new db and check the job status, using the data from Erland's post to decide which...

The link is for OpenQueryStore, ported to 2012/2014. That's why I added it.

Excluding article forums is probably a good idea. I'll submit that as a bug.

The user time thing was welcome, since I was in Australia, times looked really strange to me....

Not for now. T "bold" adds a lot of tracking code to the process. Some of this can be async, but it has to work in the WordPress platform, and...

The most replies was supposed to be last 24 hours, but the filter wasn't applied when we switched some other items (poor code implemented). This finally got fixed last week...

This is intended to give you a...

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