~/talk

What's new in SQL Server 2025 and Azure SQL Databases

Talkat NDC Oslo 2026 · 2026-09-14..09-18· [databases, cloud-infrastructure]
links:none on file
slides:none on file

SQL Server 2025 and Azure SQL now store and search embeddings natively: a new vector data type (examples: 768 and 1,536 dimensions) replaces million-column workarounds, turning 17,000 products into about 13 million floats queried with a built-in vector distance function or fast vector index (ANN/KNN). Demos use LM Studio and Azure endpoints to generate embeddings, show REST calls from SQL, a true JSON column with indexes and modify, regex and fuzzy (Jaro–Winkler) matching, chunking for large docs, change-event streaming to Event Hubs/Fabric, and SSMS Copilot for ad hoc SQL.

AI-written summary · about

  1. 0:00Introduction to SQL 2025 updates
  2. 1:13SQL understanding data meaning
  3. 4:47Graph databases recap
  4. 5:09Vector databases and RAG explained
  5. 10:30Manual vector embedding demo
  6. 21:38SQL 2025 vector data type
  7. 24:32SQL 2025 AI embedding generation
  8. 27:10External model setup in SQL
  9. 30:25Vector index limitations
  10. 31:08Azure SQL vector search
  11. 34:45AI generated chunks feature
  12. 37:43SQL REST API calls
  13. 41:11JSON type and performance
  14. 46:14Regex and data extraction
  15. 51:00Regex patterns and masking
  16. 53:05Fuzzy search and similarity
  17. 57:30Hybrid search capabilities
  18. 57:52Change event streaming
  19. 58:57SQL Copilot features
  20. 1:00:00Closing and Q&A
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.