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...

If you ask a random Microsoft partner about their worries with Business Central there is a fair chance “Performance” is in their top three. It probably depends if this partner has a background with NAV. If this is the case it’s a guarantee it’s in the list. As long as I remember I’ve been doing some form of performance tuning. First with the old Native Navision database, later with SQL Server and now on Azure SQL. It’s not really a surprise that when I joined...

If you ask a random Microsoft partner about their worries with Business Central there is a fair chance “Performance” is in their top three. It probably depends if this partner has a background with NAV. If this is the case it’s a guarantee it’s in the list. As long as I remember I’ve been doing some form of performance tuning. First with the old Native Navision database, later with SQL Server and now on Azure SQL. It’s not really a surprise that when I joined...

If you ask a random Microsoft partner about their worries with Business Central there is a fair chance “Performance” is in their top three. It probably depends if this partner has a background with NAV. If this is the case it’s a guarantee it’s in the list. As long as I remember I’ve been doing some form of performance tuning. First with the old Native Navision database, later with SQL Server and now on Azure SQL. It’s not really a surprise that when I joined...

If you ask a random Microsoft partner about their worries with Business Central there is a fair chance “Performance” is in their top three. It probably depends if this partner has a background with NAV. If this is the case it’s a guarantee it’s in the list. As long as I remember I’ve been doing some form of performance tuning. First with the old Native Navision database, later with SQL Server and now on Azure SQL. It’s not really a surprise that when I joined...