Dynamics NAV / Business Central Developer Digest - Vol 394
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central development and Dynamics NAV development. In Developer Digest Volume 394, you’ll learn about administering BC online, what’s coming in BC 2022 wave 2, issues causing SQL locks, and more.
The Dynamics NAV and Business Central community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media…so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there?
So, the ArcherPoint Microsoft Dynamics NAV/BC Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV/BC experts and devotees around the world. We hope these insights will benefit you, too.
Administrating Microsoft Dynamics 365 Business Central Online
Andrey Baludin has a new book, Administrating Microsoft Dynamics 365 Business Central Online, available in Kindle and paperback versions on Amazon. This hands-on guide is for admins, developers, and consultants who manage BC SaaS environments and contains setting up migration from an on-premises environment, planning for future releases, analyzing telemetry, understanding tenant capacity limits and their usage of resources, automating processes with APIs, and much more.
Multiple Active Results Sets Causing SQL Locks
Marije Brummel addresses a native feature of SQL Server, Multiple Active Results Sets. In Business Central, the need for memory for transactions was handled by SQL Cursors. When working with datasets using AL, you’ll want to have an understanding of Multiple Active Results Sets and the possibility of MARS causing locks on SQL Server. Marije advises the best fix to this potential issue is creating short (not long-running) transactions and ensure you have good indexes. She follows up with another post about Closing the Datasets, with a third and final installation in this saga coming soon.
What’s New and Coming in BC 2022 Wave 2
Roberto Stefanetti shares some of the upcoming improvements in the fall 2022 Business Central release, including development, governance/admin, Power Platform, productivity, and user experience. Erik Hougaard does as well in his latest vlog, What’s Coming in BC 2022 Wave 2 aka v21.
BC Open Discussion Still Going Strong
And why wouldn’t it be? Saurav Dhyani has hosted his 89th meeting where he and other experts answered questions about Business Central development and functionality. Check out his YouTube channel to catch up on the most recent BC Open Discussion recordings and join in on the next call by registering for the next #bcopendiscussion.
Interested in Dynamics NAV and/or Business Central development? Be sure to see 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.