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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
Locking mechanisms are quite complex and so long to be deeply explained that could be used as a bulletproof lullaby if you need to let kids fall asleep. Or if you want to give up on someone at a speed date. Ok. That is the max level of humor admitted when talking about locking and... Continue Reading →
Dynamics 365 Business Central tales, myths, legends. And something serious. 