2025 central
27-28 May, 2025

Days of Knowledge Central 2025

Join us in the beautiful Darmstadt, in the midst of Central Europe, for Days of Knowledge Central 2025! This local training event offers a unique opportunity for continuous learning in Business Central and related products, mastering cloud and AI technologies and accelerating technology adoption. Stay ahead by gaining the skills to implement modern customer solutions efficiently and connect with the Dynamics community to deliver more value to your clients.

Interested in sponsoring? Click here to contact our sponsor team.

Normal ticket - 599 EUR

Group discount 10% for 5+ tickets, 20% for 10+ tickets

27-05-2025

The Cost of Poorly Written AL Code: SQL Performance

15:00 - 15:45 NEON Back to event schedule

In this session, we will explore how bad AL coding practices can lead to inefficient SQL queries, impacting the performance of Business Central. We will analyze SQL queries that are produced by bad AL code. A deep dive into SQL will show us what you should be aware of by writing your AL code and what the alternative is for it. Discover the hidden costs associated with poorly written code and learn how to avoid common pitfalls that can cause redundant database hits, excessive data reads, and overall SQL server stress. By understanding the relationship between AL code and SQL performance, you'll gain insights into best practices for writing efficient code that minimizes unnecessary database load. Equip yourself with the knowledge to optimize data retrieval, enhance system performance, and ensure your Business Central extensions run smoothly.

Speakers:

Stefan Sosic

BCILITY, CEO

Stefan is a Business Central expert and the Co-Founder and CEO of BCILITY, where he leads innovative solutions for Business Central users. He actively contributes to the Microsoft Dynamics community, sharing his knowledge and enhancing the platform through open-source Microsoft projects. As a frequent speaker at Business Central conferences, Stefan captivates audiences with his deep expertise and passion for the subject. His dedication to continuous learning and community collaboration sets him apart as a leader in the field.