BLOG | Key to Good Code

Feb 22

Buffered inserts and deadlocks

Feb 6

Filtering on FlowFields

Dec 21, 2024

Table indexes and inserts

Nov 24, 2024

Temporary tables in procedure parameters

Nov 10, 2024

Another alternative to SIFT: Columnstore indexes

Oct 28, 2024

Hidden SQL queries in AL you (probably) want to avoid

Oct 22, 2024

if not IsEmpty then FindSet... again

Oct 20, 2024

Covering indexes as an alternative to SIFT

Aug 25, 2024

if not IsEmpty then FindSet... Or not?

Aug 9, 2024

The dark side of SumIndexFields. Concurrency.

Aug 5, 2024

SIFT

Jun 30, 2024

Navision legacy in AL: RecordLevelLocking

Jun 20, 2024

Select with partially matching index: can we make it faster?

Jun 9, 2024

Lock timeouts and deadlocks

Jun 2, 2024

Configuring an Azure Health check endpoint protected with OAuth2

Mar 16, 2024

Destructive Master Data Management

Jan 8, 2024

The case of a missing newline character. One almost detective story.

Nov 26, 2023

Read Committed Snapshot isolation and the Write Skew anomaly

Nov 14, 2023

if not IsEmpty() then DeleteAll()

Nov 10, 2023