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...

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...

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...

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...

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,...

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,...

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...

FabCon 2025 Recap

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see so many folks in Redmond for the MVP Summit,...

Privacy Policy

We value your privacy. This policy explains what personal data we collect and why.
What We Collect

Cookies (for analytics, only after consent)
IP addresses (stored anonymously by our hosting provider)
Contact form...

Why use XACT_ABORT?

This came up one day at my work when a developer was using it. I hadn’t used it before and thought I’d better check it out. It’s off by...