T-SQL in SQL Server 2025: The PRODUCT Function

Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]

SQL Declare Variable Code Examples

This tutorial will discuss using variables with SQL DECLARE along with various examples.

Getting The Database Name

JSON Data Extract from SQL Server 2025

JSON is a complex data type used for representing objects with various properties. With JSON you follow the key-value pattern where the key is a string and the value can be of different data types. What are some common ways to work with JSON in SQL Server?

Getting the Schema for Tables

What is the original database name?

Getting the Object Code

T-SQL in SQL Server 2025: Concatenating Strings

Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +.  We have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This is the double pipe (||) operator. This article looks at […]

JSON_CONTAINS Function in SQL Server 2025

I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.

Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples

Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems