Security Data Works

Writing

Essays from a practitioner.

These essays are the reasoning behind the Capability Matrix scores, and the head-to-head benchmark evidence they cite lives in the Lab.

The architecture itself, component by component, is the MOAR Stack, where each piece carries its entry essay, depth, and the evidence underneath it. This page is the full catalog, organized by pillar. The pillars are ordered as the dependency stack: the foundations (lakehouse formats, catalogs) up through OCSF and Sigma standards, engines and pipelines that sit on top of them, the detection and migration practices that consume them, and finally the economics and vendor-watch layer that frames the whole.

Reading paths

If you read three, read these.

The full essay collection is a lot to land on cold. Each path is a three-essay arc through one question, cross-pillar, in order.

Leaving Splunk without breaking detections

The cost case, the migration trap most teams walk into, and what the timeline actually costs.

  1. 1The cost math: schema-on-read vs schema-on-write
  2. 2The field-mapping anti-pattern
  3. 3Hidden costs and timeline reality

Whether you can trust your data

The quietest failures in security data — the parsing layer, and the measurement problem underneath it.

  1. 1The parsing layer nobody owns
  2. 2Flattening away your detection logic
  3. 3Why vendor benchmarks are the only benchmarks

Picking the query engine

Where each engine wins, from petabyte-scale detection down to an analyst's laptop.

  1. 1ClickHouse at petabyte scale
  2. 2DuckDB for analyst-driven hunting
  3. 3Push vs pull query engines

When hunting becomes data science

The path threat hunters are already on, made reproducible.

  1. 1PEAK and the lakehouse
  2. 2MLOps tools for threat hunters
  3. 3Where detection-as-code notebooks should live

Browse by pillar

The full catalog, one pillar at a time.

12 essays

Lakehouse foundations.

Open table formats and the interop layer beneath them. Iceberg, Delta, V3/V4 features, and the Arrow standards that make engine portability real.

Open the Lakehouse foundations pillar in depth order → · Depth tier for ch5 (Performant) and ch2 (MOAR assembled)

Notifications

Get a note when a new essay or benchmark publishes.

Low-volume. Essays as they ship; quarterly benchmark reports; nothing else. No drip campaigns.

The hypothesis-grounded work (ten anchor hypotheses with evidence tiers, twenty-six contradictions tracked over time, and the method-in-practice essay) lives on the research page. The program POV that connects them is on thesis.