T-SQL in SQL Server 2025: Substring Changes

This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.

Regular Expressions in SQL Server 2025

This article examines the new regular expression functions added to T-SQL in SQL Server 2025.

Vector Datatype Dimensions

SQL Server 2025 Makes Memory Troubleshooting Easier.

SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.

Natural Language Query for SQL Server

Data is usually the most important asset in organizations, but only SQL developers can frequently access that data. Technical teams often write queries for non-technical users. This restricts agility, slows decision-making, and creates a bottleneck in data accessibility. One possible remedy is natural language processing (NLP), which enables users to ask questions in simple English and receive answers without knowing any code. Still, the majority of NLP-to-SQL solutions are cloud-based, which raises issues with cost and privacy.

Vector Datatype

The New SQL Server 2025 Data type

Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines

Create your own test lab on Hyper-V to evaluate SQL Server 2025 and Windows Server 2025

How to Use the New PRODUCT() Function in SQL Server 2025

Introduced in SQL Server 2025 CTP 1.3, the PRODUCT() function acts similarly to SUM(), but multiplies values rather than adds them. It is an aggregate function in SQL Server and therefore operates on a data set, rather than on scalar values.

Columnstore Index Improvements in SQL Server 2025

Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has improved in every version of SQL Server since their inception over ten years ago, and SQL Server 2025 is no exception!