FinserveLLC
Insights

Field notes from the intersection of software engineering and AV systems integration.

When software engineers walk into AV integration

Oct 1, 2026

The conventions of one discipline are completely foreign to the other. What software people get wrong about hardware integration — and vice versa.

Read more »

PostgreSQL as the spine of a multi-site control deployment

Sep 10, 2026

Why a schema-qualified Postgres database beats a fleet of per-site SQLite files once you have more than a handful of rooms — and what it costs.

Read more »

Migrating a VBA application without a rewrite

Aug 20, 2026

Phased migration techniques when the Access app is mission-critical and the budget for a rewrite is zero.

Read more »

Archiving SQL Server audit logs to Delta Lake

Jul 30, 2026

Audit tables grow forever and are queried almost never. Moving the history to Databricks keeps the OLTP database fast and the forensics possible.

Read more »