Argues against placing business logic in stored procedures, advocating for keeping it in the application layer for better maintainability and scalability.
Tutorial on using Dremio's AI_COMPLETE SQL function to generate product summaries, marketing copy, and translations directly within a data pipeline.
A tutorial on using Dremio's AI_CLASSIFY SQL function to categorize data like customer sentiment and support tickets directly within a data lakehouse.
Tutorial on using Dremio's AI_GENERATE SQL function to extract structured data from unstructured text like emails and contracts.
Explains how a semantic layer enforces data governance by embedding policies directly into the query path, ensuring consistent metrics and access control.
A SQL expert details the strategy for designing an interactive conference session on solving query performance differences between development and production databases.
Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
Monthly job board for database professionals, featuring direct hiring posts from companies for February 2026 roles.
Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
Analysis of the most popular personal blogs on Hacker News in 2025, based on a tracking project that ranks domains by their performance on the platform.
A technical guide on implementing vector search in Oracle Database 26ai, using a car manual as a practical example to improve semantic search.
Introduces dremioframe, a Python DataFrame library for querying Dremio with a pandas-like API, generating SQL under the hood.
Explains offset and keyset pagination in Spring Data JPA, comparing their performance and implementation details.
A hands-on tutorial exploring Dremio Cloud Next Gen's new free trial, covering its lakehouse platform, AI features, and SQL capabilities.
Explores building durable execution systems for agents using only Postgres, avoiding third-party services with a simple SQL library.
PostgreSQL 19 adds a new %S prompt variable to psql to display the current search_path, aiding users who frequently work with multiple schemas.
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.
