corpus.blog
41554 blogs · [ { "id": "01a087b9-3bc1-73e7-9814-8ea09a6ead98", "title": "Draining the Data Lake (part 1 of 3) - Problems", "url": "https://on-systems.tech/blog/135-draining-the-data-swamp", "published_at": "2023-11-17T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-2178633327fc", "title": "Calculating Monthly Active Users (MAU)", "url": "https://on-systems.tech/blog/136-how-to-calculate-mau", "published_at": "2023-11-15T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217863408a41", "title": "Effective Technical Writing - Mediums", "url": "https://on-systems.tech/blog/134-effective-technical-writing-medium", "published_at": "2023-02-26T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217864266ae0", "title": "Effective Technical Writing - Target Audience", "url": "https://on-systems.tech/blog/132-effective-technical-writing-target-audience", "published_at": "2023-02-18T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217864a513e1", "title": "Effective Technical Writing - Purpose", "url": "https://on-systems.tech/blog/131-effective-technical-writing-purpose", "published_at": "2023-02-15T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786562f245", "title": "My 2022 Self Published Tech Book Earnings", "url": "https://on-systems.tech/blog/130-2022-self-published-book-earnings", "published_at": "2023-01-04T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-2178661b8434", "title": "StaffPlus - An Algorithm For Getting Stuff Done", "url": "https://on-systems.tech/blog/129-staffplus-an-algorithm-for-getting-stuff-done", "published_at": "2022-10-08T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217866a7f0c8", "title": "Preventing Postgres SQL Race Conditions with SELECT FOR UPDATE", "url": "https://on-systems.tech/blog/128-preventing-read-committed-sql-concurrency-errors", "published_at": "2022-10-06T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217867643d39", "title": "Business Analytics - Measuring What Matters Most", "url": "https://on-systems.tech/blog/127-business-analytics-starting-with-what-matters", "published_at": "2022-10-01T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217868514f0b", "title": "FIFO Queue in Python", "url": "https://on-systems.tech/blog/126-fifo-queue-in-python", "published_at": "2022-09-24T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217868ef086b", "title": "Influencing Large Change With Little to No Authority", "url": "https://on-systems.tech/blog/125-influencing-without-authority", "published_at": "2022-08-13T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217869dffb3b", "title": "What's a Platform Team Good For? - Leverage.", "url": "https://on-systems.tech/blog/124-platform-leverage", "published_at": "2022-07-09T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786a5fb77e", "title": "Professional Software - Interfaces", "url": "https://on-systems.tech/blog/interfaces", "published_at": "2022-03-13T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786a6a1663", "title": "I Wrote A Book On SRE! Site Reliability Engineering Tidbits!", "url": "https://on-systems.tech/blog/123-sre-tidbits", "published_at": "2022-02-20T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786a8ee57e", "title": "Professional Software - The Unreasonable Effectiveness of Napkin Math Estimation", "url": "https://on-systems.tech/blog/good-enough-estimations-napkin-math", "published_at": "2022-02-19T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786b153c7f", "title": "Professional Software - Explicit Domain Definitions", "url": "https://on-systems.tech/blog/explicit-domain-definitions", "published_at": "2022-02-12T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786baa5e62", "title": "Redshift Understanding the \"EXPLAIN\" Statement", "url": "https://on-systems.tech/blog/122-redshift-understanding-explain", "published_at": "2021-12-19T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786bd173c0", "title": "Under Commit And Over Deliver - 5 Months of Scrum", "url": "https://on-systems.tech/blog/121-under-commit-and-over-deliver", "published_at": "2021-12-18T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786c5399c0", "title": "15 months of 24x7 Primary On-Call - Here's How I Survived", "url": "https://on-systems.tech/blog/120-15-months-of-oncall", "published_at": "2021-12-09T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786d200bde", "title": "Python Algorithms - Implementing a FIFO Queue Using a Linked List", "url": "https://on-systems.tech/blog/119-python-algorithms-fifo-queue-linked-list", "published_at": "2021-08-29T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786da3d7db", "title": "Explicit Data Definitions For Smooth Integrations", "url": "https://on-systems.tech/blog/118-explicit-data-definitions-for-smooth-integrations", "published_at": "2021-07-02T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786de72344", "title": "Flow And Implementation Methods", "url": "https://on-systems.tech/blog/117-flow-and-implementation-methods", "published_at": "2021-06-20T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786e234ab1", "title": "Schema On Read Considered Harmful", "url": "https://on-systems.tech/blog/116-schema-on-read-considered-harmful", "published_at": "2021-05-29T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786f1e56b7", "title": "Data Operational Maturity", "url": "https://on-systems.tech/blog/115-data-operational-maturity", "published_at": "2021-05-20T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786f3a37a9", "title": "Deriving Data Lineage From SQL Statements", "url": "https://on-systems.tech/blog/114-deriving-data-lineage-from-sql-statements", "published_at": "2021-05-14T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786f772641", "title": "Beware of DBT Incremental Updates Against Snowflake External Tables", "url": "https://on-systems.tech/blog/113-beware-dbt-incremental-updates-against-snowflake-external-tables", "published_at": "2021-04-10T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786f7de861", "title": "Using Views for Backwards Compatible Data Migrations", "url": "https://on-systems.tech/blog/111-views-for-clean-table-migrations", "published_at": "2021-04-01T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786fcb1af4", "title": "AWS Lambda - Debugging File Descriptor Exhaustion Using Go", "url": "https://on-systems.tech/blog/110-lambda-debugging-file-descriptor-exhaustion-in-go", "published_at": "2021-03-10T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21786fd05942", "title": "Toward Predictable Engineering Velocity - Accounting", "url": "https://on-systems.tech/blog/109-toward-predictable-engineering-velocity-accounting", "published_at": "2021-02-25T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-21787027280e", "title": "Stay on Top of Your ETL Pipelines With Table Freshness Checks", "url": "https://on-systems.tech/blog/108-db-table-freshness-checks", "published_at": "2021-02-24T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-2178710d3af8", "title": "Golang - Detecting Resource Leaks With Baseline Tests", "url": "https://on-systems.tech/blog/106-go-detecting-resource-leaks-with-baseline-tests", "published_at": "2021-01-23T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217871237320", "title": "Snowflake CSV COPY Into Examples", "url": "https://on-systems.tech/blog/105-snowflake-copy-into-csv-examples", "published_at": "2021-01-22T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217871e774bb", "title": "It's Never Been Easier To Get Started With Data", "url": "https://on-systems.tech/blog/104-its-never-been-easier-to-get-started-with-data", "published_at": "2020-11-22T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-2178723fd312", "title": "Introduction to How External Partitions Work in Systems Like Redshift Spectrum", "url": "https://on-systems.tech/blog/103-how-external-partitions-work", "published_at": "2020-11-07T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217872b6fb6d", "title": "2020 Summer of Sprouts", "url": "https://on-systems.tech/blog/102-2020-summer-of-sprouts", "published_at": "2020-10-24T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-2178730d5532", "title": "How Probes Partition the Debug Space", "url": "https://on-systems.tech/blog/101-probes-partition-the-debug-space", "published_at": "2020-08-30T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-2178738179ac", "title": "Understanding & Modifying Systems - Goals", "url": "https://on-systems.tech/blog/system-goals", "published_at": "2020-08-02T00:00:00+00:00" }, { "id": "01a087b9-3bc2-7157-8080-217873a3698f", "title": "Do You Like Your Internal Customers? Give Them Self-Service!", "url": "https://on-systems.tech/blog/100-self-service-foundation-for-speed", "published_at": "2020-07-15T00:00:00+00:00" } ] posts Claim your blog
Back to Systems and Tech Thoughts
Blog · corpus.blog/blogs/on-systems.tech/posts

