2026-05-06
636 reads
JSON
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.
2026-04-27
4,274 reads
2026-04-23 (first published: 2026-04-22)
513 reads
2026-04-15
828 reads
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Learn about the new JSON_OBJECTAGG function in SQL Server 2025.
2026-03-30
2,936 reads
2026-03-18
1,211 reads
2026-03-04
635 reads
Fun with JSON
Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]
2026-03-09 (first published: 2026-02-18)
4,926 reads
2026-02-18
656 reads
2026-02-04
1,155 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers