Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
2019-04-24
326 reads
Interview with Andre Melancia
This is my second interview! This time with Andre who is a cat lover and great speaker! Here you can find the interview!
2019-04-24
46 reads
Should release cadence be slowed if you don’t have database load testing?
I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development...
2019-04-23
15 reads
CISA Accredited Trainer!
My certification came in! I’m now accredited to provide training for the Certified Information Systems Auditor (CISA) certification. It’s not the Microsoft Certified Trainer (MCT) accreditation I once had...
2019-04-23
38 reads
Correlated Subqueries vs Derived Tables
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for every value they join on....
2019-05-07 (first published: 2019-04-23)
1,730 reads
Correlated Subqueries vs Derived Tables
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
20 reads
Correlated Subqueries vs Derived Tables
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
11 reads
Video – Creating Azure SQL Database
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
41 reads
Weekly reading #12
It was an Easter Monday yesterday and I thought it was not a good time to prepare a blog post. It was a time to rest with the family...
2019-04-22
17 reads
Speaking at SQL Saturday Raleigh
I am happy to announce that I will be speaking at SQL Saturday Raleigh this Saturday, April 27, 2019. I have been part of the organizing team for this...
2019-04-22
14 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