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

This (https://serverfault.com/questions/1023512/how-to-enumerate-ciphers-for-mysql-server-using-nmap) says nmap doesn't support this.

If your client attempts to connect, do you get the secure connection? Or if you have no encryption, do you get the connection...

The short answer, there isn't a simple way to view the world of software. It isn't that we allow all failure or have all the data to cover all cases,...

code corrected with alias

The question is about knowing datetime2 doesn't contain the time zone, not how to convert to a different datatype.

The datetime2 isn't aware of time zones, nor does it store them. Once this is stored, there is no +00:00, so that is not correct.

I don't know exactly how they got in, but from my understanding, this wasn't an exe replacement, it was a change of code. Perhaps it was a new DLL or...