
MARS Issues Part II | Close those Datasets!
This is a continued blog from the one I wrote earlier today about Multiple Active Result Sets (MARS) causing locks on SQL Server. In this blog I will show what happens on SQL Server if you keep result sets open during long transactions and we will discuss a possible workaround that I need your feedback on.Continue reading “MARS Issues Part II | Close those Datasets!”

Multiple Active Result Sets (MARS) causing locks on SQL Server
It has been a while since my last blog. I’ve been a little pre-occupied by my personal situation. But, the good news is that work continues as usual and it remains interesting enough to share experiences from. This blog post is about the performance of Business Central on SQL Server. It seems that this subjectContinue reading “Multiple Active Result Sets (MARS) causing locks on SQL Server”

Tip #70 | Get ID from Table
It has been a bit quiet from me for a while. My last blogpost was about two months ago. I’ve not been programming that much and I am evaluating how to move forward with my (freelance) carreer a bit. Don’t take me wrong, I am as busy as I want to be, but that currentlyContinue reading “Tip #70 | Get ID from Table”