Build It, Buy It, Cloud It? The IT Decision Puzzle
The Never-Ending Question in IT: Which Approach to Take? As a Consultant, I would typically answer with = it depends! Then a typical conversation starts with an expression of...
2025-03-05
33 reads
Knoxville M365 Community Days Recap
Hello data friends! Had a blast at my first ever M365 Community Day this past weekend! Thank you to all the amazing organizers and sponsors who made it happen,...
2025-03-04
20 reads
What is Deferred Name Resolution?
One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this works and where it works. In the Microsoft docs,...
2025-03-10 (first published: 2025-03-03)
444 reads
SQL Server Time Bombs
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental prod DBA) you’ve gotten that frantic call in the middle of the night. Or maybe...
2025-03-12 (first published: 2025-02-28)
563 reads
Book Review: A Radical Enterprise
I grabbed this book over the 2024 holiday season as it was on sale and recommended by the DevOps practitioners over at ITRevolution. A Radical Enterprise looks at a...
2025-03-14 (first published: 2025-02-28)
131 reads
Advice I Like: Investing and Growing Rich
Investing small amounts of money over a long time works miracles, but no one wants to get rich slow. – from Excellent Advice for Living This is incredible advice,...
2025-02-28
25 reads
The London Redgate Summit
In a week I’m heading to London for the Redgate Summit. I enjoyed these last year and had some very interesting conversations with customers, prospects, and a few Redgate...
2025-02-28
19 reads
Eliminating Unnecessary DELETE Operations
SQL Server performance issues often stem from easy fix bottle necks that can be fixed with the right tuning strategies. This short blog will focus on the DELETE statement....
2025-03-12 (first published: 2025-02-28)
742 reads
T-SQL Tuesday #183: Improving Permission Management
This is my (late) answer to my own invitation for T-SQL Tuesday #183. I was very busy a few weeks ago when the invite when out (glad it was...
2025-03-07 (first published: 2025-02-26)
445 reads
Enterprise Digital Exhaust
Digital exhaust, or data exhaust, is the information you generate as you interact digitally. We've typically thought of this in terms of tracking cookies and the like, but it...
2025-03-07 (first published: 2025-02-25)
196 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