Published onJanuary 3, 2023My 2022 Self Published Tech Book EarningsearningsrevenuebookMy 2022 Self published tech book earnings for - Site Reliability Engineering Tidbits.
Published onOctober 7, 2022StaffPlus - An Algorithm For Getting Stuff DonestaffplusEffectively 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.
Published onOctober 5, 2022Preventing Postgres SQL Race Conditions with SELECT FOR UPDATEsqlpostgresconcurrencyLearn how to prevent logical race conditions in read-modify-write SQL workloads using SELECT FOR UPDATE.
Published onSeptember 30, 2022Business Analytics - Measuring What Matters MostbusinessanalyticsrevenuetheoryLearn how revenue is the foundational anchor metric to focus on measuring.
Published onSeptember 23, 2022FIFO Queue in PythonpythonqueueFIFOLearn how to access and use FIFO queues in python.
Published onAugust 12, 2022Influencing Large Change With Little to No Authoritystaffeng+influenceSome strategies I've discovered to help influence large-scale change when you have little to no authority.
Published onJuly 8, 2022What's a Platform Team Good For? - Leverage.platformplatformingshared-componentsleverageLearn how platform teams can create leverage and increase velocity.
Published onMarch 12, 2022Professional Software - Interfacesprofessional-softwarepythondesign-patternsinterfacesLearn how to use interfaces, in python, to create extensible, maintainable, and verifiable professional software.
Published onFebruary 19, 2022I Wrote A Book On SRE! Site Reliability Engineering Tidbits!srebookA book to learn SRE concepts, for beginners.
Published onFebruary 18, 2022Professional Software - The Unreasonable Effectiveness of Napkin Math EstimationestimatesLearn how to use napkin math to estimate system load.
Published onFebruary 11, 2022Professional Software - Explicit Domain Definitionspythonprofessional-softwaredesign-patternsLearn how to create extensible professional software in python, using explicit domain definitions.
Published onDecember 18, 2021Redshift Understanding the "EXPLAIN" StatementredshiftexplaindebuggingsqlLearn how to debug sql queries using the Redshift Explain statement.
Published onDecember 17, 2021Under Commit And Over Deliver - 5 Months of Scrumscrumagilepredictable-executionLearn how to use scrum to achieve predictable execution.
Published onDecember 8, 202115 months of 24x7 Primary On-Call - Here's How I SurvivedsreoncallalertingHow to minimize alert fatigue and flaky alerts.
Published onAugust 28, 2021Python Algorithms - Implementing a FIFO Queue Using a Linked ListpythonalgorithmFIFOqueueHow to implement a FIFO queue in python.
Published onJuly 1, 2021Explicit Data Definitions For Smooth Integrationsdata-operationsschemasdata-teamsHow to use concrete data definitions to make data integrations simpler.
Published onJune 19, 2021Flow And Implementation Methodspythonprofessional-softwareabstractionssoftware-designpatternsStructure your methods into "flow" and "implementation" to increase readability and structure of your software!
Published onMay 28, 2021Schema On Read Considered HarmfuldatacontractsschemasSchema-on-ready, buy now pay later data contracts.
Published onMay 19, 2021Data Operational Maturitysredata-reliabilitymonitoringData operational maturity model to help increase reliability of data systems.
Published onMay 13, 2021Deriving Data Lineage From SQL StatementssqllineageHow to infer lineage by inspecting SQL statements.
Published onApril 9, 2021Beware of DBT Incremental Updates Against Snowflake External Tablesdbtsnowflakeexternal-tablesWatch out for dbt subqueries against snowflake external tables!
Published onMarch 31, 2021Using Views for Backwards Compatible Data Migrationsdredatabase-viewsmigrationsHow to use database views for 0 downtime migrations.
Published onMarch 9, 2021AWS Lambda - Debugging File Descriptor Exhaustion Using Goawslambdadebuggingfile-descriptorsDebug and fix file descriptor limit in AWS lambda by bounding descriptor usage.
Published onFebruary 24, 2021Toward Predictable Engineering Velocity - AccountingscrumagilepredictabilityLearn how to increase predictability through an engineering accounting system such as Scrum.
Published onFebruary 23, 2021Stay on Top of Your ETL Pipelines With Table Freshness Checksetlmonitoringfreshness-checksHow to use freshness checks to determine ETL data pipeline health.
Published onJanuary 22, 2021Golang - Detecting Resource Leaks With Baseline Testsgolanggoroutine-leaksmemory-leaksLearn how to detect resource and memory leaks in go by monitoring base memory and resource usage!
Published onJanuary 21, 2021Snowflake CSV COPY Into Examplessnowflakecsvcopy-intoLearn some common configurations of Snowflake Copy INO for CSV imports.
Published onNovember 21, 2020It's Never Been Easier To Get Started With Datadata-engineeringELTS3visualizationsLow cost storage combined with new compute driven systems makes it easier than ever to get started with data engineering.
Published onNovember 6, 2020Introduction to How External Partitions Work in Systems Like Redshift Spectrumredshifts3-partitionpartitionAthena and Specturm external partition usage and guide.
Published onOctober 23, 20202020 Summer of Sproutsgardeningfarmingsproutsdata2020 Summer of Sprouts yield results!
Published onAugust 29, 2020How Probes Partition the Debug SpacesremonitoringprobesSLOdebuggingUsing probes to make debugging faster!
Published onAugust 1, 2020Understanding & Modifying Systems - GoalssystemsgoalsLearn how to leverage "goals" to understand systems.
Published onJuly 14, 2020Do You Like Your Internal Customers? Give Them Self-Service!self-serviceplatform-teamsplatformingIncrease velocity through self-service tools!