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.
41 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.
Production RAG is iterative. Start simple, measure everything, and improve based on real user feedback.
Pure vector search excels at semantic similarity but can miss exact keyword matches. Pure keyword search finds exact terms but misses conceptually similar…
Experiment with chunk sizes, overlap, and retrieval strategies. Hybrid search combining semantic and keyword matching often provides the best results for…
Use Change Feed to trigger embedding generation and synchronization with other AI services automatically when documents are created or updated.
Hybrid search significantly improves retrieval quality for RAG applications by leveraging both semantic understanding and exact keyword matching.
Unlike exact-match caching, semantic caching uses embeddings to find similar queries even when worded differently.
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.
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.
Configure your Cosmos account with write regions near your users and read replicas globally. Vector searches automatically route to the nearest replica…
Vector search costs can spiral quickly at scale. After optimizing Azure AI Search deployments processing 50 million vectors, I've identified key patterns…
Quantization and HNSW tuning enable vector search at billion-scale with reasonable latency.
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.
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.
OneLake AI Workloads bring AI capabilities directly to your data, eliminating data movement and enabling efficient large-scale AI processing.
Pre-filtering: Filter before vector search Post-filtering: Filter after vector search Azure AI Search uses pre-filtering with automatic optimization.
HNSW builds a multi layer graph where: Higher layers : Sparse, for fast long range navigation Lower layers : Dense, for precise local search Layer 0 :…
PQ divides each vector into subvectors and quantizes each independently: For even faster search, combine with inverted file index: Dataset Size n subvectors…
Scalar quantization maps floating point values to integers by dividing the value range into buckets: Understanding quantization error helps set…
With quantization, this can be reduced to 1-2 GB.
Vector search finds similar items by comparing their mathematical representations (embeddings). The key components: Embeddings : Dense vectors representing…
Expanded Vector Dimensions Semantic Ranking Improvements Customer-Managed Keys for Vectors
Taking Vector Search to production requires careful consideration of performance, reliability, and maintenance. This guide covers production-ready patterns.
Databricks Vector Search enables semantic similarity search over your lakehouse data. Build RAG applications, recommendation systems, and intelligent search…
1. Start conservative Higher threshold (0.95+) for critical applications 2. Tune with data Evaluate on your actual query patterns 3. Monitor quality Track…
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 Azure AI Search index changes work in place, which force a rebuild, and how to swap versioned indexes, load documents and check health safely.
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.
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.
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.
Advanced techniques for improving Retrieval-Augmented Generation systems for better accuracy and relevance.
Hybrid retrieval improves RAG quality by combining the strengths of different search approaches. Tomorrow, I will cover Azure Dev Box and development…
Vector search enables powerful semantic search capabilities. Tomorrow, I will cover hybrid retrieval patterns in more detail.
Azure Cognitive Search can't search vectors in January 2023. Here's how to re-rank its keyword results with Azure OpenAI embeddings, and when not to bother.
What a vector database adds over brute force: ANN indexes, recall, filtering and updates, and how Pinecone, Weaviate, Milvus, Qdrant and pgvector compare.
Hybrid search patterns enable building search systems that handle diverse query types effectively.
Vector search enables powerful similarity-based retrieval that complements traditional keyword search.