top of page


Test assertions on DateTime values
Recently, I was running a large test suite to verify my changes in the Base Application item journal posting functionality. Changes were...
Jun 12, 2023
355 views
3 comments


ReadCommitted isolation in Azure SQL
In my previous post Transaction Isolation in Business Central, I introduced a rather long and detailed review of transaction isolation...
Mar 22, 2023
579 views
0 comments


Transaction isolation in Business Central
Business Central 22 introduces a new table property ReadIsolation which allows the developers to control transaction isolation in a more...
Mar 20, 2023
2,894 views
1 comment


Conflicting updates in concurrent Business Central sessions
After my previous posts on lock escalation, it feels like a good time to take a step to a more practical plane and investigate some real...
Mar 6, 2023
1,189 views
0 comments


AL updates and locking, Part II - Optimized locking in Azure SQL
In my previous post AL updates and locking, I gave a high-level introduction into the SQL Server locking model. That post was inspired by...
Feb 23, 2023
611 views
0 comments


AL updates and locking, Part I - Introduction to lock escalation
Recently Microsoft announced significant changes in the SQL Server locking architecture which can dramatically reduce the number of lock...
Feb 19, 2023
1,118 views
0 comments

How come the size of my Sales & Receivables Setup table is 16KB?
And Bank Account Ledger Entry is non-integer? What's behind Business Central table information Have you ever asked yourself, looking at...
Feb 13, 2023
180 views
0 comments
bottom of page