All Posts

Effectively executing staff plus level initiatives requires a combination of technical skills, product management vision, project management, execution, and business analytics. Learn how these skills combine to execute on initiatives successfully.

Learn how to prevent logical race conditions in read-modify-write SQL workloads using SELECT FOR UPDATE.

Learn how revenue is the foundational anchor metric to focus on measuring.

Learn how to access and use FIFO queues in python.

Some strategies I've discovered to help influence large-scale change when you have little to no authority.

Learn how platform teams can create leverage and increase velocity.

Learn how to use interfaces, in python, to create extensible, maintainable, and verifiable professional software.

A book to learn SRE concepts, for beginners.

Learn how to use napkin math to estimate system load.

Learn how to create extensible professional software in python, using explicit domain definitions.

Learn how to debug sql queries using the Redshift Explain statement.

Learn how to use scrum to achieve predictable execution.

How to minimize alert fatigue and flaky alerts.

How to implement a FIFO queue in python.

How to use concrete data definitions to make data integrations simpler.

Structure your methods into "flow" and "implementation" to increase readability and structure of your software!

Schema-on-ready, buy now pay later data contracts.

Data operational maturity model to help increase reliability of data systems.

How to infer lineage by inspecting SQL statements.

Watch out for dbt subqueries against snowflake external tables!

How to use database views for 0 downtime migrations.

Debug and fix file descriptor limit in AWS lambda by bounding descriptor usage.

Learn how to increase predictability through an engineering accounting system such as Scrum.

How to use freshness checks to determine ETL data pipeline health.

Learn how to detect resource and memory leaks in go by monitoring base memory and resource usage!

Learn some common configurations of Snowflake Copy INO for CSV imports.

Low cost storage combined with new compute driven systems makes it easier than ever to get started with data engineering.

Athena and Specturm external partition usage and guide.

2020 Summer of Sprouts yield results!

Using probes to make debugging faster!

Learn how to leverage "goals" to understand systems.

Increase velocity through self-service tools!