Alexander Drogin @erpthoughts

A Navision/NAV/Business Central developer. I enjoy coding, testing, exploring the depths of code, and writing about my findings. keytogoodcode.com Malta Joined July 2022

Tweets

301
Followers

155
Following

65
Likes

483

Alexander Drogin @erpthoughts

7 months ago

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-…

1 0 5 117 0

Alexander Drogin @erpthoughts

10 months ago

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…

1 0 11 265 1

Alexander Drogin @erpthoughts

10 months ago

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…

1 0 1 186 1

Alexander Drogin @erpthoughts

11 months ago

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…

3 2 12 744 2

Alexander Drogin @erpthoughts

11 months ago

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-…

1 3 10 645 2

Alexander Drogin @erpthoughts

11 months ago

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

0 0 3 307 0

Download Image

Alexander Drogin @erpthoughts

11 months ago

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.

0 0 0 134 0

Download Image

Alexander Drogin @erpthoughts

a year ago

Operation is successful. Just stay cool and keep trying.

1 0 8 343 0

Download Image

Alexander Drogin @erpthoughts

a year ago

Finally ready to publish my test results on the hot topic of the week: if not IsEmpty then FindSet wix.to/Q1FoxUz

0 1 11 360 1

Alexander Drogin @erpthoughts

a year ago

I did it! I did it! 10 sessions in a deadlock chain. ☠️☠️

1 0 5 600 0

Download Image

Alexander Drogin @erpthoughts

a year ago

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

1 3 4 442 2

Alexander Drogin @erpthoughts

a year ago

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

0 3 6 475 2

Alexander Drogin @erpthoughts

a year ago

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?🤔

2 0 4 434 1

Alexander Drogin @erpthoughts

a year ago

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?

1 0 0 175 0

Download Gif

Alexander Drogin @erpthoughts

a year ago

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

0 0 2 172 1

Alexander Drogin @erpthoughts

a year ago

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

0 3 6 363 0

Alexander Drogin @erpthoughts

a year ago

Unfortunately, I am not attending BC Tech Days this year, but this is definitely a session not to be missed.

Mads Gram @PhDuck2

a year ago

Unfortunately, I am not attending BC Tech Days this year, but this is definitely a session not to be missed.

3 6 30 1K 2

Download Image

1 0 4 326 0

Alexander Drogin @erpthoughts

a year ago

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

1 0 4 537 2

Alexander Drogin @erpthoughts

a year ago

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

0 0 1 129 0

Alexander Drogin @erpthoughts

a year ago

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?