2026-05-06
634 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,262 reads
2026-04-23 (first published: 2026-04-22)
510 reads
2026-04-15
827 reads
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Learn about the new JSON_OBJECTAGG function in SQL Server 2025.
2026-03-30
2,930 reads
2026-03-18
1,208 reads
2026-03-04
632 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,899 reads
2026-02-18
654 reads
2026-02-04
1,154 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers