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.
A guide to getting started with the psql command-line interface for PostgreSQL, covering essential utility commands and configuration tips.
A tutorial on using SQL with Apache Iceberg tables in the Dremio data lakehouse platform, covering setup and core operations.
Learn to export DynamoDB data to S3 and query it using SQL with AWS Athena, exploring serverless, scalable analytics solutions.
A guide explaining dbt macros, their purpose, benefits, and how to use them to write reusable, standardized SQL code in data transformation projects.
A tutorial on connecting to and querying SQL databases using the R programming language, including driver setup and error handling.
Explains how to use Amazon Q Developer's workspace context and @workspace hint to generate accurate SQL queries by providing relevant schema files.
