A poor man's solution: logon-triggers https://www.sqlshack.com/prevent-sql-server-login-authentication-scope-using-logon-trigger/

can't really help you further

you may want to check out https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/tls-and-sql-server-reporting-services-an-interesting-interaction/ba-p/2477049 regarding TLS 1.0

or find another clue in the reportserver logs

There are different levels of timeouts

Connection timeout

Command timeout

Remote query timeout

Can you provide some background?

"Could not establish trust relationship for the SSL/TLS secure channel"

If you browse / upload to SSRS. Is that using https or http. Is the SSRS certificate or...

Depends on the access pattern. Usually one clustered index per table is preferred to prevent ghost-records.

I suggest watching https://www.brentozar.com/training/think-like-sql-server-engine/ for an introduction how sql server works and when sql...

I've found this https://learn.microsoft.com/en-us/answers/questions/1848448/unable-to-process-the-existing-user-settings-and-w

Mentions repairing .NET installation and moving the current user settings xml to generate a fresh set

Hello Goodtimecharlie,

Can't tell you about a busy AG system or clusters.

We're using Veeam for a SQL Server standalone. I/O freezes about 4 seconds on our busier systems. So far transactionslog...

Is there a way to commit the transaction log after a proc executes, so the log doesn't fill up and kill the job:

Smaller transactions: as long the transaction is running...

Thanks for this topic. Looking forward to the next one

Also, MS has a specific client https://www.oracle.com/database/technologies/appdev/ocmt.html that eases installation for powerbi.... may be worth a try

if it is nvarchar it should be WHERE param=N'p1'  instead of WHERE param='p1'

That's odd, I would expect better performance because it can sniff the hardcoded value and use it for the query plan.

Perhaps the hardcoded value is not the same datatype as...

Why are you not memory capping SQL Server in order to leave some RAM reserved for OS / other applications ?

Have a look at https://www.sommarskog.se/query-plan-mysteries.html

Slow in app / fast in ssms symptom

Like when debugging you may have setted the variable to literals which sql server can sniff for a...

As you mention it happens in ssms too

it also coud be "parameter sniffing" https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/