Arrgghh, the static site for Blob Storage seems to want to be difficult.

The base URL is: https://sqlmemorialstorage.z22.web.core.windows.net/

I'm still trying to figure out why the DNS doesn't work.

Thanks, I'll take a look and ask if I have questions.

I think the google https redirect goes to a different chain in Azure. I have a report into McAfee to remove this.

The host is http://www.sqlmemorial.org. Getting the domain to redirect has been a bit of a pain

I don't know how SAN replication will work here. Typically, when you replicate across a SAN, you can't have a secondary node up. The files are being changed by the...

Rod,

I think both of those are the reasons that 70+% of people don't feel empowered.

If you use SAN Repl, I don't know how failover works. If you use AOAG, this keeps things in sync. I don't like using replication as a term here, because...

I don't love the microservices model for lots of database stuff. You lose the power of the database to combine data together. If it is truly separate and isn't aggregated,...

No direct problems, but the multi subnet thing is complex. I would hire someone to review the idea. I might recommend SQLHA.com

What doesn't work? You say "this" , but what is this? The code from Steve seems to match your results.

This is a change that requires a restart for the service. Glad you got it working.

You need to have a way to detect this worked or not and then send a failure code back to the SQL Job. However, what I might do is estimate...

The GDR is post CU. I think you need CU xxxx and then the GDR. If there is a previous GDR, CUs after that include the GDR.

SSMS 18.5

Works fine for me on

14.0.2037 (RTM-GDR)

15.0.2080.9 (RTM-GDR)

"nothing" isn't intended to be strictly nothing. The after effects of this code are nothing. The variable is declared, but the batch completion abandons this.

While the wording wasn't great, I...