My previous post on good and bad coding practices in terms of the performance touched upon one particularly contradictory coding pattern...

This post is my shortlist of the most common beginners' mistakes in AL that affect application performance. These are not necessarily the...

Continuing performance testing of queries on extended Business Central tables, today I want to look at the same dataset from a slightly...

Server-side perspective One of the key characteristics of the C/AL language and its more modern ancestor, AL, that makes it so attractive...

Today, once again, I am returning to the topic of table locking, lock escalation, and the way Business Central interacts with SQL Server...

The effects of SetLoadFields and AutoCalcFields on caching This post continues the topic of query caching in Business Central which I...

Recently, I was running a large test suite to verify my changes in the Base Application item journal posting functionality. Changes were...

In my previous post Transaction Isolation in Business Central, I introduced a rather long and detailed review of transaction isolation...

Business Central 22 introduces a new table property ReadIsolation which allows the developers to control transaction isolation in a more...

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...

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...

Recently Microsoft announced significant changes in the SQL Server locking architecture which can dramatically reduce the number of lock...

And Bank Account Ledger Entry is non-integer? What's behind Business Central table information Have you ever asked yourself, looking at...