Microsoft SQL Server JSON in 2025
Here’s what real JSON support looks like when a company has been doing it seriously since 2016 and keeps improving it every quarter.
Tag: Microsoft
Microsoft Turns Business Central into the First ERP with Built-in MCP Server Support
As AI agents evolve from assistants to autonomous orchestrators, a key question emerges: How will they seamlessly interface with core business systems like ERP without custom coding hurdles? What if your AI could query customer data, generate sales orders, or automate workflows in real-time, all through natural language?
Read more Microsoft Turns Business Central into the First ERP with Built-in MCP Server Support
Refactoring Legacy C/AL Code After Conversion to AL
Upgrading Microsoft Dynamics NAV to Business Central is rarely just a technical operation.
The longer a company postponed the upgrade, the more technical debt accumulated in the codebase. What often looks like a “successful upgrade” is, in reality, only the beginning of a much harder journey.
Read more Refactoring Legacy C/AL Code After Conversion to AL
The Journey of Storing Data for Extensions in BC
Microsoft Dynamics 365 Business Central (BC) is a modern ERP solution that has always prioritized flexibility and extensibility. One of the core mechanisms enabling customization is the extensions model, introduced in 2018 with BC 13 (formerly Dynamics NAV 2018). Extensions allow developers to modify standard objects such as tables, pages, and codeunits without altering Microsoft’s base code.
Evolution of Field Changes in BC
In both Navision (Dynamics NAV) and Business Central (BC), a field is the fundamental unit of data in a table. Fields define what kind of information is stored, how it is used in business processes, and how other objects—such as pages, reports, and codeunits—interact with it.
Event Subscribers in AL: Performance & Design Pitfalls
Event-driven architecture is one of the most powerful features of Microsoft Dynamics 365 Business Central. Event subscribers allow us to extend standard functionality without modifying base code, making solutions upgrade-safe and suitable for AppSource certification.
Read more Event Subscribers in AL: Performance & Design Pitfalls
Namespaces in AL
Before the release of Business Central 2023 Wave 2 (version 23.0), which became generally available on October 2, 2023. The AL development world faced a fundamental challenge: naming conflicts. Imagine two independent software vendors creating brilliant extensions for Business Central.
Understanding Interfaces in AL
Interfaces were introduced to Microsoft Dynamics 365 Business Central in version 2020 Release Wave 1 (BC 16). Their arrival marked a significant step toward improving extensibility, modular design, and decoupled architecture within AL development. Before interfaces existed, implementing flexible, interchangeable logic was difficult.
Partial Records in AL
Partial Records is a performance optimization feature that allows you to load only a subset of fields from a table instead of all fields.