T-SQL in SQL Server 2025: JSON_OBJECTAGG
Learn about the new JSON_OBJECTAGG function in SQL Server 2025.
2026-03-30
2,996 reads
T-SQL
2026-04-01 (first published: 2026-03-27)
839 reads
Vectors in SQL Server 2025
Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]
2026-03-23
10,546 reads
2026-03-23
1,086 reads
2026-03-20
1,441 reads
2026-03-18
1,236 reads
2026-03-06
582 reads
Find Duplicate Rows in SQL Server with a CTE
This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).
2026-03-04
2026-03-04 (first published: 2026-02-27)
789 reads
2026-02-25
1,158 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers