-
Continue reading →: Finding Bad Queries
T-SQL Tuesday #200 was in July, hosted by Brent Ozar, and it was a great topic: How do you recognize a bad query? In the age of AI, when lots of people will get queries written by others (people or AIs), how can you easily and quickly review code? Review…
-
Continue reading →: Monday Monitor Tips: The MCP Server
I have been experimenting with MCP servers in a few ways, and pressing on our Redgate Monitor team to add one to their system. They did, started adding tools, and are continuing to work. I’m excited. Here’s a quick look at the MCP server for Redgate Monitor (preview in July…
-
Continue reading →: Fixing P1 Queries
When we look at the performance of software, we use Pnn notation to indicate the latency of an issue. A P95 problem is one that exceeds the time that 95% of the other queries take. In other words, this is the 5% slowest things happening, which can include database slowdowns…
-
Continue reading →: A New Word: Mauerbauertraurigkeit
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company you generally enjoy, like a poker player who keeps folding a promising hand in order to avoid the pain of losing, or temp down the urge to go all-in. This one is close to home. It’s…



