Explores change-driven architecture on Azure using Drasi to replace polling with Change Data Capture for real-time, efficient data processing.
Guide on connecting PostgreSQL to Dremio Cloud for federated queries, analytics acceleration, and building a semantic layer without data movement.
![[Video] Office Hours at Atlantis, Bahamas](https://alldevblogs.blob.core.windows.net/thumbs/article-62b73516f150-full-71f9446b.webp)
Brent Ozar answers top-voted SQL Server questions from the community in a video Q&A session recorded in the Bahamas.
Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
Analysis of corporate contributions to the latest PostgreSQL 18 release, ranking companies by commits, code changes, and number of contributors.
Explains how to display PostgreSQL timestamps with a specific timezone offset, including a custom function solution.
![[Video] Office Hours in Tokyo, Japan](https://alldevblogs.blob.core.windows.net/thumbs/article-14278cd3a80f-full-1eb1b061.webp)
Brent Ozar answers SQL Server, Azure SQL, and database management questions from viewers during an informal 'Office Hours' session in Tokyo.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
A developer recounts debugging a PostgreSQL container stability issue that turned out to be a hidden security vulnerability, sharing lessons learned.
A developer creates a simple, AI-assisted Node.js tool for automatically loading CSV files into PostgreSQL with minimal configuration.
Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
A technical analysis measuring the performance impact of adding indexes on write operations (COPY) in PostgreSQL, showing slowdowns and size overhead.
PostgreSQL 19 introduces new ALTER TABLE commands to MERGE and SPLIT partitions, with initial single-process, locked implementations.
Analysis of a complex RCE attack chain in PostHog exploiting SSRF, a ClickHouse SQL 0day, and default PostgreSQL credentials.
A guide for new DBAs on managing PostgreSQL extensions, covering installation, version checking, and essential maintenance practices.
A technical analysis comparing PostgreSQL JSON storage options, compression methods (pglz vs. lz4), and performance optimizations.
A fun exploration of psql's scripting capabilities, testing if it's Turing complete by implementing a Fibonacci sequence calculator.
Compares PostgreSQL's pg_stat_wal metrics to Oracle's detailed redo logging instrumentation for database administrators.
A guide to implementing UUIDv7 in Python, Django, and PostgreSQL for better database performance and ordered identifiers.
Explains new PostgreSQL 19 features for synchronizing sequences via logical replication, including ALL SEQUENCES support and a sync worker.
