Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,228 reads
Let’s talk SQL Server Waits: Topic 2 – CXPacket
With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...
2019-01-30 (first published: 2019-01-16)
2,695 reads
Inspector V1.3 hotfix
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
177 reads
Deploying SQL Server to Kubernetes using Helm
In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...
2019-01-29 (first published: 2019-01-16)
2,678 reads
It’s always parameter sniffing (part 1?)
This is a blog post about a perennial issue. Have you ever had a call in the middle of the...
2019-01-28 (first published: 2019-01-16)
3,041 reads
Beware! Beware of Unintended Changes When Altering Columns!
(last updated: 2019-01-15 @ 19:50 EST / 2019-01-16 @ 00:50 UTC )
I haven’t seen a lot written about these particular behaviors so I...
2019-01-28 (first published: 2019-01-15)
2,416 reads
Inspector V1.3 now available
Inspector V1.3 is now available on GitHub.
We have updated the sample report for you to play with which includes the...
2019-01-15
152 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...
2019-01-15
9 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...
2019-01-15
5 reads
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...
2019-01-25 (first published: 2019-01-15)
2,205 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
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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