XQuery Comparisons use different rules for general sequence operators and singleton value operators. I make equality and inequality visible side by side. A general unequal-pair result is not always the inverse of an equal-pair result.
MySQL – How to Write Loop in MySQL
MySQL does not let you loop in ad-hoc SQL. Here is how to write a loop in MySQL with a simple stored procedure that uses LOOP, ITERATE and LEAVE.
MYSQL – Identifying Current Version of MySQL Server Installation – Part 2
Readers shared more ways to find the current version of MySQL: SELECT VERSION(), SELECT @@Version, the STATUS command and SHOW VARIABLES.
Finding the Most Frequent Value per Group in T-SQL
Find the most frequent value in each group, choose a tie policy, and compare categorical modes with averages and numeric percentiles.
Keeping Your Own Script Library
A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.
A WHERE Filter That Turns Your LEFT JOIN Into an INNER JOIN
Fix a LEFT JOIN whose right-table WHERE filter removes unmatched rows, inspect the inner-join plan, and search modules for candidates.
ETL vs ELT: How Big Data Changed the Way We Load Data
ETL vs ELT comes down to when you transform: before the load on a separate engine, or after it inside the platform. This post compares the two and runs a small ELT pipeline in T-SQL on JSON orders.







