Dynamics Business Central / NAV Developer Digest - Vol. 494
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes a reminder to register for Days of Knowledge Americas, using SetCurrentKey, telemetry for SQL, and what’s coming in Business Central 2024 Wave 2.
The Dynamics 365 Business Central community, consisting of developers, project managers, and consultants, collaborates across various platforms to share valuable insights. At ArcherPoint, we greatly value their dedication and expertise. To ensure widespread access to this technical knowledge, we created Developer Digest.
Reminder: Days of Knowledge coming this September!
Just a reminder: Days of Knowledge Americas 2024 is coming September 12-14 to Atlanta, Georgia. This event features two days of training sessions geared for Business Central consultants and developers. It’s time to register – we hope to see you there!
Using SetCurrentKey
Kyle asked: Is SetCurrentKey a requirement these days, or is BC smart enough to let the SQL server choose the best key for performance? I’m not asking about sorting order; I’m asking whether adding a new key in a table extension is sufficient.
Matt replied with: It’s not technically a requirement, but SQL doesn’t always make the best decisions. I’m guilty of not using SetCurrentKey as much as I should.
Verbose telemetry for SQL
A useful (but potentially cumbersome) debug methodology is to analyze all SQL statements for a given period and specific session by enabling verbose telemetry. While verbose telemetry can adversely impact system performance, it provides valuable information on SQL queries being processed during the time interval you select.
Duilio Tacconi describes using verbose telemetry in his blog, Verbose Telemetry: a potential online SQL Profiler.
Coming this fall: Business Central v25 (2024 Wave 2)
Microsoft recently announced the new features being planned for the upcoming release of Dynamics 365 and Power Platform.
Roberto Stefanetti outlines some of his favorites, like new reports and demo data for financial reporting, automated tests for Copilot extensions, using Azure AI Document Intelligence to capture data from e-docs (such as invoices and receipts), and over 70 new Power BI reports. Read his blog, Business Central 2024 Wave 2 – what is planned, to learn more.
Stefano Demiliani discusses his favorite development features in his blog, Dynamics 365 Business Central v25: what’s coming for developers, including:
- External app dependencies – Developers creating AL extensions that have dependencies on AppSource apps have to work with the app’s publisher to request symbols to develop against or runtime packages to test with. The new release will allow developers to download symbols for AppSource applications to develop against and test in online sandboxes.
- Extend AL interfaces – Developers can create adaptable functionality to interfaces without changing the core system.
- Package resources in extensions – The new release will allow developers to include initialization and setup data with their extensions and consume that data from AL.
And Erik Hougaard reviews the new release in his video, What’s coming in Business Central 2024 Wave 2 aka BC25.
Find out about all the new features coming to Business Central and other Microsoft products by reading Microsoft’s list of all the new features planned for Business Central 2024, release wave 2.
++++++++++++++++++++
Are you interested in Dynamics NAV and Business Central development? Check out our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.