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 →
This post is based on a real-life data auditing story, and where telemetry did the extra mile. The question was: “A Default Dimension record set has been deleted. Is it possible to know who, when and how they were deleted?” Telemetry can do A LOT of good things but unfortunately it was not meant... Continue Reading →
Took me quite a while (close to 9 weeks and half) to pack up this blog post, due to a very tight and busy schedule. Now that I am on vacation, I would like to provide you my way to determine what might be the best Update Window in order to take 2 birds with... Continue Reading →
Recently, I have been reported that after an upgrade there have been random client crashes. Let’s the hunt begin… But first: How do you handle client crashes? Ah. You are looking into Event Viewer in the Application Log in the machine that is hosting your NST. … (silence)… Well, in the online version you do... 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 →
I always told my wife that love is simple. It is expressed in binary. Values are 0,1. You are in love, or you are not in love. You can’t be 0.73% in love. To me, she is 1. And life? While love is simple, life is quite complex. Stop being slimy, you stupid romantic, and... 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 →
Application hotfixes could be easily tracked using the appropriate signal diligently prepared by Microsoft some moons ago. Below an example traces | where timestamp between (_startTime .. _endTime) | where customDimensions.environmentName has_any (_environmentName) | where customDimensions.environmentType has_any (_EnvironmentType) | where customDimensions.eventId == 'LC0159' | project timestamp , environmentName = customDimensions.environmentName , environmentType = customDimensions.environmentType ,... Continue Reading →
Version 23 is like a rose. It smells so good but has its thorn. We moved from 22.5 to 23.1 one of the so-called "Kennie’s elephant" (to be eaten byte after byte) in the cold night of 2nd December. In SaaS, it took 1.5 hours to upgrade this 50+ GB production database. In such dark... Continue Reading →
Dynamics 365 Business Central tales, myths, legends. And something serious. 