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.
Explores new features in EF Core 10.0 for managing multiple named global query filters and selectively ignoring them.
EF Core 10.0 introduces partial updates for JSON columns using ExecuteUpdate/ExecuteUpdateAsync, with examples for SQL Server.
Explains how to use implicit and explicit database transactions with the MongoDB Entity Framework Core provider for data consistency.
PostgreSQL 19 adds direct COPY TO support for partitioned tables, improving usability and performance over the previous SELECT workaround.
A developer advises caution with Litestream 0.5.0 due to migration bugs, recommending users wait for a more stable release.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
A tutorial on building a simple MVC framework from scratch using PHP and MySQL to understand the pattern's core concepts.
Provides slides and scripts for the 'Indexing for Dummies' presentation from the dataMinds Connect 2025 tech conference.
A detailed comparison of Django ORM features across PostgreSQL, SQLite, MariaDB, MySQL, and Oracle databases, highlighting support and limitations.
