OUTER APPLY Fundamentals: Part 2

In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.

The Range of Customers

Escaping Strings

BIT_COUNT in SQL Server

Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.

T-SQL in SQL Server 2025: REGEXP_LIKE

This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().

Advanced T-SQL: Replacing Slow Cursors with Window Functions

This article looks at replacing a cursor with a window function to improve performance.

BIT_COUNT() IV

Time Series Data Mining Example with T-SQL when Adding New Data

Please demonstrate the steps for updating an existing time series dataset used in a prior data mining project with a fresh batch of data. Then, repeat the mining performed for the original dataset with the freshly updated dataset.

5 T-SQL features that should already exist (2026 SQL Server wish list)

2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage

CROSS APPLY Fundamentals: Part 1

Learn the basics of the CROSS APPLY operator with a few examples in this short piece.