Read Committed Snapshot isolation and the Write Skew anomaly
Much has been said recently about the benefits of the Azure SQL for Business Central performance, and in particular a few articles...
top of page
Key to Good Code
DEVELOPER'S VIEW ON MICROSOFT BUSINESS CENTRAL
- Nov 13
if not IsEmpty() then DeleteAll()
My previous post on good and bad coding practices in terms of the performance touched upon one particularly contradictory coding pattern...
362 views0 comments
- Nov 10
Top 5 AL mistakes that undermine performance
This post is my shortlist of the most common beginners' mistakes in AL that affect application performance. These are not necessarily the...
1,008 views4 comments
- Nov 4
Business Central and Dataverse - User permissions.
This is the third post in a series in which I explore integration scenarios for Business Central and Dataverse, and take a dive into...
189 views0 comments
- Oct 28
Business Central and Dataverse - Synchronising Choice fields
This post continues the topic which I started in the previous text (you can read the earlier post here) - integration between Business...
401 views0 comments
- Oct 9
Business Central integration with Dataverse. What can possibly go wrong?
Integration tricks Business Central implementations where Dynamics 365 CE operates at the front end, whilst BC covers the back-end core...
520 views0 comments
- Jul 31
How scary are table extensions?
Business Central table extension object, when compiled and deployed, translates to a new SQL table with the same primary key as its base...
375 views0 comments
- Jul 13
When partial records and indexes reach synergy
Continuing performance testing of queries on extended Business Central tables, today I want to look at the same dataset from a slightly...
352 views0 comments
- Jul 6
Who benefits from partial records: The true magic of SetLoadFields
Server-side perspective One of the key characteristics of the C/AL language and its more modern ancestor, AL, that makes it so attractive...
531 views0 comments
- Jul 1
Locking Scope: Differences between LockTable and ReadIsolation
Today, once again, I am returning to the topic of table locking, lock escalation, and the way Business Central interacts with SQL Server...
471 views0 comments
bottom of page