Alexander Drogin

@ExtensionsF No, it still applies to SaaS. Actually this issue cropped up in a SaaS environment first and I had difficulties reproducing it on my local dev instance. Bulk inserts are enabled in SaaS, no other differences in locks during inserts.

@erpthoughts Saas has a different table-locking mode and the problem in question is not relevant. or not?

I almost never use the return value of the Insert function in AL, but recently I found it useful in avoiding a specific deadlock situation. And the deadlock itself was a very curious one. keytogoodcode.com/post/buffered-…

Did you ever get confused with Business Central's temporary tables and the way temp tables are passed to procedure parameters? I did too, so I wrote a post as a memo. #businesscentral #dyn365bc keytogoodcode.com/post/temporary…

@ajkauffmann @EPErnst @KarolakNatalie Oh, I did not know that I'm also accounted in that number! webpack, babel/core, jest-cli, ts-loader - looks like my package.json dependencies.

@erpthoughts @EPErnst @KarolakNatalie And that module depends on the module is-odd (downloads over 19 million) and has one line of code in it: return !isOdd(i) 🤯😵‍💫🤭🤐 Some people have an opinion about it: reddit.com/r/programming/…

I'm "if not bool then" what are you?

@ajkauffmann @EPErnst @KarolakNatalie Yes, this is what logic suggests. But 17 million downloads of the is-even package defy the logic.

@erpthoughts @EPErnst @KarolakNatalie I would never install a module for such a basic function.

@ajkauffmann @EPErnst @KarolakNatalie Or an approach popular in another language domain npm install is-even

@erpthoughts @EPErnst @KarolakNatalie ok, here are three alternatives for heroes: 🤓 return((number & 1) == 0) return((n ^ 1) == (n + 1)) return(((number >> 1) << 1) == number)

@ajkauffmann @EPErnst @KarolakNatalie Nah! That's not the way for true heroes.

@erpthoughts @EPErnst @KarolakNatalie return(number % 2 == 0) Is all you need 😂

@KarolakNatalie I don't expect it to be widely adopted in BC solutions. Never actually heard of any live implementations with columnstore indexes. And that's really the main reason I'd like to hear from people who tried it.

@erpthoughts I have to confess: No experience at all 🙈

This post is an attempt to summarize my experience in using columnstore indexes in Business Central: possible use cases and some performance analysis. What is your experience in using columnstore indexes? #dyn365bc #businesscentral keytogoodcode.com/post/another-a…

@EPErnst @KarolakNatalie I wish there was an easier way to do this!😀

@erpthoughts @KarolakNatalie Have seen that one a few times too. But I have seen an even worse variant of it: procedure DoSomething(): Boolean begin if MySetupRec.BooleanField = true then begin exit(true); end else begin exit(false); end; end;

@KarolakNatalie @EPErnst Yes, definitely. But you know what really drives me nuts? Constructs like this. Which I've also seen quite a few times. procedure DoSomething(): Boolean begin if MySetupRec.BooleanField = true then exit(true) else exit(false); end;

@erpthoughts @EPErnst Yes, and the majority seems to be as well: x.com/KarolakNatalie… However, I still see the alternative being practiced by partners or customers quite often.

@KarolakNatalie Congratulations! Writing a book is not an easy journey.

OMG I did it, I've just published my first book ever! 🥳 #msdyn365bc The classic "Programming Microsoft Dynamics 365 Business Central" is back! Time to reflect how it all began ... nataliekarolak.wordpress.com/2024/11/08/my-…

@DuilioTacconi I don't think that SaaS experience is so unique that even core runtime libraries are totally different. This is a debugger snapshot from a sandbox session. SQL4 returned a row, then three sequential queries return empty set, and the last two run "IF EXISTS".

@erpthoughts Just to be on the same line, I think you are reffering to the lines in the picture. Not debating here that these are in BC dlls - 'course - but if those are executed when db runtime is Azure SQL (or isSaaS).

I went as far as doing another post on the "if not IsEmpty then FindSet" pattern. Don't beat me too hard for reviving the topic again, but I think this query can shed some light on the old urban legend of the "second roundtrip" of the FindSet function. keytogoodcode.com/post/if-not-is…

@DuilioTacconi Thanks for the note. Right, it's a Docker container. I actually ran into this when I was looking at the server code - counter is in the query command object, so I'm sure this is not a weird fluctuation. But I'll run the test on a sandbox as well to leave no space for doubts.

@erpthoughts Interesting. Since u run profiler, I believe this is on a Docker container or any SQL on-prem. Just to be sure it is 100% in the bc bits, have you tried with the same with latest vanilla sanbox in saas? Just out of curiosity.

@arturass I guess guess it may even older, but somehow I never heard about it, and only now found the source of this query.

@erpthoughts This is very old feature which I have seen probably from version ~ NAV2015.

@JeremyVyska Exactly, that's the idea I want to convey - there is no silver bullet solution. What works good for reads can backfire on writes and vice versa. Although, when used creatively, SIFT keys can be turned into posting safeguards, like MS did with the new warehouse posting design.

@erpthoughts Nice details. It shows that we have to be thoughtful about where we want the time spent - in transaction or after the fact. It makes a nice new option for speed on Update, with still lower delay on Read. But as with all things, it's not a one-solution-fits-all-situation tool,

In a couple of my previous blog posts I was reviewing the benefits and dangers of SIFT views in Business Central. Now I want to take a look at a possible alternative - how indexes with included fields perform compared to SIFT. #dyn365bc keytogoodcode.com/post/covering-…

Recently, I've been practicing my TypeScript skills, and now ʧarm is the result of my exercises. This is a tool allowing intuitive graphical presentation and editing of timelines. github.com/adrogin/tscharm