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

Glad it sorted out!

C# . It's mostly used by our devs.  ( it helps translating ORM implementations ). Investing R / ML is on hold as you need quite a statistical background

I welcome the free toolset and hope it gets a place next to sp_WhoIsActive, FirstResponder.

Are there real world examples where the tool was used?

You may also try configure HTTP first and then switch to https

Not really.

Currently I have the following in PowerBI rsreportserver.config

<URLReservations>
<Application>
<Name>ReportServerWebService</Name>
<VirtualDirectory>ReportServer</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>....../AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
<Application>
<Name>ReportServerWebApp</Name>
<VirtualDirectory>Reports</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>........</AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
</URLReservations>

I would suggest setting max ram per instance.

As far I know SQL Server keeps consuming memory and never releases it, potentionally not leaving enough ram for OS, AV, ...

It can...

Thanks for voluntering. It's certainly helpful to make the skills more popular.

At Belgium we have coderdojo's to learn children to create websites, games, ... in the hope they will use...

You've must have exhausted all other options. Maybe they have a six figure salary job opening