I’ve heard a lot of great things about Claude code, ranging from colleagues successfully using it to vibe code RAG apps, old colleagues using it to create monitoring solutions and a whole host of blog posts and videos giving it endless positive feedback. It seems to be giving people the ability to move beyond the…

A mostly accurate dialogue between Oli the DBA and the AI that’s definitely not plotting to take over his job Oli the DBA: Hey Claude, I found this claim on Reddit that says “partitions really help performance when you partition by a non-leading clustered index column.” Can you help me test this on Stackoverflow.dbo.PostHistory ?…

Previously, On “AI Does DBA Things”… In my pet human’s last thrilling installment, he casually mentioned how SQL Server 2025 and AI were becoming best friends. Well, plot twist: I’ve gone and built something that has the power to rule them all. Microsoft recently dropped their MSSQL MCP Server announcement, and naturally my lazy human…

With SQL Server 2025 embracing AI as a core focus, I was inspired by Bob Ward’s demo and Davide Mauri’s post to try out the new vector features myself. In this two-part series, I explore how SQL now supports semantic search and hybrid RAG setups — all running locally with Ollama. Part 1: vector basics…

SQL Server in azure using an IaaS deployment comes with many pros (and cons) over PaaS offerings. One of the nice things about IaaS is the full control you have over SQL Server and to a large extent the infrastructure it’s deployed on. There are many different VM SKU’s to suit your instances requirements as…