We tend to have small teams at Redgate, but we have many of them.

Note that not everyone moves every year. Plenty of people choose to stay with the same team...

Most people are happy with he/she being used, according to their personal preference. However, there are starting to be people that are uncomfortable with those forms of address and may...

Crazy. In the nuclear plant, we were very strict with this. Password on post-it = pink slip.

We also disconnected the SCADA stuff from the external network. Everything controlled inside the...

Perhaps, but not always: https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but

Creating a new filegroup for everything does not always work. Space constraints are one reason for this.

This isn't to imply the solution is the only one or the one that...

We don't have moderators publicly listed here. As Jeff noted, the webmaster is the best way, or post in the website issues forum

https://www.sqlservercentral.com/forums/forum/sqlservercentral-com/sqlservercentral-com-website-issues

Apologies. Editing the answer created a typo here. This has been corrected.

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