PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
EF Core 10.0 adds support for the new JSON data type in Microsoft SQL Server 2025, enabling querying and storage of JSON documents.
Announcement of updated tdbf packages for Delphi 13, an open-source library for accessing DBase tables.
Explores how PostgreSQL and its extensions can replace many modern tech stack components like Redis, Elasticsearch, and Kafka, simplifying architecture.
Learn how to use DTrace to monitor and inspect live SQL queries, including their arguments, from a running Go application without code changes.
Announcing two free online tech sessions: building a low-cost data warehouse with Azure and a beginner's guide to database indexing.
Explains how ToDictionaryAsync in Entity Framework Core retrieves entire database objects, impacting performance, and provides a solution using Select.
A talk from DjangoCon US 2025 explaining how to use Django 5.0's new GeneratedField, which computes values in the database.
A technical analysis of a SQL interview question about detecting suspicious account logins from multiple countries within a short timeframe.
Explores using JSON arrays over objects for serialization in jOOQ's MULTISET operator, focusing on performance and reliability.
Compares PostgreSQL's tuple-based MVCC and append-only updates with Oracle's in-place row updates and undo-based MVCC for database concurrency.
A technical guide on common pitfalls and best practices for implementing foreign key constraints in database design, using Django examples.
Microsoft releases SQL Server 2022 Cumulative Update 20, detailing its fixes, servicing model, and patching recommendations.
A tutorial on using Positron's Connections Pane to connect to and query DuckDB databases efficiently, especially for handling large datasets.
A guide for Oracle DBAs on PostgreSQL transaction control, locking mechanisms, and performance monitoring basics.
SQL Server 2022 Cumulative Update 19 includes a critical security fix for auditing missing permission changes, urging immediate installation.
A security experiment exposing a SQL Server to the internet, revealing attack patterns and providing security recommendations.
Explains why you can't branch a Datomic database from a past state and presents a potential workaround using custom filters.
Critiques a misleading LinkedIn performance tip about Entity Framework, explaining why dragging entire databases into memory is inefficient and offering the correct solution.
PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
