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 →
After the amazing as much as unexpected incredible success of previous year edition, I am genuinly proud to announce: BC DAY ITALY – second edition - (aka Italian bc day) THU 7th MAY 2026 This event is: FREE OF CHARGE. Yes. It is gratis, free, gratuito. In ITALIAN LANGUAGE. Technical and functional sessions. With a... Continue Reading →
Straight to the point. THE APP The repo is open for contribution since 11th December 2025: directions4partners/CCMS: CCMS (Cloud Customer Management System) You can download the free app or – even better – fork the repo (and contribute 😉) If you want to know what it actually does, just look at CCMS/CHANGELOG.md at main ·... 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 →
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 →
Dynamics 365 Business Central tales, myths, legends. And something serious. 