Latest DevOps news from Tech News
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Use the pattern PostgreSQL alrea…
A hospital database rarely stores every useful detail in one table. Patient details may be stored separately from visit records. Doctor, department,…
This is a submission for the Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle What I Built CreatorDesk is a self-hosted, open-source tool…
Reading the CVSS 9.8 score of CVE-2026-108474 without overreading it Vulnerability overview CVE-2026-108474 carries a CVSS v3 score of 9.8 and is cl…
What if you could build complete, production-grade ETL pipelines in Pure SQL… without Jinja templates, without a database server, and without heavy…
Window functions are the most common SQL topic in data engineering interviews, and most candidates know the syntax. The follow-up questions are wher…
Stored Procedures A deep-dive walkthrough of stored procedures — covering parameters and output parameters, plan caching and recompilation specific…
If a unique index suddenly tolerates duplicates, or WHERE email = ... misses a row that a sequential scan finds, the index is sorted by collation ru…
In this article I'll show you how a dbt incremental model that looked perfectly reasonable wiped out three months of finance data, why none of our c…
Tables, indexes, constraints, sequences, partitions and rows, in one go. 1. Overview SqlJam : Move tables across databases. Schema, data and all. A…
You connect an AI agent to your shop's database and ask a simple question: "How many active customers do we have?" The agent looks at the tables: cu…
LIMIT 20 OFFSET ... makes the next page of a list easy to express. But deeper pages require skipping more rows without returning them. Using an inde…
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Pick the action by what the chil…
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Grant CONNECT on the database an…
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: On PostgreSQL 11 and later, ADD…
Execution Plans (SQL Server) A deep-dive walkthrough of SQL Server execution plans — covering estimated vs. actual plans and why the gap between the…
This should have been the first post of this series. A few months ago, I demonstrated ( video ) what I see as one of the key advantages of a documen…
Sometimes one query needs the result of another query to work. SQL gives you two main tools for that: subqueries and CTEs (Common Table Expressions)…
Have you ever had this experience: revising the prompt for an AI SQL tool through five or six versions, clicking Undo and rewriting countless times,…
Snowflake recently made the PERIOD generally available. I saw it in the release notes and wondered what it would change in a model that already has…
Have you ever felt like your health data is trapped in a "walled garden"? Between Apple Health on your iPhone and Google Fit on your secondary Andro…
Every business application has this screen somewhere: a table of records, filter boxes above it, and a user who may only see part of the data. The f…
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: A polymorphic association stores…
Your SQL can be perfectly reproducible while your business meaning is not. Suppose a user asks: What was revenue in Q1? Your data agent resolves Rev…
Enabling data checksums is strongly recommended to detect corruption originating in the storage or I/O layer, which can silently lead to incorrect q…
1. Overview & Core Concepts Definition: A pseudo-column behaves like a table column, but it is not actually stored on disk in the table. Capabil…
Your text-to-SQL agent has a failure mode that logs nothing, alerts nothing, and returns a confidently wrong answer. I finally put a number on how o…
Some SQL problems look simple until you read the rules twice. This one is tagged Apple and rated hard, and it teaches a useful pattern: grouping the…
Introduction A student project can work perfectly with friendly input and still be dangerously vulnerable when user input is concatenated directly i…
This project teaches four of PostgreSQL's most powerful features by building something no sane person would ship: extensions — how you add new capab…