See how SQL Server's Parameter Sensitive Plan optimization handles skewed parameters, how to verify dispatcher plans, and where PSP still falls short.
2026-09-04
3,649 reads
2026-08-26
874 reads
This article shows how you can generate embeddings in SQL Server 2025, store them, and use them in your queries.
2026-06-08
3,254 reads
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
8,443 reads
Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.
2026-04-27
4,313 reads
Learn about migrating SSRS reports to Power BI Report Server in SQL 2025
2026-04-03
6,361 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
10,432 reads
2026-02-20
705 reads
2026-02-16
746 reads
2026-02-13
958 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers