DiskANN in Azure SQL Is GA: Do You Still Need a Separate Vector Store?
DiskANN vector indexes are now GA in Azure SQL and Fabric SQL. When embeddings belong next to your rows, and when Azure AI Search still wins.
91 articles
DiskANN vector indexes are now GA in Azure SQL and Fabric SQL. When embeddings belong next to your rows, and when Azure AI Search still wins.
Azure AI Search and Cosmos DB fuse keyword and vector results for you; pgvector doesn't. What owning RRF in PostgreSQL involves, and when it pays.
A journey-level latency budget only works when each step gets a cap, a timeout and a fallback; here is how to split one across a RAG request.
Good retrieval is wasted if users cannot verify the answer, so design RAG citations to be checkable, validated in code and measured like relevance.
Hybrid search is default RAG advice, but the BM25 leg has real costs; a three-way test on Azure AI Search shows which questions it rescues.
Once retrieval is ruled out, ungrounded answers fall into a few repeatable patterns: label them, fix one at a time and track completeness too.
Make retrieval-first a team rule: an owned question set, a side-by-side index comparison on Azure AI Search, and a gate that fails on lost answers.
Most eval sets only ask questions the documents can answer. Add unanswerable, false-premise and stale-context cases, each with an expected behaviour.
The semantic ranker only reorders the top 50 results. A with-and-without test on a labelled set shows which RAG queries it rescues and which it just slows.
Most wrong RAG answers start with the passages, not the prompt. A labelled question set and a retrieval-only triage on Azure AI Search show which one to fix.
How I compare a baseline and a candidate prompt or model on frozen context, count groundedness regressions per row, and treat fluency as a tie-breaker.
Fine-tuning and RAG fix different failures. How to tell which one you have on Microsoft Foundry in early 2026, what each costs, and when to combine them.
Azure AI Search knowledge bases now plan queries for you, in preview. When to hand over the RAG pipeline, when to keep building it, and how to test both.
Azure AI Search, DocumentDB, Cosmos DB for NoSQL, pgvector, Pinecone and Redis each fail differently in RAG. Where each one hurts in January 2026.
Diagnose why a RAG system fails before adding patterns: hybrid search, semantic reranking, grounding gates and citations on Azure AI Search, mapped to failures.
This pattern works for any documentation. The key is good chunking, quality embeddings, and a well-crafted system prompt that keeps the bot focused on your…
Production RAG is iterative. Start simple, measure everything, and improve based on real user feedback.
Azure AI Search, Cosmos DB with vector indexing, and Azure Database for PostgreSQL with pgvector each provide vector search capabilities with different…
Pure vector search excels at semantic similarity but can miss exact keyword matches. Pure keyword search finds exact terms but misses conceptually similar…
Poorly designed prompts lead to hallucinations, ignored context, or responses that fail to meet business requirements. A systematic approach to prompt…
GraphRAG excels when your questions involve multi-hop reasoning, relationship discovery, or when entity connections matter more than document similarity.
Use Fabric notebooks to create interactive RAG applications that combine data exploration with AI-powered question answering over enterprise datasets.
Experiment with chunk sizes, overlap, and retrieval strategies. Hybrid search combining semantic and keyword matching often provides the best results for…
Hybrid search significantly improves retrieval quality for RAG applications by leveraging both semantic understanding and exact keyword matching.
The best chunking strategy depends on your document types. Technical documentation benefits from header-aware chunking. Conversational content works well…
The best vector database depends on your specific requirements. Azure AI Search excels for hybrid search with integrated semantic ranking. Pinecone offers…
Vector search excels at semantic similarity but can miss exact matches. Keyword search finds precise terms but misses synonyms and context. Together, they…
The text-embedding-ada-002 and newer text-embedding-3 models provide high-quality embeddings with minimal setup.
Best for organizations already invested in Azure with hybrid search requirements. Pros: Hybrid search, semantic ranking, enterprise security, managed…
Keyword search excels at exact matches and rare terms. Vector search captures semantic similarity. Combining them leverages both strengths while mitigating…
The simplest approach splits text at regular intervals with optional overlap. Semantic chunking respects content boundaries like paragraphs and sections.
RAG works by first retrieving relevant documents from a search index, then passing those documents as context to an LLM for generation. This approach…
Multimodal RAG ensures users find relevant information regardless of how it's represented in the source documents.
Fail builds when quality metrics drop below thresholds, catching regressions before they reach production.
Vector search costs can spiral quickly at scale. After optimizing Azure AI Search deployments processing 50 million vectors, I've identified key patterns…
Multimodal RAG unlocks intelligence from documents containing text, tables, and images.
Query transformation is a high-leverage improvement for RAG systems.
Cross-encoder reranking typically improves RAG precision by 10-20%.
Choose chunking strategy based on document structure and retrieval requirements.
GraphRAG excels at complex questions requiring synthesis across multiple documents.
Advanced RAG combines query expansion, hybrid retrieval, reranking, and context compression for better results.
Multimodal RAG unlocks knowledge trapped in visual formats. Start with document-heavy use cases where diagrams and charts carry critical information.
Hybrid search continues to outperform pure vector or keyword approaches. Invest in tuning your fusion strategy for your specific domain.
Make diagrams and charts in PDFs retrievable with Document Intelligence 4.0 figure extraction, GPT-4o descriptions and Azure AI Search hybrid queries.
How to build hybrid search inside PostgreSQL with pgvector, full-text search and weighted reciprocal rank fusion, and when a dedicated search service is better.
Azure AI Search, Cosmos DB for NoSQL and PostgreSQL with pgvector can all hold embeddings now. Here is how I decide between a search index and your database.
How Microsoft's GraphRAG 1.x builds a knowledge graph, what local, global and DRIFT search do, and when its indexing cost is worth paying over vector RAG.
Which RAG retrieval upgrades Azure AI Search gives you as GA or preview in January 2025, which you build yourself, and the order I'd add them in.
A practical ladder of LLM patterns on Azure in January 2025: structured outputs, grounded RAG, tool workflows, self-review and agents.
Pre-filtering: Filter before vector search Post-filtering: Filter after vector search Azure AI Search uses pre-filtering with automatic optimization.
Expanded Vector Dimensions Semantic Ranking Improvements Customer-Managed Keys for Vectors
AI agents need memory to maintain context across interactions. Today I'm exploring how to implement effective memory systems.
Individual component metrics tell part of the story, but end-to-end evaluation measures how well your entire RAG pipeline performs as a system.
While context precision measures noise in retrieved results, context recall measures completeness. Are you retrieving all the documents needed to fully…
Context precision measures whether the retrieved documents are actually relevant to answering the question. High precision means less noise for the…
An answer can be factually correct and grounded in context but still fail to address what was actually asked. Answer relevancy measures how well the…
Faithfulness is perhaps the most critical metric for RAG systems. An unfaithful answer that hallucinates information not in the source documents can be…
While retrieval metrics measure what documents are found, generation metrics evaluate the quality of the synthesized answer. This guide covers metrics…
The retrieval component of RAG systems directly impacts generation quality. This guide provides a comprehensive overview of retrieval metrics and how to…
RAGAS (Retrieval Augmented Generation Assessment) is an open-source framework for evaluating RAG pipelines. This guide covers how to implement and use RAGAS…
Retrieval-Augmented Generation (RAG) systems combine retrieval and generation components, each requiring specific evaluation strategies. This guide covers…
Cohere's models are now available on Azure AI, offering specialized capabilities for enterprise search and retrieval-augmented generation (RAG). This guide…
The edge cases of index projections in Azure AI Search: what the chunk index schema needs, how keys change on re-index, deletes, and keeping chunk order.
Which hybrid search knobs Azure AI Search exposes on the 2023-11-01 API, why I avoid client-side score weighting, and how to measure changes before shipping.
Azure AI Search has no built-in vector compression yet. How to estimate vector index size, read the quota, and cut it with chunking and dimension choices.
How to design semantic configurations, use reranker scores as a RAG cut-off, and decide when Azure AI Search's semantic ranker is worth paying for.
What integrated vectorization in Azure AI Search actually removes from a RAG pipeline, what it leaves behind, and when I'd still embed in my own code.
A January 2024 stock-take of Azure AI Search for RAG: which features are GA, which are preview, and which SDK and REST versions to build on.
How to add retrieval grading, query rewriting, and groundedness checks to RAG on Azure OpenAI and Azure AI Search without tripling latency or cost.
Chunk documents along their headings, keep tables whole and prefix every chunk with its section path, using Document Intelligence markdown output and Python.
A five-level RAG maturity model for Azure AI Search and Azure OpenAI, covering what each level fixes, what it costs, and when to stop climbing.
For many teams, the Assistants API's Retrieval tool removes the most tedious parts of building a knowledge assistant — you upload documents and the…
I prefer the Assistants API's file-based retrieval when I need a fast, low-friction knowledge assistant — upload a set of documents and let the assistant…
RAG with Azure Cognitive Search and Azure OpenAI is the production architecture I recommend most often for enterprise knowledge retrieval — not because it's…
Implementing multi-index RAG systems to query and combine information from multiple knowledge sources.
Implementing recursive retrieval strategies for handling complex, multi-step queries in RAG systems.
Implementing auto-merge retrieval to automatically combine related chunks for comprehensive context.
Implementing sentence window retrieval to balance precision and context in RAG systems.
Implementing parent-child document retrieval to improve context and accuracy in RAG applications.
Comprehensive guide to document chunking strategies for optimal retrieval in RAG applications.
Advanced techniques for improving Retrieval-Augmented Generation systems for better accuracy and relevance.
This concludes our August 2023 series on LLM optimization and vector stores.
Hybrid retrieval improves RAG quality by combining the strengths of different search approaches. Tomorrow, I will cover Azure Dev Box and development…
Copilot for Docs is one of the most concrete RAG applications Microsoft shipped publicly in this period—a conversational interface over documentation that…
RAG is the bridge between general-purpose LLMs and your specific enterprise data. Get it right, and you unlock tremendous value.
1. Organize into collections : Separate by topic/domain 2. Use meaningful IDs : Enable updates and deletions 3. Set appropriate relevance thresholds : Too…
Cross encoders directly score query document pairs: Use an LLM to judge relevance: Using Cohere's specialized rerank API: 1. Retrieve more, re rank fewer :…
A robust way to combine rankings: Adjust weights based on query characteristics: 1. Start balanced : 50/50 is often a good default 2. Tune on your data :…
Simple but effective for uniform content: Respect sentence boundaries: Natural document structure: Use embeddings to find natural break points: Hierarchical…
The basic pattern for straightforward use cases: Transform queries for better retrieval: Generate a hypothetical answer first, then use it for retrieval:…
What retrieval augmented generation is, why it beats fine-tuning for company knowledge, and a minimal loop on Azure OpenAI completions in January 2023.