Key to Good Code

Navision legacy in AL: RecordLevelLocking

RecordLevelLocking function in AL is a heritage of the C/SIDE times and the Navision native database. In those old days when Navision...

Select with partially matching index: can we make it faster?

Let's assume we want to select a set of customer ledger entries based on two values: salesperson code and the payment reference. Or any...

Lock timeouts and deadlocks

A long time ago (in a galaxy far away) I published some blog posts with a deeper overview of the Business Central's ReadIsolation...

Configuring an Azure Health check endpoint protected with OAuth2

Recently, I had to set up the Azure Health check service for an application protected with the Microsoft OAuth2 authentication provider,...