You could just do it with stored procedures and linked servers depending on how complex your data is.

SSIS will probably be the best GUI-based conversion tool you can find however,...

I'd use a local mail server to relay through and then configure TLS 1.2 on that. I dont think SQL 2016 database mail can do it and am uncertain about...

Check out dbatools.io

You right click on the cluster in failover cluster manager, go to More actions and then configure cluster quorum settings. If you use a file share, then you specify the...

No, you can use a fileshare or disk witness for the tie-breaker.

As for a listener you technically dont need one if you dont plan on your AAG failing over, but...

It doesn't matter whether it is a basic or regular availability group, the underlying failover clustering components are the same. You can go without a witness on either of them,...

It would be a resounding no from me.

I have had to support some custom Python solutions, and keeping them working is an absolute nightmare. Keeping all the dependencies working together...

Ok, just made some progress. I found an old forum post where someone was executing batch files dynamically by passing the commands as variables and it gave me an idea.

What...

I have a symptom like this regularly on a server, but it usually completely kills the whole box and can't get anything out of it until restarting the instance. The...

I didn't that 65 should be the maximum, I just said that this was the highest I have set it. I don't care what my data warehouses do in the...

This is a problem I am going to have to deal with soon. In most of our dev data, it doesn't need to be realistic data and our options are...

Frank you can definitely do that. We used to do that on a nightmare sharepoint site collection database that grew to about 3 Tb for a client. The DB grew...

Personal experience. And I mean you can just compare the instances. With all due respect to any reputable third party performing performance to cost analysis, all of the ones I...

don't think its possible. You'd have to use IPSec

The only case I have ever seen that autoshrink MIGHT be reasonable is on busy data warehouse, where extreme amounts of logging happen, then its done writing until the next...