top of page


Garbage collection of event subscribers
I once wrote a post on event subscribers and the presumed performance benefits of single instance subscriber codeunits, but the topic...
Apr 12
Â
Â
Â


Recursive AL
Recently I heard an opinion shared by some AL developers that recursion in AL can be dangerous and should be avoided because the AL...
Apr 5
Â
Â
Â


Buffered inserts and deadlocks
Recently I was debugging a very interesting deadlock case which I want to share in a blog post now. It was especially curious because, as...
Feb 22
Â
Â
Â


Table indexes and inserts
Following my series of posts where I have been addressing various aspects of table indexing, this post delves into the same old argument...
Dec 21, 2024
Â
Â
Â


Temporary tables in procedure parameters
When we declare multiple instances of a record variable referencing the same table in AL code, we essentially receive different instances...
Nov 24, 2024
Â
Â
Â


Hidden SQL queries in AL you (probably) want to avoid
Development of Business Central extensions is very much about the database communication, and as AL developers, we always control the...
Oct 28, 2024
Â
Â
Â


if not IsEmpty then FindSet... again
Yes, I'm back again on this inexhaustible topic. The question of weather the call of IsEmpty before FindSet in AL can have a positive...
Oct 22, 2024
Â
Â
Â


Covering indexes as an alternative to SIFT
In two of my previous blog posts I reviewed some pros and cons of the SumIndexField Technology (or SIFT) in Business Central. On the one...
Oct 20, 2024
Â
Â
Â


SIFT
SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored...
Aug 5, 2024
Â
Â
Â


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...
Jun 30, 2024
Â
Â
Â


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...
Jun 9, 2024
Â
Â
Â


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...
Jan 8, 2024
Â
Â
Â
bottom of page