SQL Server allows table rows to exceed the 8KB data page limit. But... some curious side effects can happen. www.keytogoodcode.com/post/another...

SetLoadFields function helps developers to avoid unnecessary table joins and reduce the amount of data sent over the network. But how significant is the benefit of a smaller dataset? When does it really make a difference? Some measurements in a blog post. www.keytogoodcode.com/post/perform...

It looks like I need to practice my skills in using the Ctrl+F function. I once asked how I could generate a hash with the Cryptography Management codeunit based on a binary key. Easy, it turns out. There is a function for this that accepts a base64 key. I just did not find it.

How can just in time loads be faster than a full record load? After all, this means two queries reading the same table. And two are slower than one, right? Right, but only if we allow these two queries to run until completion. www.keytogoodcode.com/post/jit-loa...

Which side are you on when it comes to the question whether SetCurrentKey is beneficial for data access performance in AL? Should we use it or drop it? I give a definite and unequivocal answer: it depends. www.keytogoodcode.com/post/to-sort...

I have a good question for #bcalhelp. I need to generate a hash with a function from Cryptography Management CU, which requires a text argument as the key. But I need to send a byte array. Text in AL is UTF-8, so bytes above 7F turn into 2-byte sequences, and my key never matches the counterpart.

@nataliekarolak.bsky.social has been concerned about the lack of activity on BSky. I have a suggestion. How about garbage collection? Seems to be a good topic to talk about. www.keytogoodcode.com/post/garbage...

I worked a little more on the BC cost tracer and added a couple new features: node grouping and a new layout with the fCoSE algorithm, which is very efficient in compound nodes clustering. Thanks to this algorithm, item ledger entries can be grouped by the document no. github.com/adrogin/BCVi...

Looking forward to be on stage at @bctechdays.com with @stefanmaron.com

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. www.keytogoodcode.com/post/buffere...

The holidays are almost over, next week I am back to work and other Business Central activities. But these two weeks made a great breakaway tour.

Are you afraid of filters on FlowFields in AL? Well... There is definitely a reason to be cautious. But it may not be as bad as it seems, and certainly not as bad as some other methods which are used to avoid these filters. www.keytogoodcode.com/post/filteri...

Following my series of posts where I've been addressing various aspects of table indexing, this post delves into the same argument from a different point of view. Now I want to ask a question: how indexing impacts query performance from the insert/update side. www.keytogoodcode.com/post/table-i...

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. www.keytogoodcode.com/post/tempora...