You would use a case statement to do this.

CASE sex WHEN 1 THEN 'Female'

WHEN 0 THEN 'Male'

END AS sex

Well firstly you should have dev/test completely isolated from any other environment.  Unsure what instance 3/4/5/6/..../n are all for but if any are production then I would highly fight to...

Write-SqlTableData is for Microsoft SQL Server only.  You cannot run that function against MySQL

As Phil said a dedicated MySQL forum would be best here and maybe looking at the module...

The choice to try and solve this problem by failing over just increased the issues.  In this type of situation - the better option would have been to...

If you want to see who is running the report the execution log table and views in the report server database will tell you who and when the reports where...

SqlServerWriter requires 3 worker threads per database to backup in parallel correctly.

So if you have 1700 databases worker threads needs to be set at >5100.

If you want to use AWS...

What type of log backups are you taking?  Normal log backups or do you specify copy_only on your log backups?

Alerting sooner is always a great idea.

Restricting auto growth probably not...

You need to change it at the cluster level not in DNS.

The cluster will re-register its DNS information periodically so you need to change it at the source.

What process is SCOM actually erroring on?  Sqlservr.exe / reporting services service.exe / msmdsrv.exe?

If it is these services what your seeing is normal, tell SCOM to change the metrics as...

Yes the log on the primary will continue to grow as it hasn’t sent the data to the ASYNC replica so you need to make sure you have enough log...

You need to have some downtime, breaking the AG, reconfiguration of the application to point to the removed replica all require some downtime.

If the application doesn’t write, ensure you have...

You should do nothing except run your upgrade process.

Do not redirect clients, do not remove replicas, do not remove databases.

You should have agreed downtime in order to complete this work.

You...

You will need to set a static port and open that in the firewall instead, along with UDP 1434

This should help with that.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16

In Excel, don’t use windows credentials, switch it to use database credentials instead so on the left hand side. Windows or database or Microsoft account.  It needs to be database.

It all depends on your setup and what your trying the achieve along with your HA requirements.

Putting distribution on a standalone machine you introduce a single point of failure, but...