Greg Low in SQL Server

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. Discover limitations,...

15 April 2026 5 min read

Rodrigo Ribeiro Gomes in SQL Server

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

Learn about the new CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS commands in SQL Server 2025.…

09 February 2026 29 min read

Edward Pollack in Featured

SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL

Learn the new PRODUCT() aggregate function in SQL Server 2025 - multiply values across rows like SUM() adds them. Covers...

21 July 2025 9 min read

An image showing the words 'regular expression' against a pictorial background.

Edward Pollack in Featured

Regex in SQL Server 2025: All Seven REGEXP Functions Explained

SQL Server 2025 adds native regex support with seven new REGEXP functions: REGEXP_LIKE, REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_MATCHES, and REGEXP_SPLIT_TO_TABLE....

14 July 2025 18 min read

A stock image showing someone working on a laptop

Edward Pollack in SQL Server

Columnstore Index Improvements in SQL Server 2025

Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.…

30 June 2025 11 min read

Aaron Bertrand in SQL Server

SQL Server 2025 ZSTD Backup Compression Guide

SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,...

11 June 2025 15 min read

Edward Pollack in SQL Server

TempDB Resource Governor Space Controls in SQL Server 2025: A Complete Guide

SQL Server 2025 introduces the ability to use Resource Governor to help manage TempDB resources automatically. This article dives into...

09 June 2025 15 min read

Edward Pollack in SQL Server

SQL Server Developer Standard Edition: A Gift to Developers!

SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment...

21 May 2025 9 min read

Simple Talk Editor in SQL Server

SQL Server 2025 is in Public Preview!

On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of...

21 May 2025 3 min read

Dennes Torres in T-SQL Programming

Azure SQL Native JSON Data Type: Query Techniques

Explore Azure SQL's native JSON data type with CHECK constraints, JSON_ARRAYAGG, JSON_OBJECTAGG, and JSON_OBJECT functions. These features are coming to...

07 May 2025 16 min read