The last blog post about performance improvements in v27 (Dynamics 365 Business Central 2025 Wave 2). It is a very subtle – but proficient – optimization to what was (and is) called SmartSQL. SmartSQL was introduced – if my mind assists – with NAV 2013 (version 7.0) more than 10 years ago. (Yeah. Exactly that... Continue Reading →
Apologize for a one-month+ silence but during go-live season, as Bradely Cooper stated in "Silver Lining playbook": “… It took so long for me to catch up… I just got stuck. Pat. ...I wrote that one week ago…” Cut the crap, you stupid romantic... Aaaand now, ladies and chesterfield, the already buzzed brand new and... Continue Reading →
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 →
Dynamics 365 Business Central tales, myths, legends. And something serious. 