UNISTR Basics

Query Exercise Answer: Generating Big TempDB Spills

In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL.

What is the PRODUCT

Putting the Player with the Number

5 Strategies to Refactor SQL Code

Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality code – yet somehow often gets overlooked in SQL.

T-SQL in SQL Server 2025: The UNISTR Function

I am not much for working in languages other than English. That's my native language and I know little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the interaction. And those interactions need to be stored in […]

Adding a Lot of Seconds

A New Operator

Which Object Definitions Are Available?

How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to: