Two more of my presentations
I recently made available two more presentations that you might find helpful. Feel free to download them and present them to others (adding a line that you got them...
2019-04-04
69 reads
MAXDOP, Parallelism and the Cloud
Parallelism and MAXDOP The pros and cons of parallelism have always been with us in SQL Server and I blogged about this a couple of years ago. This is...
2019-04-18 (first published: 2019-04-03)
2,241 reads
It’s a UNIX system. I know this.
Jurassic Park was a great film. Steven Spielberg brought technology into the film era in a major way with computer generated dinosaurs and some now-classic film lines, many of...
2019-04-03
58 reads
Speaker at 24 Hours of PASS – 20 Years of PASS
I’m very happy to announce that for the very first time I will be participating as speaker in the 24 hours of PASS event. This specific instance of 24...
2019-04-03
26 reads
SQL Homework – April 2019 – Practice dealing with corruption
Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of ... Continue reading
2019-04-17 (first published: 2019-04-03)
358 reads
What’s a Key Lookup?
One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...
2019-04-17 (first published: 2019-04-03)
729 reads
SQL in the City Streamed is Today
You can still register, but join me later today for SQL in the City Streamed, along with Grant, Kathi, and Kendra. We’re all in the Redgate Software office today...
2019-04-03
30 reads
File and file group method testing for VLDB very large database
File and file group VLDB very large database....
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-04-03
45 reads
Validation activity in Azure Data Factory - Traffic light of your operational workflow
(2019-Apr-02) Last week Microsoft introduced a new Validation activity task to the Azure Data Factory (ADF) - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-validation-activity Initially, I was confused by its name, thinking that it would help me...
2019-04-16 (first published: 2019-04-03)
11,154 reads
Isolation Levels in SQL Server
Do your eyes start to cross whenever you think about isolation levels? Mine did, too. Here's how I keep it all straight.
2019-04-03
40 reads
Blogs
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...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
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