A Traceable Path from Ingestion to Insight
Every transformation in a reference data pipeline should be explainable from an input artifact to a derived result.
THE AUTHOR
Marcin Borecki
Developer, entrepreneur and business angel. Writing about AI, software, data and the evidence behind technical decisions.
About the author →THE READING ROOM
Writing & investigations.
Hash Aggregates, Parallel Plans and Memory Grants: Read the Spill Before Tuning It
Four actual SQL hash-aggregate plans expose grants, parallelism and spills while preserving one independently checked result.
A Blog That Can Explain Its Sources
An expert blog asks readers to trust more than its sentences. It asks them to trust the author's selection of evidence, interpretation of that evidence and willingness to correct a mistake.
A SQL Diagnostic Script as a Versioned Product
A versioned evaluator replays actual SQL observations, preserves source hashes and refuses unsupported or incomplete evidence. A diagnostic status is a contract, not a universal health verdict.
Result Freshness: From Source Event to the Screen
A versioned HTTP fixture and Blazor UI distinguish source, ingest, publication and display, refusing late updates while keeping logical age separate from query latency.
What Survives When the Model Becomes a Commodity?
Differentiation should be tested against substitution in models, distribution, data access and workflow ownership.
Semantic Search in Blazor WebAssembly: Where the Cost Moves
Actual query embeddings run in ONNX Runtime Web inside a Blazor WebAssembly app, with verified tokenizer parity, real browser results and explicit first-use asset costs.
Learning to Disagree with an Apparently Helpful Machine
Disagreement becomes useful when it produces a testable alternative. Treat fluent assistance as a proposal whose assumptions can be challenged.
A Database Endpoint Switch Is Not the First Correct Operation
A controlled two-instance cutover distinguishes endpoint selection from a verified new operation, including a committed write whose acknowledgement timed out.
Permission Changed Mid-Answer: Identity, Evidence and Telemetry Boundaries
Controlled HTTP streaming tests show what happens when access or resource version changes after retrieval but before protected content is emitted.
Small Buffers, Large Files: An Azure Blob Transfer Lab
Throughput gains must be evaluated alongside memory, concurrency, retries and integrity.
The Hidden Network Work of a Blazor Component
An executed Blazor component separates debounce admission, aborted client waits and revision authority, with controlled HTTP completion and visible stale-response checks.