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

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

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

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

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

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

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

Depends on your database design. Could be another column or be another table. You haven't provided enough information to give a recommendation.

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.

Roman posted the link to the Microsoft Azure Data community. I think if you do 50% of the meetings on MS related topics (Azure, SQL Server, pro dev), they'll pay...

This should be installed as a snap in to the Microsoft Management console. If you go to the properties n the server and right click, choose "Manage", this should be...

I've never been too concerned with titles, except in a few organizations where they didn't use or really understand DBAs. In those cases, mostly to fit in with HR groups...

Cut/paste strikes again. I edited the wrong item and made #1 correct. I've changed it to be incorrect.

One model, which I imagine will be familiar to Redgate, is the SQLSaturday / Sharepoint Saturday co-branded events hosted in Cambridge. Two websites, two mailing lists, two CFPs, one...

Thanks, Chris,

Personally, just for the sake of keeping things going, I'd like to see more people run virtual events this year. I think you need less people to run one,...