PostgreSQL psql Meta Commands: Tables

PostgreSQL psql Meta Commands: Databases

I Struggle

This one is going to involve a lot of honesty & self-reflection. Run now. You've been warned. I know for a fact that I'm blessed. I'm healthy. I have a loving family. There are friends out there happy to see me when we meet. I've got one of the single greatest jobs ever. I live […]

The DBA is Dead! Long Live the !

I'm sure I've never mentioned this before, but I'm a little aged. I'm not real far from 40 years in IT, and I got started a little late in life. Regardless, I've heard this tale of woe before. And no, this isn't going to be a rehash of all the old stories ("self-tuning" SQL Server […]

It's Never Just One Thing

I was reading about a recent security failure when I saw the phrase "...a series of missed opportunities...". Made me giggle and say to myself "No Kidding Kojak" except I used Sherlock Holmes and a different word. Fact is, security failures, and hey, let's face it, process failures, almost never come down to a single […]

Let's Talk Certifications

In just over a week, I'm going to be in Valencia, Spain, for pgConf.eu. While there, I'm planning to take the first certification to come out of the Open Alliance for PostgreSQL Education. I'm more than a little nervous because I'm not sure I'm ready. However, I've been studying and reading, watching videos, practicing my […]

Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7

This final level focuses on the practical application of changesets in complex scenarios. From table transformations to ETL-driven logic, it explores how to manage database changes when rollback is no longer purely structural, emphasizing control, predictability, and pragmatic solutions.

Take the 2027 State of the Database Landscape Survey

Share your view on the database landscape and you could win USD$500.

Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix

Reproduce traditional row-lock accumulation and writer blocking, then see how SQL Server 2025 uses transaction ID locking and Lock After Qualification to improve concurrency—and where hints, isolation levels, and query shapes limit the benefit.

JSON indexing in SQL Server 2025: how it works and current limitations

This guide has everything you need to know about JSON indexing in SQL Server 2025: what it is, how it works, and current limitations.