This feature is simulating and also similar (not the same) to what the SQL NEWSEQUENTIALID does in order to generate consecutive GUIDs. See more on: NEWSEQUENTIALID (Transact-SQL) - SQL Server | Microsoft Learn This command is available since SQL Server 2005 (version 9.0). So the first question comes natural (why they took so long... NAAA...... Continue Reading →
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 enhancement introduced with Dynamics 365 Business Central 2025 Wave 2 (version 27) is placing the in-client profiler somewhat close to the good-old Event Tracing for Windows (ETW) in Dynamics NAV (https://github.com/wortho/EtwPerformanceProfiler), where you can profile C/AL code with SQL Statements, and also similar to its predecessor: the Client Monitor in CSIDE. Well, you had... Continue Reading →
Legacy posting has been performed, for ages, following the primary key sorting order: (“Document Type”, “Document No.”, “Line No.”). And when it is time to post, it posts one document at the time. So, now, the sorting order is following the “Line No.”. With very heavy concurrency and/or in stretched exotic scenarios, processing by following... Continue Reading →
New version, new performance goodies from Dynamics 365 Business Central Product Group. Telling you the truth, version 27 is not an Armageddon version, speaking about performance, and if you want to give it a name, c’mon, … it IS the “Agentic version” ! Nevertheless, there is always something super good (and cool) in the performance... 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 →
January is always funny to me. All the fun comes from basically two babies: go-lives – typically starting from the 2nd week of January – and closing year activities. In this marasmus, I have fumbled in a single long running report. In SaaS, of course. This report has been a robust beastie for more than... Continue Reading →
Back from Directions EMEA 2024 in Wien, I had the time to pack up the performance enhancements included in Dynamics 365 Business Central 2024 Wave 2 (v25). Like in the previous edition: my blog, my rules. It will be a 3 blog post squeezed into one. These are my fav ones, based on their importance... Continue Reading →
Dynamics 365 Business Central tales, myths, legends. And something serious. 