My Posts
Technical essays, data engineering guides, and software development walkthroughs.
-
The Value of Simple Models
the value of simple models why early atmospheric simulations 'blew up' and what it teaches us about systemic equilibrium. -
DB Basics with DuckDB and some Nuances
db basics with duckdb and some nuances an exploration of database engineering terminology gaps, the differences between etl and elt compute paradigms, and the select * query performance nuances in analytical engines like duckdb. -
The Databases that are Eating the Internet
the databases that are eating the internet an analysis of vector databases like milvus, qdrant, and pinecone, and how they manage semantic infrastructure in a resource-constrained cloud. -
The Case for Laziness in Python 3.15
the case for laziness in python 3.15 an exploration of explicit lazy imports in python 3.15 via pep 810 to optimize startup performance and parse overhead. -
Don't Be Shy About Trying New Python Features
don't be shy about trying new python features learn how to use uv to run python 3.15 and test pep 798 (unpacking in comprehensions) without global environment overhead. -
Guest Access Customizable but Guest Access Invitations for Always and Ever by Default
guest access customizable but guest access invitations for always and ever by default why guest access reviews are inadequate and how to audit sharepoint for direct guest access. -
Best Practices of JIT Access
best practices of jit access managing an entra id tenant requires removing the technical debt of permanent administrative permissions. -
Modern LAPS: Transitioning to Native Security
modern laps: transitioning to native security moving from legacy laps agents to integrated encryption and domain laps members. -
What’s in a Named Instance?
what’s in a named instance? a look into the costs, convenience, and lock-in of microsoft's named instances. -
Quantum-Resistant HTTPS: The Roadmap to Merkle Tree Certificates
quantum-resistant https: the roadmap to merkle tree certificates a look into google's cqrs, merkle tree certificates, and the future of web security in a post-quantum world. -
From Code to Context: Interpreting 21 Million Rows of CRISPR Data
from code to context: interpreting 21 million rows of crispr data in my previous post, i detailed the 'how' of unpivoting 21 million rows of genomic data using duckdb. since then, the project has matured significantly. i’ve implemented dagster for orchestration and moved the compute to a spark-on-delta lakehouse architecture. -
The New Frontier of Data Engineering: From Pipelines to Deliberation
the new frontier of data engineering: from pipelines to deliberation understanding how large language models (llms) function is heady stuff. the difficulty lies partially in the sheer velocity of the field, and partially because our metaphors haven’t yet caught up to the methodology. but this isn't just a technical shift; it's a new climate of opportunity and challenge for how we manage the flow of intelligence. -
Azure Apps: When to Proxy and When to Steer
azure apps: when to proxy and when to steer a comparison between azure front door and azure traffic manager for global traffic routing. -
Architecting a High-Performance Research Platform for CRISPR Dependency Maps
architecting a high-performance research platform for crispr dependency maps transforming a 21-million-row matrix into a normalized relational structure for a fair data environment. -
The Distributed State Trap: Why Modern Desktop Search is Failing
the distributed state trap: why modern desktop search is failing a field perspective on why desktop search, sync, and shell services collide in modern windows environments—and practical mitigations for 2026. -
Google Scholar Gets Better: What to Know About the Latest Updates
google scholar gets better: what to know about the latest updates a look at the recent improvements to google scholar and why they matter for researchers and data professionals. -
A Pragmatic Look at pg_duckdb 1.0
a pragmatic look at pg_duckdb 1.0 exploring the features and benefits of the pg_duckdb 1.0 extension for postgresql. -
Billing Anxiety vs. The Lakehouse: Is a 'Local Databricks' Actually Possible?
billing anxiety vs. the lakehouse: is a 'local databricks' actually possible? a guide to learning databricks skills without the risk of a surprise cloud bill, utilizing a local-first development strategy. -
Getting 70x Data Processing Speed with GPU vs CPU: A Performance Deep Dive
getting 70x data processing speed with gpu vs cpu: a performance deep dive discover how switching from cpu to gpu processing can dramatically accelerate your data workflows, with real-world benchmarks and implementation strategies. -
From Raw Data to Polished Insights: A Guide to the Medallion Architecture
from raw data to polished insights: a guide to the medallion architecture learn how the medallion architecture transforms raw data into polished insights through a structured, repeatable process. -
An Imperfect Model for an Imperfect Market
an imperfect model for an imperfect market a simulation-based exploration of how market forces affect housing utility and affordability. -
Interactive Housing Market Simulation
interactive housing market simulation an interactive sandbox to explore the forces of supply, demand, and investment in the housing market. -
Fact and Friction in Healthcare Data
fact and friction in healthcare data how advanced data integration in healthcare creates powerful capabilities alongside unintended friction for patients and providers. -
Taking the Small Wins: How Incremental Improvements Cut My API Call Times from 70 to 45 Minutes
taking the small wins: how incremental improvements cut my api call times from 70 to 45 minutes a post about taking the small wins: how incremental improvements cut" my api call times from 70 to 45 minutes. -
Building Data Pipelines with Dagster: Practical
building data pipelines with dagster: practical a post about building data pipelines with dagster: practical. -
Bring me the Data
bring me the data a post about bring me the data. here is an extended description to meet the minimum character requirement for summaries. -
DuckDB - Diners, Drives, and Databases Part II
duckdb - diners, drives, and databases part ii a post about duckdb - diners, drives, and databases part ii. -
DuckDB - Diners, Drives, and Databases Part I
duckdb - diners, drives, and databases part i a post about duckdb - diners, drives, and databases part i. -
Building a Real-Time NYC Subway Tracker with Python and GTFS-Realtime
building a real-time nyc subway tracker with python and gtfs-realtime learn to interface with the mta’s gtfs-realtime feeds using python to build a custom, low-latency transit arrival dashboard. -
Lemon Labor Lost: A Quest for the Perfect Cookie
lemon labor lost: a quest for the perfect cookie a post about lemon labor lost: a quest for the perfect cookie. -
Automated SQL Backups to Google Drive with Python
automated sql backups to google drive with python a post about automated sql backups to google drive with python. -
The Legend of CRISPR: Long Ago and Far Away a Young Prokaryote...
the legend of crispr: long ago and far away a young prokaryote... a post about the legend of crispr: long ago and far away a young prokaryote.... -
Brighter But Not Harmful: The 'uv' Python Installer
brighter but not harmful: the 'uv' python installer a post about brighter but not harmful: the ''uv'' python installer. -
2024 10 10 Judy The Wise
2024 10 10 judy the wise a post about 2024 10 10 judy the wise. here is an extended description to meet the minimum character requirement for summaries. -
Sometimes Selenium Works Best: Web Automation in Python
sometimes selenium works best: web automation in python a post about sometimes selenium works best: web automation in python. -
If You Have To Use Excel, Automate It: Formatting with Python
if you have to use excel, automate it: formatting with python a post about if you have to use excel, automate it: formatting with python. here is an extended description to meet the minimum character requirement for summaries. -
Identifying Microsoft Teams Storage Usage with Python and Graph API
identifying microsoft teams storage usage with python and graph api a post about identifying microsoft teams storage usage with python and graph api. here is an extended description to meet the minimum character requirement for summaries. -
XLSX are Just Text Files in a Trench Coat
xlsx are just text files in a trench coat an exploration of the xml structure behind modern excel files.
No articles found matching that search.