Mark Brummel

I’ll start with saying that I’m not writing this blog to pick a fight or another online debate. I’m tired of getting the feeling that I’m talking into a brick wall not being heard and understood. I stopped reading most of the blogs and newsletters from MVP’s and from MSDynamicsWorld.com. I find them desturbingly sales oriented, egocentric and political. Today I was cleaning up my outlook folder for unimportant email when this article caught my eye and I could...

Let’s start with a short story. The year is 2014 and the world was spinning as it did until March this year with mass tourism and in person events. With the release of NAV 2013R2 and later 2015 our community was just starting to embrace the three tier concept and the Role Tailored Client. Nobody had heard of events or extensions. The economy is booming and everyone is busy not worrying about the future. In that year I first did a small project for Datamasons to connect their EDI solution...

Let’s start with a short story. The year is 2014 and the world was spinning as it did until March this year with mass tourism and in person events. With the release of NAV 2013R2 and later 2015 our community was just starting to embrace the three tier concept and the Role Tailored Client. Nobody had heard of events or extensions. The economy is booming and everyone is busy not worrying about the future. In that year I first did a small project for Datamasons to connect their EDI solution...

Sometimes I just have to write my frustration away in order to clear my head. Don’t expect technical tips and tricks in this post, but maybe some inspiration. Today I was absolutely flabbergasted. Both on Twitter and on LinkedIn (I am a social media junky) there were actually threads about Microsoft removing the WITH statement in AL. I was litterally like OMG! Go spend your time on the future!! https://github.com/microsoft/AL/issues/5817#issuecomment-617004754 I’m not going to spend...

Telemetry is everything, you cannot have enough data when users start asking you why the system is behaving differently than yesterday or performance is changing over time. This is where Azure SQL stands out from On Premises. You can get so much more data and in an easy way to analyse. However, you need to know where to find it because not everyting is setup automatically after you create a database. Some is, some is not. This blog is about how to connect Azure SQL Analytics to your Azure...

In my series around Application Insights for Microsoft Dynamics Business Central / NAV this is probably the most booring one. However it is quite important. In order to teach you folks about KQL and the Application Insights API etc. Step 1 – Create Application Insights In your Azure Tenant search for Application Insights and select Add. There is not much to fill in here. The Resource Group is probably most important if you have a bigger Azure Tenant. You want to group your stuff...

I just love it when I get an error and nothing I search for answers what to do next. Like this one Value ' ' does not implement interface 'ForNAV Layout' and there is no default implentation for the mentioned interface.AL(AL0596) There is no mentioning of default implementations in the Microsoft documentation . And in fact, in this enum value, I do want a default implementation since “Empty” is a fallback since I want to use the new expandable and collapsable row feature...

Another quick tip for something I’ve used this week to help out a QBS partner with performance issues on Business Central. Since the last release it’s possible to issue read-only commands on a real-time copy of your Business Central database by using the DataAccessIntent property. This allows API Pages, reports and queries to be executed outside of your production database which is ideal for Power Apps, Power BI and websites that for example only show status information on outstanding...

Microsoft wants to make things simple, and for a good reason. If it’s simple then everyone can understand it and the bigger the group of believers the easier it is to generate volume. So when I started to read on Business Central and Application Insigthts the first thing I looked at was a PowerPoint slide saying this… And to be honest, it is extremely simple to setup Application Insights for Business Central. I’ve done the setup three times now and after making one simple mistake...

So much to blog about. Insane. Our world has never changed so fast. Never. Today I was working on our ForNAV AppSource App and I decided to clean up some of the warnings that were introduced with BC16. This was about converting Options to Enums and vice versa. Converting an Enum into an Option is easy. Just add ToInteger() and you’re done. But how about the other way around? An implicit conversion is being performed from a value of type 'Option' to a value of type 'Enum "Report...