Alexander Drogin
@erpthoughts
A Navision/NAV/Business Central developer. I enjoy coding, testing, exploring the depths of code, and writing about my findings.
Tal vez te guste
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-…
keytogoodcode.com
Buffered inserts and deadlocks
Recently I was debugging a very interesting deadlock case which I want to share in a blog post now. It was especially curious because, as it turned out, it was caused by the Business Central's bulk...
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…
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…
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…
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-…
keytogoodcode.com
Covering indexes as an alternative to SIFT
In two of my previous blog posts I reviewed some pros and cons of the SumIndexField Technology (or SIFT) in Business Central.On the one hand, SIFT views are beyond doubt the fastest way to obtain...
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
An example of a negative configuration option at its finest. So I need to set "modules" to false and "node" as the target to use ESM modules instead of Node's CJS. Makes perfect sense.
Finally ready to publish my test results on the hot topic of the week: if not IsEmpty then FindSet wix.to/Q1FoxUz
keytogoodcode.com
if not IsEmpty then FindSet... Or not?
This post is a result of one very fruitful discussion with many knowledgeable Business Central enthusiasts in a long LinkedIn thread. Now I want to start the post by saying big thank you to everyone...
Let us step to the dark side and see how Business Central's SumIndexFields, so efficient in reads, can wreak havoc on updates. #dyn365bc #businesscentral #sqlserver wix.to/tU6PUOZ
SIFT, or SumIndexField Technology, dr. Jekyll and mr. Hyde of Business Central. Let's have a look at its benevolent personality before exploring the dark side of our hero (with I will save for the next post). wix.to/M3OU2SI
keytogoodcode.com
SIFT
SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored precalculated summed amounts directly in index nodes, so that aggregated...
AL language allows external diagnostic analysers. Thanks to this, we have the community-driven LinterCop. But the code action service does not load external libs, so no quick fixes for custom rules. No ReSharper for AL either. Is it a worthy BC idea to make it extendable?🤔
Worst kind of randomisation in test fixture is one that defines the whole test flow rather that the outcome of a specific calculation. Something like: Contact."Business Relation" := Random(5) - 1; What the heck?! What do we even want to test here?
One impractical blog post. Rather a reminder that some AL functions still exist for backward compatibility with code decades old. wix.to/URtmt7n #dyn365bc #businesscentral #sqlserver
keytogoodcode.com
Navision legacy in AL: RecordLevelLocking
RecordLevelLocking function in AL is a heritage of the C/SIDE times and the Navision native database. In those old days when Navision server offered its own database management system, RecordLevelL...
In this blog post, I am exploring one curious method of presumed performance enhancement of SELECT queries, just to demonstrate why it is not going to work. wix.to/Hxpq3Ia #dyn365bc #businesscentral #sqlserver
Unfortunately, I am not attending BC Tech Days this year, but this is definitely a session not to be missed.
I would argue the perfect last session for your #BCTechDays conference is to join Torben Meyhoff and I, for our session: Tri-State Locking: Reducing locking in the runtime We will explain AL's locking scheme in-depth and explore recent improvements in the area.
Resuming my "SQL Server for Business Central" blog series. Let's talk about deadlocks: what it is and some examples of potentially deadlocking code. #businesscentral #dyn365bc #sqlserver
Not quite my usual BC blog post, but an interesting spin-off in my dev experience. My findings from configuring a very helpful #Azure service. wix.to/z8dHeFL
The weirdest thing I've seen in Azure. Two users open a function app config. One can set TLS version to 1.3, the other does not have this option. Same subscription, same app, users in the same AAD. Does it have any reasonable explanation except different screen resolution?
United States Tendencias
- 1. #TT_Telegram_sam11adel N/A
- 2. #hazbinhotelseason2 44.1K posts
- 3. LeBron 84.2K posts
- 4. #DWTS 53.9K posts
- 5. #LakeShow 3,987 posts
- 6. Peggy 19.2K posts
- 7. Whitney 16.2K posts
- 8. Keyonte George 1,932 posts
- 9. Reaves 8,694 posts
- 10. #InternationalMensDay 21K posts
- 11. Kwara 159K posts
- 12. PATRICK STUMP N/A
- 13. Jazz 27.7K posts
- 14. Grayson 7,116 posts
- 15. Orioles 7,158 posts
- 16. Celebrini 5,121 posts
- 17. DUSD N/A
- 18. Tatum 16.9K posts
- 19. Taylor Ward 3,632 posts
- 20. Dearborn 234K posts
Something went wrong.
Something went wrong.