Measure exact vector search with VECTOR_DISTANCE, reduce candidates through indexed filters, and compare plans and measured IO.
Estimating vector Column Storage Before Loading Embeddings
Estimate vector column storage from dimensions, measure DATALENGTH and table allocation, and separate payload bytes from page overhead.
What is SQL Server Launchpad Service? – Interview Question of the Week #168
What is the SQL Server Launchpad Service? I had to look it up myself. Here is the short answer: it launches the Advanced Analytics Extensions processes.
Vector Search in SQL Server 2025 With VECTOR_DISTANCE
Use VECTOR_DISTANCE in SQL Server 2025 to rank small example vectors, compare cosine and euclidean distance, and plan larger searches.
Cosine, Euclidean or Dot: Picking a Vector Distance Metric
Cosine, Euclidean and dot can rank the same vectors differently. Here are tiny examples you can check by hand, plus how to choose.
Writing T-SQL With an AI Assistant: What to Check Before You Run It
Review T-SQL from an AI assistant for real columns, safe writes, index access, date boundaries, isolation, and rollback tests.
VECTOR_SEARCH in SQL Server 2025: Finding Similar Rows With a Vector Index
VECTOR_SEARCH returns the rows whose vectors sit closest to a vector you give it, and a vector index makes that search approximate and fast. This post builds a six-row test with hand-made numbers on SQL Server 2025, with no AI model, and lists the limits the test showed.