DIVIDE ET IMPERA: the surrealist history of a long report.

January is always funny to me. All the fun comes from basically two babies: go-lives – typically starting from the 2nd week of January – and closing year activities. In this marasmus, I have fumbled in a single long running report. In SaaS, of course. This report has been a robust beastie for more than... Continue Reading →

Dynamics 365 Business Central 2024 Wave 2. What’s New in Performance.

Back from Directions EMEA 2024 in Wien, I had the time to pack up the performance enhancements included in Dynamics 365 Business Central 2024 Wave 2 (v25). Like in the previous edition: my blog, my rules. It will be a 3 blog post squeezed into one. These are my fav ones, based on their importance... Continue Reading →

Insights around Database Maintenance in Dynamics 365 Business Central Online

Sometimes, I am in the frontline spitting blood in making the most out from SQL Server installations. Needless to say, one of the most important part is to to setup a good maintenance plan, tailored on every database workload and resources available. Since SQL Server and Azure SQL are two brothers – but far to... Continue Reading →

Online Outages and Request for Refund

Hello. This is a bit long post written in few days. I simply did not want to miss anything or let anything being misunderstood. I could rephrase this blog post anytime, if required. INTRO Dynamics 365 Business Central Online is the best in class Online ERP in the world for SMB market. And for 2... Continue Reading →

About Read-Only replicas

Disclaimer: this is a serious post. So that: poker face and let's go. One of the biggest mistake that many does, is to assimilate Dynamics 365 Business Central On-Premise and SaaS backend structures. They are absolutely not the same. You could think of them as two brothers, but far away from being twins. They have... Continue Reading →

Verbose Telemetry: a potential online SQL Profiler

When working with On-Premises (that is “still a thing” – for some/many -), you have a full control and responsibility for the backend. This implies that you have full access to the database and use, for example, SQL Server Profiler to take very detailed traces on what is happening during a specific period. What about... Continue Reading →

The dark side of Tri-State Locking

There is a great song for that (ah. My wife loves that song. And so do I): Poison - Every Rose Has Its Thorn (Official Music Video) (youtube.com) Meanwhile listening to this rock ballad, when the drum kicks in heavily, try to imagine a Dynamics 365 Business Central that is rolling on a procedure and... Continue Reading →

The truth about Latency

This is for You. Yes, You. That at least once in a lifetime said, “It works on my machine”. Ah. You haven’t? Are you sure? LIAR! Everybody has (and someone more than once in a lifetime) tested an application in a standalone all-in-one-environment for whatever reason. In this case, exactly the same platform the same... Continue Reading →

My (current) favorites Lego bricks in Telemetry

Telemetry and Lego have many things in common. Both could be collected. And telemetry logs are way cheaper than Lego bricks. If you got kids and it is Xmas time, you perfectly got what I mean.  Now imagine that you have thousands of these Lego components flushed into a big bucket and you must build... Continue Reading →

A new cue in 23.1: love song for a vampire.

Version 23 is like a rose. It smells so good but has its thorn. We moved from 22.5 to 23.1 one of the so-called "Kennie’s elephant" (to be eaten byte after byte) in the cold night of 2nd December. In SaaS, it took 1.5 hours to upgrade this 50+ GB production database. In such dark... Continue Reading →

Blog at WordPress.com.

Up ↑