A technical guide on implementing the Saga pattern in .NET using Wolverine, covering setup, message routing, and saga state persistence.
A developer builds a Django-powered site to host 20,000 photos, exploring the intersection of photography, coding, and tool-building philosophy.
Explores using non-ACID storage (csv_tam) as a workaround for missing autonomous transactions in PostgreSQL, balancing performance and crash safety.
Overview of multi-tenancy features in the Critter Stack (.NET ecosystem), covering Marten, Wolverine, and Polecat tools.
Guide to using pgvector in .NET for vector search with PostgreSQL, embeddings, and semantic similarity queries.
PostgreSQL 19 introduces the REPACK command, merging VACUUM FULL and CLUSTER functionality to combat table bloat.
PostgreSQL 19 will allow excluding specific tables from logical replication publications using the new EXCEPT TABLE syntax.
PostgreSQL 19 adds non-text output formats to pg_dumpall, enabling parallel restore and selective database restoration from cluster-wide backups.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to test production query plans without moving large datasets.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to replicate production query plans in dev environments.
A retrospective on the Marten .NET library's growth over five years, covering adoption drivers like commercial support and documentation improvements.
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.
