After 10 Years, I Learned the Truth About SQL Scaling
SQL can scale way more than you think. The real limit is usually somewhere else. Continue reading on Medium » SQL can scale way more than you think. The real…
SQL CTEs (Common Table Expressions), Explained in less than 10 minutes
Part 2 of 3 in an SQL series. Previous: Joins; Next: Window Functions. Continue reading on Towards Data Engineering » Part 2 of 3 in an SQL series. Previous: Joins;…
SQL vs Python vs Excel: What Should You Learn First?
Every few weeks someone messages me with a version of the same question: “should I learn SQL, Python, or Excel first?” Usually they’ve… Continue reading on Medium » Every few…
The Only 10 SQL Optimization Prompts I Use Every Day to Write Faster Queries
Stop randomly changing SQL queries. Use these reusable prompts to investigate slow queries, understand execution plans, and make… Continue reading on AWS Tip » Stop randomly changing SQL queries. Use…
Stop paying for BI seats: build a self-updating dashboard in Google Sheets
How we turned Google Analytics into a seven-chart dashboard without a BI tool. Continue reading on Medium » How we turned Google Analytics into a seven-chart dashboard without a BI…
PostgreSQL Is More Valuable Than Most AI Startups
Every week, another startup announces that it is building the future with artificial intelligence. Some promise autonomous employees… Continue reading on Medium » Every week, another startup announces that it…
PostgreSQL Is More Valuable Than Most AI Startups
Every week, another startup announces that it is building the future with artificial intelligence. Some promise autonomous employees… Continue reading on Medium » Every week, another startup announces that it…
#96 SQL Challenge: Can You Find Employees Who Joined This Month?
Your HR manager asks you to find all employees who joined during the current month. Continue reading on Medium » Your HR manager asks you to find all employees who…
#96 SQL Challenge: Can You Find Employees Who Joined This Month?
Your HR manager asks you to find all employees who joined during the current month. Continue reading on Medium » Your HR manager asks you to find all employees who…
LIKE Found 0 Teapots in 1M Rows. Postgres Full-Text Search Found 99,614
Before you add Elasticsearch, try the search already inside Postgres. Stemming, ranking, prefix search and typos on 1M products Continue reading on Medium » Before you add Elasticsearch, try the…
LIKE Found 0 Teapots in 1M Rows. Postgres Full-Text Search Found 99,614
Before you add Elasticsearch, try the search already inside Postgres. Stemming, ranking, prefix search and typos on 1M products Continue reading on Medium » Before you add Elasticsearch, try the…
SQL : Arrêtez d’enchaîner les “OR” (et faites plutôt ça)
Si vous débutez en SQL, il y a de grandes chances que vos premières requêtes ressemblent à de longues lignes de code un peu lourdes. Continue reading on Medium »…
SQL : Arrêtez d’enchaîner les “OR” (et faites plutôt ça)
Si vous débutez en SQL, il y a de grandes chances que vos premières requêtes ressemblent à de longues lignes de code un peu lourdes. Continue reading on Medium »…
Bitemporal Data Modelling Explained- Part 1
Imagine this. Continue reading on Medium » Imagine this.Continue reading on Medium » Read More Sql on Medium #sql
The SQL Query Works. But Can Your Entire Team Trust the Metric?
The hardest part of analytics isn’t always calculating a number. It’s making sure everyone agrees on what that number means. Continue reading on Medium » The hardest part of analytics…
Using Claude to Add Postgres Indexes: 4 Reasons Postgres Ignores Your Index, Tested on 1 Million…
The index existed, the query was correct, and it still read all 1,000,000 rows. A Python float parameter turned a 0.4 ms lookup into a 54… Continue reading on Medium…
From Three Tables to a Knowledge Model: How Grilling AI Changed My Approach to Database Design
An account of how a seemingly simple PostgreSQL schema for an EdTech platform turned into an exploration of domain modeling, industry… Continue reading on Medium » An account of how…
Top 30 PostgreSQL Performance Optimization Interview Questions and Answers for 2027
Introduction Continue reading on Medium » IntroductionContinue reading on Medium » Read More Sql on Medium #sql
SQL Interview Questions for Senior Data Analysts: 20 Real Business Scenarios
Senior data analyst interviews rarely ask you to recite syntax. They hand you a messy business situation and watch how you turn it into a… Continue reading on Medium »…
Aurora Silently Ignored Our Channel-Qualified Replication Filter
The same replicate-do-db value worked on RDS for MySQL and failed quietly on Aurora. What to check before you migrate Continue reading on AWS Tip » The same replicate-do-db value…