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 →
In SaaS, when moving from one cluster to another, an innocent token from an ISV app is renewed in a setup table. UPDATE "SQLDATABASE".dbo."CURRENTCOMPANY$EOS069_03 Sharepoint Setup$xxx" SET "Latest Token"=@0,"Token Expiration UTC"=@1,"$systemModifiedAt"=@2,"$systemModifiedBy"=@3 OUTPUT inserted."timestamp" WHERE ("Primary Key"=@4 AND "timestamp"=@5) Everything is fine. You are marching on your daily business and suddenly you see the lock timeout... Continue Reading →
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 →
Hey you. Yes, you. You. That used to create custom triggers in SQL Server. Come closer… NO. MORE. First and foremost, we all need to respect cloud rules. And in da cloud no more access to backend to cheat with insert / update / delete / rename / whatever directly from SQL. No more Russian... Continue Reading →
Application hotfixes could be easily tracked using the appropriate signal diligently prepared by Microsoft some moons ago. Below an example traces | where timestamp between (_startTime .. _endTime) | where customDimensions.environmentName has_any (_environmentName) | where customDimensions.environmentType has_any (_EnvironmentType) | where customDimensions.eventId == 'LC0159' | project timestamp , environmentName = customDimensions.environmentName , environmentType = customDimensions.environmentType ,... 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 →
That day. When Legolas does not have more arrows to kill the uruk-ahis (from LOTR). When you have no more counterspell in your mono-blue deck (from MTG). That day when a service tier crash and you have no more clue what to look for, after a long troubleshooting, to get to a solution in a... Continue Reading →
Dynamics 365 Business Central tales, myths, legends. And something serious. 