Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
This article shows how you can generate embeddings in SQL Server 2025, store them, and use them in your queries.
2026-06-08
2,128 reads
This article shows how you can generate embeddings in SQL Server 2025, store them, and use them in your queries.
2026-06-08
2,128 reads
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
7,545 reads
Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.
2026-04-27
4,102 reads
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
2026-04-03
5,086 reads
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
9,299 reads
2026-02-20
660 reads
2026-02-16
695 reads
2026-02-13
901 reads
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
2026-01-12
3,566 reads
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
2,365 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers