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

Destructive Master Data Management

This is one of the posts which I could probably mark with a Destructive Advice tag. I think I will add it to my list of tags one day. A...

The case of a missing newline character. One almost detective story.

This almost detective story started when I was building a client app in Business Central which sent data to a JavaScript control add-in...