Tips, patterns, and real-world examples related to AL programming in Business Central.
Introduction Performance issues in Dynamics 365 Business Central are often blamed on SQL, large datasets, or slow reports. But in many real-world cases, the root cause is simpler: too many unnecessary database operations. Every Insert, Modify, or Delete hits SQL—and…
Introduction InStream and OutStream are core AL data types that almost every Business Central developer encounters early on. They are often introduced as simple mechanisms to “read” and “write” data, but that explanation is incomplete—and in practice, it is the…
When to Use Each, What Goes Wrong, and What the Correct Pattern Looks Like Introduction In Business Central development, deciding where to place logic is just as important as the logic itself. A common question is whether validation or business…
Introduction Performance issues in Business Central rarely come with clear answers. Users report that posting feels slow, a page behaves inconsistently, or a process that used to work smoothly now takes longer. Consultants try to reproduce the issue. Developers are…
💡 The Spark: Why I Wanted AL-Go to Test Itself We’ve all watched AL-Go evolve into a developer’s best friend — automating builds, signing apps, deploying to sandboxes, and releasing to production.But something was missing: confidence. Sure, your pipeline compiles,…
Introduction With the introduction of Record.Truncate() in Business Central 16.0 (Business Central 2025 release wave 2), developers gained a new, high-speed way to clear entire tables, but how much faster is it really than DeleteAll()? I decided to put it…
Filtering records is a fundamental task in Business Central AL development. Two common methods – SetRange and SetFilter – both limit the record set by a field’s values, but they work differently. This post compares SetRange and SetFilter in AL,…
Microsoft continues its semi-annual release waves for Dynamics 365 Business Central, delivering not only functional improvements but also a suite of technical enhancements for developers and technical consultants. Business Central 2025 Wave 2 (Update 27.0) focuses on boosting developer productivity, streamlining debugging, expanding…