When troubleshooting query behavior, connection sizing, or general node health, it can be useful to answer a few simple questions: ● How […]
Read More
Cleaner Conditional Aggregates in YugabyteDB with PostgreSQL’s FILTER Clause
Sometimes a simple SQL feature can make reporting queries much easier to read. One of my favorite examples is PostgreSQL’s FILTER clause […]
Read MoreExpanding Pure SQL Table DDL Export in YugabyteDB: Indexes, Constraints, Triggers, and Partitions
In a previous YugabyteDB Tip, we built a pure SQL function to export a table’s CREATE TABLE DDL directly from YugabyteDB system […]
Read MoreHow to Protect Your Database from Accidental DROP DATABASE
🚨 The Problem Today a customer asked a great (and very real) question: “What if a DBA accidentally runs DROP DATABASE on […]
Read More