SQL Server Index Primer
Indexes 101: What, Why, and When? “What Is an Index?” I get this question a lot, especially from developers and sysadmins who’ve been handed a SQL Server and told,...
2025-05-12 (first published: 2025-04-23)
270 reads
Secure Azure SQL Server Backups Using Managed Identities
I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key...
2025-05-09 (first published: 2025-04-23)
377 reads
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage large language models (LLMs) without relying on cloud services. As we learned in my previous...
2025-05-07 (first published: 2025-04-22)
578 reads
Monday Monitor Tips: Finding the Hostname for Queries
I was chatting with a customer recently and they wanted to know which host was sending in queries that were causing problems in real time. This post looks at...
2025-05-05 (first published: 2025-04-21)
525 reads
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML...
2025-05-07 (first published: 2025-04-21)
560 reads
Streamline Dependency Management in Databases
In the intricate world of business, where precision and efficiency are paramount, managing database dependencies can often feel like navigating a labyrinth. Imagine having a tool that not only...
2025-05-05 (first published: 2025-04-21)
292 reads
A New Word: Immerensis
immerensis – n. the maddening inability to understand the reasons why someone loves you – almost as if you’re selling them a used car that you know has a...
2025-04-18
68 reads
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple flask-based TODO application to Azure Container Apps using Pulumi. You will Dockerize the Python application,...
2025-04-18
78 reads
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using Ollama. There is no cloud, and there is no cost. Just install, pull a model,...
2025-05-02 (first published: 2025-04-17)
443 reads
SQL Server Wait Stats
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-30 (first published: 2025-04-16)
399 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers