Database

Since v0.2.0, bcdb can load a Business Central export into a running container in seconds, without needing the schema to match first. Getting the defaults safe took locking myself out of my own admin login.

A command-line tool and .NET library that decode a BC .bak or .bacpac file directly — no SQL Server, no restore, no service tier — verified page-for-page against a real restore.

Deep dive into Business Central transaction behavior — Codeunit.Run implicit commits, CommitBehavior, TryFunction pitfalls, and TransactionType isolation

Deep dive into how AL table keys translate to SQL indexes — real query plans, SIFT views, IncludedFields, write cost benchmarks, and Database.AlterKey.

Use a SQL trigger on the NAV Object table to auto-export C/AL objects as TXT files into a Git repository inside a Docker container, giving you version

Benchmark results and SQL query analysis comparing FindSet vs FindFirst in Business Central AL — the differences are not what most developers expect.