In the online environment, the lock timeout duration is set to 30 seconds and, until now, cannot be changed anywhere. On-premises there is a parameter in CustomSettings.Config to override the default value, called SqlLockTimeoutOverride: The default value is stored in $ndo$dbproperty table, locktimeoutperiod field (that is set, in Dynamics 365 Business Central 2025 Wave 2... Continue Reading →
Back to blog after a long pause. It wasn’t my intention, but organizing an event like Italian BC Day, it is not so finger snap, honestly, and the week after presenting with Stefano Demiliani at Dynamics Minds did not help either with time management. Both events were a blast and gave the real spirit of... Continue Reading →
This blog post is more oriented to ISVs, but anyone could benefit from it and compared to other posts it is shorter and more serious. So less meme and more meat. Resumed in a nutshell: Obsoleting Key (and SIFT) does NOT apply any changes to existing metadata structure. Let’s make a simple example to make... Continue Reading →
This blog post is dedicated to all braves who dare to commit platform and application changes for good, no matter if code lines were there since the dawn of time. Working hard on upgrading and updating all our customers to the latest version, I was waiting for 2025 Wave 1 (v26) to be officially in... Continue Reading →
In SaaS, when moving from one cluster to another, an innocent token from an ISV app is renewed in a setup table. UPDATE "SQLDATABASE".dbo."CURRENTCOMPANY$EOS069_03 Sharepoint Setup$xxx" SET "Latest Token"=@0,"Token Expiration UTC"=@1,"$systemModifiedAt"=@2,"$systemModifiedBy"=@3 OUTPUT inserted."timestamp" WHERE ("Primary Key"=@4 AND "timestamp"=@5) Everything is fine. You are marching on your daily business and suddenly you see the lock timeout... Continue Reading →
When working with On-Premises (that is “still a thing” – for some/many -), you have a full control and responsibility for the backend. This implies that you have full access to the database and use, for example, SQL Server Profiler to take very detailed traces on what is happening during a specific period. What about... Continue Reading →
Hey you. Yes, you. You. That used to create custom triggers in SQL Server. Come closer… NO. MORE. First and foremost, we all need to respect cloud rules. And in da cloud no more access to backend to cheat with insert / update / delete / rename / whatever directly from SQL. No more Russian... Continue Reading →
There is a great song for that (ah. My wife loves that song. And so do I): Poison - Every Rose Has Its Thorn (Official Music Video) (youtube.com) Meanwhile listening to this rock ballad, when the drum kicks in heavily, try to imagine a Dynamics 365 Business Central that is rolling on a procedure and... Continue Reading →
Dynamics 365 Business Central tales, myths, legends. And something serious. 