It is not. They have high end storage available, but limited paths for each set of disks. Therefore, this will apply.

This all depends on your storage. You may or may not need this. You likely will in cloud situations.

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

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

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