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.

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

Extended Events and Stored Procedure Parameter Values

by Grant Fritchey

The Scary DBA

One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently...

2018-09-24

501 reads

3rd Edition, SQL Server Execution Plans, a Story

by Grant Fritchey

The Scary DBA

Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update...

2018-09-21 (first published: 2018-09-12)

1,892 reads

Estimated Plans and Forced Plans from Query Store

by Grant Fritchey

The Scary DBA

While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a...

2018-09-20 (first published: 2018-09-10)

1,764 reads

Databases and DevOps, It’s Not Just Me

by Grant Fritchey

The Scary DBA

Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows...

2018-09-19

309 reads

Announcing the 5th Edition of SQL Server 2017 Query Performance Tuning

by Grant Fritchey

The Scary DBA

I am quite excited to announce that the latest, most up to date, and by far the largest, copy of...

2018-09-18

328 reads

Query Store and Log Backups

by Grant Fritchey

The Scary DBA

A question that came up recently around Query Store is what happens when there are log backups in use on...

2018-09-17

220 reads

Rant: There Is No NoSQL Data Storage Engine

by Grant Fritchey

The Scary DBA

Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or...

2018-09-07 (first published: 2018-08-15)

2,862 reads

Back to University, Redgate University

by Grant Fritchey

The Scary DBA

Let’s be really clear, Redgate makes ingeniously simple tools. That’s a fact. Nothing has changed. However, if you really want...

2018-09-03

281 reads

SQL in the City Summit

by Grant Fritchey

The Scary DBA

This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New...

2018-09-03 (first published: 2018-08-21)

1,466 reads

Measuring Query Execution Time: What Is Most Accurate

by Grant Fritchey

The Scary DBA

Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...

2018-08-28 (first published: 2018-08-13)

2,720 reads

Blogs

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

Hello, dear blog reader. Today’s post is coming to you straight from the home...

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...

Changing the Cardinality of a FK in Redgate Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how...

Read the latest Blogs

Forums

Removing TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE

Poor Names

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Comments posted to this topic are about the item The day-to-day pressures of a...

Visit the forum

Question of the Day

Removing TDE

How do I remove TDE encryption of data from database xxx?

See possible answers