Explores the GA release of Copilot in SQL Server Management Studio (SSMS), focusing on its code completion and chat features for SQL development.
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.
Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
A 2025 year-in-review focusing on advocacy work for database professionals, AI integration, and practical tech leadership at conferences.
Overview of official documentation, learning resources, and training materials for Microsoft SQL Server 2025.
Explores SQL Server 2025's Change Event Streaming (CES), a feature for real-time data change streaming to Azure Event Hubs.
Explains the new Optimized Locking feature in SQL Server 2025, detailing how it reduces lock memory and improves concurrency.
Analyzes performance differences between ToListAsync and ToArrayAsync in Entity Framework, concluding ToListAsync is faster.
Analyzes the lack of data replication support for Clustered Columnstore Indexes in SQL Server, covering features from 2012 to 2025.
Explains the new named global query filters feature in Entity Framework Core 10, enabling multiple, selectively disableable filters.
How to implement sortable UUID v7 GUIDs as primary keys in Entity Framework using a custom value generator.
A data professional shares her schedule and projects for PASS Data Community Summit, including keynotes, sessions, and a fun AI-powered PowerShell script.
A step-by-step guide to installing PostgreSQL 18 on Ubuntu 25.10 using the official PGDG APT repository.
