Understanding SQL Server PARTITION BY with Examples

Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]

Representing Money

Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now

SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.

QUOTENAME Behavior

QUOTENAME Quote Parameters

Distance Metric Algorithms

SOFTMAX Function in SQL Server

Explore the mechanics of the SOFTMAX function in SQL Server. Transform scores into probabilities with this essential tool.

The Distance Metric

Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?

Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025.

How to Calculate Distance Between Coordinates in SQL Server

Learn a quick way to calculate distances without resorting to spatial calculations.