As far as I know the certificates are required if you want to encrypt the client-server communication so that passwords and data aren't sent in plaintext across the wire

Thanks for the answers.

With VS 2019 you can target SSIS to 2012,2014,2016,2017,2019.

Can't tell you about SSRS as we use reportbuilder instead of VS

Also not sure how SSRS passes the parameters as you have a custom datatype dbo.bData

Does it pass the parameters as text or date ?

Congratulations Jeff with the 1 million points

Depends on the configuration of the app.

In ssms you have options to not to encrypt or to trust the servers certificate (even if it is invalid)

Different connection settings? (ansi nulls, ...)

Have a look how's it done in dbatools https://dbatools.io/xevents/

Even if it is a dedicated SQL box, I would configure sql server max memory to ensure there is some ram left for OS , Antivirus, ...

I don't see an issue in using randomly generated PK names for temp tables

I'm also using SCOM 2019 and run into discovery problems. Usually when the DB is disabled.

Haven't the time for a full discussion but this may be a start.

https://docs.microsoft.com/en-us/troubleshoot/system-center/scom/troubleshoot-sql-database-discovery

The required...

Could be. Didn't got notified of your reply "are-the-posted-questions-getting-worse"

The second will be better by skipping unneccessary data modifications / triggers. No point in updating billions of 999 rows to 999 rows where there are only 3 <> 999...

Answers without samples

#1: joinorder doesn't matter. SQL Optimizer permutates join order in order to get the lowest cost plan. You can switch the join order in your statement. Beware Left...

I haven't experienced major delays with Microsoft Authenticator sofar