Execution Plan Metrics and Units of Measure
Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...
2017-12-26 (first published: 2017-12-11)
1,443 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
SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations
In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...
2017-12-26
816 reads
Query Store Wait Statistics with sys.query_store_wait_stats
The second best thing to questions that people ask is when I sit down to write a book. It’s so...
2017-12-18
734 reads
Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,255 reads
Database Fundamentals #15: Modifying Data With T-SQL
The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...
2017-12-11 (first published: 2017-11-27)
1,804 reads
SQL in the City 2017
Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...
2017-12-08
318 reads
Why I Use AdventureWorks for Demos
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
377 reads
Get That Profiler Feel in Extended Events
I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...
2017-11-29 (first published: 2017-11-20)
1,400 reads
I May Never Be a Data Scientist
Chances are extremely high that I’ll never put down Data Scientist as my job. Considering what you do and what...
2017-11-22
405 reads
Presenting Azure Vs. Working With Azure
I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and...
2017-11-15
304 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