Tips for improving performance in Entity Framework Core, covering compiled queries, lazy loading, and other optimizations for reads and writes.
A guide on importing Java Flight Recorder (JFR) profiling data into DuckDB for analysis using SQL queries.
PostgreSQL 19 adds direct COPY TO support for partitioned tables, improving usability and performance over the previous SELECT workaround.
A technical guide on normalizing SQL cross-join data in ColdFusion by using table prefixes and restructuring query results into nested objects.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
Explains why and how to use CancellationTokens in .NET APIs to stop long-running operations and free server resources.
PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
Using DTrace to determine if SQL files are accessed at build time or runtime in a Go application, focusing on I/O tracing.
Learn how to use DTrace to monitor and inspect live SQL queries, including their arguments, from a running Go application without code changes.
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.
A software engineer shares three highly effective production alerts for catching bugs and system issues, based on real-world experience.
A technical guide on connecting Apache Flink SQL to a Kafka broker on Confluent Cloud, covering broker endpoints and API key configuration.
PostgreSQL 18 introduces new non-text dump formats for pg_dumpall and pg_restore, improving performance and flexibility for database backups.
Explores SQL array functions and the integration of lambda expressions in modern SQL dialects like ClickHouse and DuckDB for filtering and transforming array data.
A guide to exporting SQL queries from DuckDB's new UI notebooks using a custom Bash script for backup or sharing.
Explains the SQL MERGE statement by comparing it to a RIGHT JOIN, showing how to think about source and target tables in ETL operations.
A technical tutorial on using Apache Flink SQL to explore and process real-time flood monitoring data from a government API, demonstrating data wrangling techniques.
Common issues with SQL date functions and practical solutions for developers and DBAs to avoid errors and improve query performance.
A technical tutorial on using the UNNEST operator in Flink SQL to explode nested arrays of sensor data into separate rows.
