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.
Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
How to use DuckDB's COLUMNS expression to automatically rename fields when using SELECT * across joined tables, avoiding ambiguous column names.
An overview of Apache Flink CDC, its declarative pipeline feature, and how it simplifies data integration from databases like MySQL to sinks like Elasticsearch.
Essential Linux skills for SQL Database Administrators to improve efficiency and marketability in modern IT environments.
