There are several misunderstandings, confusions or “fake-news” around, when it is about C/AL programming and how it affects performance on SQL Server. Time to clean this up!
One of the most confusing, under-documented and widely-misunderstood features of Power BI and Power Query (or Excel “Get & Transform” or whatever you want to call it) are the data privacy settings. I get caught out by them all the time, so I thought it would be a good idea to write a series of blog posts demonstrating how they work and what effect they have in different scenarios using example M queries.
RDLC reports can have performance issues occassionally. Microsoft is aware, and has been enhancing report performance in every release since this became an issue. In this blog, I will explain how you can use a small feature in RDLC reports called “labels” to optimize performance.
While NAV has traditionally mostly been a domestic animal, it’s now getting pushed more and more cloudwards. A large number of partners and customers are considering Azure VMs as their platform of choice as it has many benefits over purchasing and running the whole show in your own basement.