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.
Explains the SQL MERGE statement by comparing it to a RIGHT JOIN, showing how to think about source and target tables in ETL operations.
Common issues with SQL date functions and practical solutions for developers and DBAs to avoid errors and improve query performance.
Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
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.
A developer reflects on SQL's relevance after a colleague's unfamiliarity with it, questioning if it's becoming a niche skill in modern tech stacks.
Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.
HeavyIQ is an AI-powered English-to-SQL interface from HEAVY.AI, using a fine-tuned LLM to query and visualize massive datasets like flight records.
Explains how to compare dates by ignoring the time component in PostgreSQL queries, using the DATE() function.
A tutorial on building a simple database with MVCC to implement and understand the five major SQL transaction isolation levels in 400 lines of code.
A tutorial on using Dremio and Docker to run SQL queries directly on Excel files from your local machine.
Argues against using LLMs to generate SQL queries for novel business questions, highlighting the importance of human analysts for precision.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
