Log can grow larger than data ( it also needs to log index activity) for making rollback possible.

Delete in small batches to minimize duration and locking. (it may be locked...

You might try kinit https://stackoverflow.com/questions/62774343/cmd-command-runas-equivalent-in-macos

Hello Sam,

I would start with User specific chosen queries ( as you get paid for those )

As tuning can be a lengthy process , you can stop when it's good...

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"