Viewing 15 posts - 1 through 15 (of 33 total)
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,...
July 23, 2019 at 7:29 pm
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...
July 23, 2019 at 7:05 pm
Check out dbatools.io
July 16, 2019 at 7:33 pm
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...
July 16, 2019 at 4:52 pm
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...
July 15, 2019 at 3:34 pm
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,...
July 15, 2019 at 2:25 pm
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...
July 12, 2019 at 2:54 pm
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...
July 11, 2019 at 7:21 pm
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...
July 11, 2019 at 7:10 pm
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...
July 11, 2019 at 5:04 pm
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...
July 11, 2019 at 4:09 pm
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...
July 11, 2019 at 4:02 pm
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...
July 11, 2019 at 3:57 pm
don't think its possible. You'd have to use IPSec
July 8, 2019 at 7:32 pm
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...
July 8, 2019 at 7:12 pm
Viewing 15 posts - 1 through 15 (of 33 total)