Key to Good Code

It has been said so many times that filtering on FlowFields is bad for performance that we are used to avoiding this kind of filters in...

Following my series of posts where I have been addressing various aspects of table indexing, this post delves into the same old argument...

When we declare multiple instances of a record variable referencing the same table in AL code, we essentially receive different instances...

According to this article on Microsoft Learn portal , non-clustered columnstore indexes (or NCCI) are seen as a possible replacement for...

Development of Business Central extensions is very much about the database communication, and as AL developers, we always control the...

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

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

This post is a result of one very fruitful discussion with many knowledgeable Business Central enthusiasts in a long LinkedIn thread. Now...

My previous post was dedicated to an overview of Business Central's SumIndexField Technology, or simply SIFT, which helps us collect...

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