Writeups

What was built, what was measured, and what turned out to be wrong

← Back to search

Notes from building this thing. Working code rather than a survey, and the negative results stay in.

Hybrid code search on Azure SQL and SQL Server 2025, end to end

29 Sep 2026 · ~10 min

Source files in, ranked answers out, one database, no separate vector store. Roslyn chunking on statement boundaries, DiskANN, RRF across three retrieval legs, cross-encoder reranking, and a relevance gate. Including the one place the two platforms genuinely diverge: VECTOR_SEARCH has two mutually unparseable grammars and the version key that tells you which to use is missing on self-hosted.

Azure SQLSQL Server 2025DiskANNRRFRoslyn.NET