Systems and Tech Thoughts

on-systems.tech

2023

Draining the Data Lake (part 1 of 3) - Problemsoriginal ↗
17 Nov 2023
Calculating Monthly Active Users (MAU)original ↗
15 Nov 2023
Effective Technical Writing - Mediumsoriginal ↗
26 Feb 2023
Effective Technical Writing - Target Audienceoriginal ↗
18 Feb 2023
Effective Technical Writing - Purposeoriginal ↗
15 Feb 2023
My 2022 Self Published Tech Book Earningsoriginal ↗
4 Jan 2023

2022

StaffPlus - An Algorithm For Getting Stuff Doneoriginal ↗
8 Oct 2022
Preventing Postgres SQL Race Conditions with SELECT FOR UPDATEoriginal ↗
6 Oct 2022
Business Analytics - Measuring What Matters Mostoriginal ↗
1 Oct 2022
FIFO Queue in Pythonoriginal ↗
24 Sept 2022
Influencing Large Change With Little to No Authorityoriginal ↗
13 Aug 2022
What's a Platform Team Good For? - Leverage.original ↗
9 Jul 2022
Professional Software - Interfacesoriginal ↗
13 Mar 2022
I Wrote A Book On SRE! Site Reliability Engineering Tidbits!original ↗
20 Feb 2022
Professional Software - The Unreasonable Effectiveness of Napkin Math Estimationoriginal ↗
19 Feb 2022
Professional Software - Explicit Domain Definitionsoriginal ↗
12 Feb 2022

2021

Redshift Understanding the "EXPLAIN" Statementoriginal ↗
19 Dec 2021
Under Commit And Over Deliver - 5 Months of Scrumoriginal ↗
18 Dec 2021
15 months of 24x7 Primary On-Call - Here's How I Survivedoriginal ↗
9 Dec 2021
Python Algorithms - Implementing a FIFO Queue Using a Linked Listoriginal ↗
29 Aug 2021
Explicit Data Definitions For Smooth Integrationsoriginal ↗
2 Jul 2021
Flow And Implementation Methodsoriginal ↗
20 Jun 2021
Schema On Read Considered Harmfuloriginal ↗
29 May 2021
Data Operational Maturityoriginal ↗
20 May 2021
Deriving Data Lineage From SQL Statementsoriginal ↗
14 May 2021
Beware of DBT Incremental Updates Against Snowflake External Tablesoriginal ↗
10 Apr 2021
Using Views for Backwards Compatible Data Migrationsoriginal ↗
1 Apr 2021
AWS Lambda - Debugging File Descriptor Exhaustion Using Gooriginal ↗
10 Mar 2021
Toward Predictable Engineering Velocity - Accountingoriginal ↗
25 Feb 2021
Stay on Top of Your ETL Pipelines With Table Freshness Checksoriginal ↗
24 Feb 2021
Golang - Detecting Resource Leaks With Baseline Testsoriginal ↗
23 Jan 2021
Snowflake CSV COPY Into Examplesoriginal ↗
22 Jan 2021

2020

It's Never Been Easier To Get Started With Dataoriginal ↗
22 Nov 2020
Introduction to How External Partitions Work in Systems Like Redshift Spectrumoriginal ↗
7 Nov 2020
2020 Summer of Sproutsoriginal ↗
24 Oct 2020
How Probes Partition the Debug Spaceoriginal ↗
30 Aug 2020
Understanding & Modifying Systems - Goalsoriginal ↗
2 Aug 2020
Do You Like Your Internal Customers? Give Them Self-Service!original ↗
15 Jul 2020