2026-08-22
91 reads
Artificial Intelligence (AI)
Another Model, More Data Loss
More issues with the newest GPT-5.6 model, including data loss incidents.
2026-07-24
139 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
137 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,297 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
2,965 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
136 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
176 reads
2026-04-29
204 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat Kantor BCA KCP Fatmawati Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota...
Alamat BCA KCP Gatot Subroto Telp:0821-8200-233
Telp/WA 62 8218200233 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 Lt GF unit C,...
Alamat BCA KCP Warung Buncit Telp:0821-8200-174
Telp/WA 62 8218200174 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, RT.1/RW.1, Tegal Parang, Kec....
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers