Guide to creating Azure HorizonDB clusters, compute scaling, graph DB, and AI pipelines in Microsoft's new PostgreSQL-based data platform.
A blog post listing database job opportunities for June 2026, with rules for employers to post positions and links to related hiring posts.
Solutions to SQLAlchemy 2 exercises covering database queries, relationships, and async features.
A developer explains how Claude Code convinced them to simplify SQL JOINs by moving filters from ON to WHERE clauses for better readability.
Explains how to simplify ANTI JOIN queries using jOOQ syntax and implicit join paths.
Explores nine key design tradeoffs in query engines like PostgreSQL, ClickHouse, and DuckDB, covering storage, indexing, execution, and concurrency.
Interview with Branimir Lambov, a Cassandra committer at IBM, discussing his work on Trie in LSM Tree and compaction strategies.
Building a web traffic analytics solution with SQLAlchemy 2, covering blog articles and authors database models.
Advanced many-to-many relationships in SQLAlchemy 2, covering join tables with extra columns and order management.
Tutorial on implementing many-to-many relationships in SQLAlchemy 2, using products and countries as an example.
Explores the GA release of Copilot in SQL Server Management Studio (SSMS), focusing on its code completion and chat features for SQL development.
EF Core 11.0 introduces a single command to create and apply migrations, streamlining development workflow.
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.
Announcing a beginner-friendly webinar series on SQL Server indexing concepts, starting with clustered indexes.
Author introduces his book 'SQLAlchemy 2 In Practice', sharing the preface and outlining chapters on the popular Python ORM.
Monthly job board for database professionals, featuring direct hiring posts from companies for February 2026 roles.
Explains how to display PostgreSQL timestamps with a specific timezone offset, including a custom function solution.
Microsoft re-released SQL Server 2022 Cumulative Update 23 (CU23) with fixes, including a security update, and discusses patching strategies.
A developer recounts debugging a PostgreSQL container stability issue that turned out to be a hidden security vulnerability, sharing lessons learned.
