Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
This article shows how you can generate embeddings in SQL Server 2025, store them, and use them in your queries.
2026-06-08
1,796 reads
Artificial Intelligence (AI)
Local vs remote MCP servers – which should you choose?
Should you choose a local or remote MCP server? The best option depends on your security needs, performance goals, and deployment model. This guide explains the differences between local and remote Model Context Protocol (MCP) servers, including privacy, scalability, latency, and integration trade-offs.
2026-05-22
Limit the Blast Radius
AI can go off the rails, as we see in a recent story about an LLM deleting a production database.
2026-05-20
91 reads
The Dangers of Dependencies
Single points of failure are bad, but what if an employee's action is the single point of failure for access to services? That would be a bad day for any organization.
2026-05-06
129 reads
2026-04-29
160 reads
2026-04-24
96 reads
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Learn about using SQL Server to support AI-enhanced search queries with the Relational Embedding Retrieval Pattern (RERP).
2026-04-24
1,815 reads
Who is Irresponsible?
It can be irresponsible to use AI, but is it in many cases? Steve has a few thoughts.
2026-04-15
96 reads
Barely Reviewed Code
Code reviews can be challenging in many places, and with AI, could be even more of an issue in the future.
2026-04-08
114 reads
This Week's AI Trust Problem Became Everyone’s Problem
There’s a saying in security circles: the weakest link isn’t the lock on the front door but the spare key under the mat. This past week gave us two vivid, simultaneous demonstrations of that principle, and if you’re building anything in the AI space right now, both deserve your full attention. The Mythos Leak and […]
2026-04-04
168 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers