Topic
Performance & Data
Databases, telemetry, ingestion and the measurements behind a system that is actually faster.
Decision APIs: Derive the Threshold From the Cost of Each Error
A probability is not an action. Derive automation and review thresholds from error costs, model imperfect reviewers, rank a scarce queue and check what calibration must hold.
What a Decision Probability Actually Computes: Logits to Labels
The same {"department":"technical"} can come from generation, a classifier or label scoring. Work through softmax, candidate sets, multi-token labels and schema masks to see what 0.88 means.
Fast Responses, Old Inventory: Freshness from Source Event to Blazor
A 304 can be correct and still show the world before the delivery. Separate source, accepted and published versions, order the HTTP checks, and measure age as an interval at the screen.
Hash Aggregate Spills: Read the Memory Grant Before Tuning It
A SQL Server 2025 hash aggregate spills despite an overestimate. Six measured fixes show why a better estimate made it worse and which change removed the spill.
A Read-Only SQL Agent Must Survive a Forbidden Command
Build a SQL Server diagnostic tool that stays read-only when the model misbehaves: a fixed tool catalogue, a narrow principal, a pinned tenant and real cost limits.
Trace an Agent SQL Tool from Its Request to the Rows Read
Five Index Seeks return the same 1,000 rows and three read 5,000. Follow an agent tool's parameter into the actual plan, read the right counters and attach the query to the answer.
A SQL Diagnostic Is a Product: Version the Query, Schema and Rule
A stale-statistics check can fail green: absent fields read as zero, filtered statistics and the wrong target. Version the collector, schema and rule, and make Unknown useful.
Vector Search Under Pressure: Distance, Candidates and Index Updates
When a relevant document is missing, the metric is rarely at fault. Measure what post-filtering, candidate budgets and stale index membership do, on SQL Server 2025 and in C#.
Restartable .NET Ingestion: Stage Chunks, Publish Complete Revisions
Keep a half-imported revision out of search: chunk by structure, key embeddings by content, stage in SQL Server 2025 and publish a whole revision by moving one pointer.
A recovery runbook should refuse the wrong next step
A SQL Server restore that verifies, opens and answers queries can still be the wrong database, miss a committed write or load the wrong file. Make each check permit exactly one next step.
A Verified SQL Backup Is Not Yet a Recovered Application
VERIFYONLY passed, CHECKDB was clean and the invoice service still failed. A SQL Server recovery drill that checks history, logins, TDE keys and the real operation.
Database Cutover: Fence the Old Writer Before You Move the Endpoint
A client timeout, a stale connection and a green probe can still split your history. Reconcile by operation key, fence the old writer inside the database, then route.