Four Rules for Adding AI Without Breaking What Already Works
Kellyn talks about the four golden rules when adding AI features to existing applications and systems.
2026-10-03
73 reads
Artificial Intelligence (AI)
2026-08-22
128 reads
Another Model, More Data Loss
More issues with the newest GPT-5.6 model, including data loss incidents.
2026-07-24
152 reads
Cognitive Coverage
Understanding the scope of what AI and humans are changing in your code going to be an important part of your future as a tech professional.
2026-07-01
157 reads
How to host an AI text embeddings model for SQL Server using Ollama
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.
2026-06-24
You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
2026-06-19
1,365 reads
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
3,268 reads
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
157 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
199 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers