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/

Looks like "runs fast in ssms but slow in application"

check ms documentation https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-application-slow-ssms-fast

With modern storage I would skip index maintenance as Jef mentioned in that thread. So many layers and can be quite costly in the cloud

Most important is having correct statistics....

Sounds like what I've read earlier today about automatic tuning

Also, when a plan is forced , it is allow to compile longer?

https://littlekendra.com/2024/01/17/automatic-plan-forcing-could-be-great-but-isnt-sql-server/

https://www.brentozar.com/archive/2024/08/video-i-must-be-an-idiot-automatic-tuning-never-works-for-me/

https://dba.stackexchange.com/questions/339748/azure-sql-managed-instance-1-excessive-initial-compile-times-leading-to-app-ti

Dateformats ?

Empty or Invalid "To" when emailing ?

The latest thing thrown around is MS Fabric.

Found a page about the differences between Fabric and Dataverse https://fabriconelake.com/microsoft-fabric-vs-dataverse-comparison-for-microservices-and-data-management/ 

Our company is not that far yet to represent information as an unified...

Luckily not, didn't know that CrowdStrike existed before it happened

search on "token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission"

most articles mention logins & service principal names.https://blog.sqlauthority.com/2015/08/19/sql-server-login-failed-for-user-reason-token-based-server-access-validation-failed-with-an-infrastructure-error/ Mentions checking for deny permissions