if not IsEmpty then FindSet... Or not?
This post is a result of one very fruitful discussion with many knowledgeable Business Central enthusiasts in a long LinkedIn thread. Now...
top of page
Key to Good Code
DEVELOPER'S VIEW ON MICROSOFT BUSINESS CENTRAL
- Aug 9
The dark side of SumIndexFields. Concurrency.
My previous post was dedicated to an overview of Business Central's SumIndexField Technology, or simply SIFT, which helps us collect...
371 views2 comments
- Aug 5
SIFT
SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored...
246 views4 comments
- Jun 30
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...
180 views0 comments
- Jun 20
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...
213 views0 comments
- Jun 9
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...
686 views0 comments
- Jun 2
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,...
151 views0 comments
- Mar 16
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...
461 views0 comments
- Jan 8
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...
956 views0 comments
- Nov 26, 2023
Read Committed Snapshot isolation and the Write Skew anomaly
Much has been said recently about the benefits of the Azure SQL for Business Central performance, and in particular a few articles...
627 views0 comments
bottom of page