Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

The platform runs SQL Server on Kubernetes and directly connects SQL Server to Apache Spark for in-memory machine learning and advanced analytical functions.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs.