Prettier plugin for Business Central's AL language - adrogin/al-prettier

Demo app from my BC TechDays 2026 session. Contribute to adrogin/BCTechDays26 development by creating an account on GitHub.

As a follow-up to my previous post, I'd like to linger a little longer on the topic of wide rows and the effects of row overflow in SQL Server, and specifically on the storage impact that we can obser...

Introduction of the SetLoadFields function in AL language that allowed to limit the number of fields returned to the Business Central server by a SQL query was a big step forward towards achieving bet...

Since the time when I came across this post by Waldo (or actually, he mentioned his test results in one online discussion) I was curious to try it myself and dig into its unexpected results. The quest...

Back in the old Navision days, when clients' data were stored in the Navision native database instead of Azure SQL Server, and functions like FindSet and FindFirst did not exist in the AL language, ev...

I once wrote a post on event subscribers and the presumed performance benefits of single instance subscriber codeunits, but the topic keeps reappearing every now and then, and I feel it could be a good idea to add a few more arguments to the same old debate. Because why not run a few useless, but highly entertaining tests on a Saturday evening.One statement in defense of the single instance event subscribers is that the subscriber codeunit does not have to be disposed after the execution and rem

Visual control add-ins for Business Central. Contribute to adrogin/BCVisuals development by creating an account on GitHub.

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 it turned out, it was caused by the Business Central's bulk in...

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 AL at all costs. So whenever a developer needs to select a subse...

Following my series of posts where I have been addressing various aspects of table indexing, this post delves into the same old argument from a different point of view. Previously, I measured timings ...

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