What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,808 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Why Aren’t You Using SSMS 17?
Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...
2018-07-12 (first published: 2018-07-05)
4,768 reads
Dealing with Disparate Goals
Grant talks about the lessons of history when the goals of different groups don't align.
2018-07-09
84 reads
My Speaking Schedule
I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a...
2018-07-04 (first published: 2018-06-25)
1,650 reads
Plan Metrics Without the Plan: Trace Flag 7412
I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...
2018-06-19 (first published: 2018-06-11)
1,799 reads
Database Fundamentals #17: Learning T-SQL
While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the...
2018-06-18
967 reads
Query To Retrieve Statistics Data: dm_db_stats_histogram
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...
2018-06-11 (first published: 2018-05-29)
2,166 reads
SQL in the City Streamed: June 2018
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...
2018-06-07
273 reads
Extended Events, the system_health Session, and Waits
I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...
2018-06-04
364 reads
Why PASS?
In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...
2018-05-21
715 reads
Blogs
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...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
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