When were the statistics last updated and how many rows were sampled?
TL;DR; Final query is at the bottom. Every now and again (particularly when someone is having performance problems) I’ll get ... Continue reading
2019-09-04
203 reads
SQL in the City Streamed is Today
Today is SQL in the City Streamed!!! Only three of us, , as Kendra has other commitments. Still, it’s exciting for Kathi, Grant, and myself to be presenting the...
2019-09-04
19 reads
Azure Storage Explorer
I only ever use the storage explorer when managing my blobs, files, queues within storage accounts. It is your single view access point for all your storage needs and...
2019-09-04
77 reads
Use port forwarding to access SQL Server running in Kubernetes
A really handy feature in Kubernetes is port forwarding. This can be used to narrow down an issue when connections are failing to SQL Server running in a cluster....
2019-09-17 (first published: 2019-09-04)
1,012 reads
Use of SQL server statistics and how to make a query to use them
Statistics are very important in the query...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-09-04
206 reads
Using strace inside a SQL Server Container
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-03
18 reads
Using strace inside a SQL Server Container
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-17 (first published: 2019-09-03)
269 reads
Docker Image Tags are Case Sensitive
A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going...
2019-09-03
123 reads
Docker Image Tags are Case Sensitive
A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going...
2019-09-03
290 reads
Speaker at Music City Tech 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
28 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