Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

Blog Post

Query Store Reports Time Intervals

A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...

2023-11-24 (first published: )

197 reads

SQLServerCentral Editorial

You Never Know

I'm writing this sitting at the PASS Data Community Summit. It's been a fantastic event. I gave a community session on Azure DevOps. I was able to help Redgate launch a new product. I've received a bunch of hugs from VERY dear old friends. I've met a ton of people. It's been great. Allow me […]

5 (3)

You rated this post out of 5. Change rating


57 reads

SQLServerCentral Editorial

Celebrate THEIR Accomplishments

I can't hide this in any way. I love it when I accomplish something. It's such a great feeling. Even more than that, I really do love getting some acknowledgement for it. Almost as good, is when I see others, especially friends and acquaintances, doing well. So many people I know, regularly just knock it […]

You rated this post out of 5. Change rating


47 reads

SQLServerCentral Editorial

Gentlest of Reminders, Don't Stop Learning

I was on the road for just over two weeks. I was able to travel around to a few places and present some sessions. But, better than that, thanks to SQL Konferenz, I was able to go to a couple of sessions and learn some stuff. I'm lucky/cursed in my position at Redgate. We have […]

5 (1)

You rated this post out of 5. Change rating


88 reads

SQLServerCentral Editorial

Be Prepared

I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people. It also inspired me to do another check on our emergency supplies and equipment. No, we don't […]

5 (2)

You rated this post out of 5. Change rating


84 reads

SQL Server Execution Plans eBook, Third Edition, by Grant Fritchey

SQL Server Execution Plans, Third Edition, by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance.

5 (3)

You rated this post out of 5. Change rating

2023-08-16 (first published: )

5,250 reads


Extended Events in Azure Data Studio


I know I can use extended events (xevents) in Azure SQL DB when in...

Azure Workbooks


I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet


A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

Read the latest Blogs


Creating Aggregates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Aggregates

Getting Started with DDL statements of Cassandra Query Language

By Shivayan Mukherjee

Comments posted to this topic are about the item Getting Started with DDL statements...

The Balanced Technical Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Balanced Technical Manager

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers