How to call an Ollama-based AI text embeddings model from SQL Server 2025
Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint
Bad IT People
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
Calculating Geometric Mean in Power BI
Learn how to add the geometric mean in Power BI to your calculations.
SQL Server Contained Availability Groups Configuration
In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?
Have you done a Mid year check in?
This Editorial is coming to you during an exciting birthday for the United States. If you are in the US, you are most likely celebrating the 4th of July. This is the 250th anniversary for the US, quite a milestone. I hope that all my US friends are celebrating safely and responsibly. While it is […]
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Learn how to get started with an MCP server that can query your SQL Server database.
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Another fun article for America's Independence Day using SQL Server's spatial features.
How to stop AI hallucinations in enterprise RAG systems (a complete guide)
From the Air Canada chatbot lawsuit to the infamous Chevy dealership pricing fiasco, this article breaks down the six real reasons RAG systems fail in production – and the five architectural patterns high-performing AI teams use to make them trustworthy, grounded, and production-ready.
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.
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers