Visualizing Hash Match Join Internals And Understanding Their Implications
This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).
Watch...
2019-01-02
2 reads
Blog Posts
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
2 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
4 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as...
2019-01-01
992 reads
An error occurred while writing an audit trace. SQL Server is shutting down
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...
2019-01-01
19 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
22 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
415 reads
Happy 2019!
As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year ??...
2019-01-01
7 reads
SQL Server Backup To Azure Storage
Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL...
2019-01-01 (first published: 2018-12-19)
2,738 reads
SSIS Catalog Automatic Log Cleanup
Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time....
2019-01-01 (first published: 2018-12-19)
2,450 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers