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.
SQL SERVER – Select Columns from Stored Procedure Resultset
Need only some columns from a stored procedure resultset? Store it in a temp table with INSERT INTO and EXEC, then select what you need.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
Part 4 on reading the previous row and next row value in a SELECT statement. My friend Szymon Wojcik shows how a numbers table can make the query even faster.