Viewing 15 posts - 2,116 through 2,130 (of 39,771 total)
We don't have moderators publicly listed here. As Jeff noted, the webmaster is the best way, or post in the website issues forum
February 22, 2021 at 2:30 pm
Apologies. Editing the answer created a typo here. This has been corrected.
February 22, 2021 at 2:28 pm
It is not. They have high end storage available, but limited paths for each set of disks. Therefore, this will apply.
February 19, 2021 at 8:47 pm
This all depends on your storage. You may or may not need this. You likely will in cloud situations.
February 19, 2021 at 7:05 pm
My pleasure, and glad you got the site set up. Most people don't want to deal with running a server, and I'm glad MS and Denny are providing sites.
For events,...
February 19, 2021 at 7:00 pm
Using them on once instance works, but you still have a name resolution issue. The db names are different, so the connection string is different. I guess you can repoint...
February 18, 2021 at 6:45 pm
I think logins are an issue. IIRC, you can't get access to master, correct?
Good security practice would be a reset periodically for users, so I might just use this as...
February 18, 2021 at 6:42 pm
trigger makes this work, as Kristen noted, but it's complex in terms of maintenance and admin. Easy to lose track of these. However, if I needed to set a default,...
February 18, 2021 at 4:57 pm
First, on Dynamic Data Masking: https://www.sqlservercentral.com/steps/permissions-and-security-in-dynamic-data-masking (see the data leaking section).
There are tools, like SQL Data Masker (https://www.red-gate.com/products/dba/data-masker/), that do this. Ultimately, there isn't anything built in. Scripts...
February 18, 2021 at 4:53 pm
dbatools can help: https://www.powershellgallery.com/packages/dbatools/0.9.20/Content/functions%5CEnable-DbaForceNetworkEncryption.ps1
However. If this is a one time thing, I would guess you can click through config manager 50 times much quicker than writing a script, testing...
February 18, 2021 at 4:50 pm
I have a MySQL server (with size around 3TB and more) that I need to migrate to aws. The main purpose of shifting to aws is to build API...
February 18, 2021 at 4:41 pm
I don't see a lot on this. Most of the articles and references are to RDS, not away.
EC2 is really a VM, so this is a migration from RDS to...
February 18, 2021 at 4:40 pm
I'm with Michael. I wouldn't load dev/test with prod. You can use developer edition for dev/test, so use that, with separate environments.
Having the same IP shouldn't matter. You should never...
February 18, 2021 at 4:28 pm
Depends on your database design. Could be another column or be another table. You haven't provided enough information to give a recommendation.
February 18, 2021 at 4:25 pm
I would work with a few zip utilities and see what results you get from the command line. This might help you determine when something is broken in the transfer.
February 18, 2021 at 4:06 pm
Viewing 15 posts - 2,116 through 2,130 (of 39,771 total)