When we want to use AI-based comparisons of text, via vector search in SQL Server, we need to first generate embeddings for the text. An embedding is a numeric representation of meaning, usually represented by vectors. In this article, I’ll show you how to use Ollama to host a server locally that can be used to generate embeddings.
Index fragmentation can silently degrade your query performance over time. Learn what happens at the page level, how to measure it, and how to fix it.
Today Steve has a few thoughts on what the cloud is in 2026. See if you like his analogy.
Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.
Grant Fritchey explains the concept of ‘unknown unknowns’, points out what to watch out for in a cloud migration, and offers proven strategies to help your migration go as smooth as possible.
Certain announcements in AI tell you more about where an industry is heading than any earnings call or research paper ever could, and Midjourney just made one. The company that spent the last few years as the most recognizable name in image generation, the one whose pictures flooded everyone's feeds and defined what people saw […]
Change is unavoidable and always affects us. We can be both happy and sad about it as we move forward. A tribute today to Annabel, who retired from Redgate Software this week.
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
The LLM gateway pattern is a thin service layer that sits between your app and large language model (LLM) providers, centralizing every AI call through a single entry point. It gives you immediate control over routing, logging, retries, fallbacks, and cost tracking – preventing the chaos of scattered integrations, unclear billing, and provider lock-in as your system scales. Learn all you need to know about the LLM gateway pattern in this article.
One of the positives of AI is that you can try things on which you might not otherwise have time to experiment.
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers