Tag: Development

IsEmpty + FindSet or just FindSet?

A few days ago, I got pointed to this question on LinkedIn: https://www.linkedin.com/posts/alexander-drogin-0635422b_hey-business-central-developers-im-looking-activity-7231695259485839362-n670?utm_source=share&utm_medium=member_desktop Or in other words:  Is it a good practice to first test of a set is empty, to then get the set of records? I had a few thoughts:First, I was like: duh.  Stupid question.  2 SQL roundtrips in stead of 1 …

Continue reading

Permanent link to this article: https://www.waldo.be/2024/08/23/isempty-findset-or-just-findset/

Cleaning up Media Orphans with the Data Administration tool in Business Central

Did you ever wonder how to delete Media Orphans in Business Central? Even more – did you know that Media Orphans are a real thing – and can consume a great deal of your database capacity?  It is a thing – and you should be aware! Well – here’s a story that made me dive …

Continue reading

Permanent link to this article: https://www.waldo.be/2024/07/12/cleaning-up-media-orphans-with-the-data-administration-tool-in-business-central/

Handling Business Central Telemetry like a boss: my Azure Data Explorer dashboard

You might have seen it, you might haven even been there – but in any case: this year, at BCTechDays, I did a session about “Telemetry”.  And since BCTechDays posts its sessions online (how unique is that!), you can watch the session here: This post is NOT about the session, so I invite you to …

Continue reading

Permanent link to this article: https://www.waldo.be/2024/06/28/handling-business-central-telemetry-like-a-boss-my-azure-data-explorer-dashboard/

Days of Knowledge & BCTechDays coming up soon!

I recently realized I forgot to share the amazing conferences happening right now: the “Days of Knowledge” series and BC TechDays. 🤩 I’m a bit ashamed because it’s always such an honor to be part of these events, and the least I can do is help spread the word. But hey, it’s not too late …

Continue reading

Permanent link to this article: https://www.waldo.be/2024/05/22/days-of-knowledge-bctechdays-coming-up-soon/

“Generic Charts”.  Forgotten, but not gone …

Do you remember “Generic Charts”?  No?  Don’t worry – I didn’t either. 🤪 Back in the days … For years, we didn’t really pay attention to this feature, but “back in the days”, it was actually quite a nifty thing, where you could easily create a chart based on data of business central, save it …

Continue reading

Permanent link to this article: https://www.waldo.be/2024/04/30/generic-charts-forgotten-but-not-gone/

Rec.LockTable – Good Practice?  Or Bad Practice?

Sometimes, “best practices” turn into “bad practices”.  And recently, with one of the best new features of Business Central that just fell in our laps (most users probably won’t realize), one good practice became not just unnecessary .. but even a bad practice. When I asked CentralQ.  I got a lot of truth, but also …

Continue reading

Permanent link to this article: https://www.waldo.be/2024/03/28/rec-locktable-good-practice-or-bad-practice/

Speed up your automated tests without really doing anything..

Here’s a Christmas present from me for you: a short, but may be fore some people a very liberating post on how to speed up your tests in your pipeline, without doing anything “real” ;-). The problem We have made “tests” mandatory in our company.  What that means: every single pullrequest is being code reviewed, …

Continue reading

Permanent link to this article: https://www.waldo.be/2023/12/28/speed-up-your-automated-tests-without-really-doing-anything/

Business Central vNext (v23) – The “new data model”

This is just going to be a brief post, because there have been other blogs about this topic – I just wanted to add a small piece on top of it ;-). Our two Italian friends Stefano and Duilio already wrote some blogs about the upcoming performance improvements regarding the new feature in Business Central, …

Continue reading

Permanent link to this article: https://www.waldo.be/2023/09/22/business-central-vnext-v23-the-new-data-model/

Analyzing Deadlocks in Business Central with Telemetry

Not too long ago, I was (and still am) challenged with analyzing deadlocks at a specific customer.  And in all honesty – that was not easy, because, you know, deadlocks is something on SQL – and it’s not like we have a lot of access to SQL tools. What are deadlocks? I’m not going to …

Continue reading

Permanent link to this article: https://www.waldo.be/2023/08/31/analyzing-deadlocks-in-business-central-with-telemetry/

Analyze (the lack of) Partial Records with Business Central Telemetry

I’ve been working with Business Central Telemetry a lot the last coulple of months, having to deal with deadlocks and such. And while doing so, quite some new ideas came to mind that I’d like to investigate by means of Telemetry. But first, a disclaimer I’m absolutly not an expert. Probably there are better ways …

Continue reading

Permanent link to this article: https://www.waldo.be/2023/05/15/analyze-the-lack-of-partial-records-with-business-central-telemetry/