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

Effects of Persisted Columns on Performance

by Grant Fritchey

The Scary DBA

I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...

2015-05-13 (first published: 2015-05-05)

5,931 reads

Speaker of the Month: May 2015

by Grant Fritchey

The Scary DBA

I finally got out to some community events last month and got to see a bunch of great speakers. Not...

2015-05-01

508 reads

Benefits for Some, All or Only a Few

by Grant Fritchey

The Scary DBA

As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...

2015-04-27

512 reads

Azure SQL Database Firewall Settings

by Grant Fritchey

The Scary DBA

The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...

2015-04-24 (first published: 2015-04-13)

5,237 reads

PASS Board Update: April 2015

by Grant Fritchey

The Scary DBA

It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...

2015-04-23

526 reads

Query Hash Formula Changes Between Versions

by Grant Fritchey

The Scary DBA

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...

2015-04-21

619 reads

Azure SQL Database v12 and SQL Magazine

by Grant Fritchey

The Scary DBA

I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...

2015-04-16

681 reads

Constraints and SELECT Statements

by Grant Fritchey

The Scary DBA

I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...

2015-04-16 (first published: 2015-04-06)

7,517 reads

I Am Grateful For

by Grant Fritchey

The Scary DBA

I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts...

2015-04-10

532 reads

Error: Unknown Property ismemoryoptimized

by Grant Fritchey

The Scary DBA

If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one...

2015-04-07

2,063 reads

Blogs

ADF Pipeline Debugging Fails with BadRequest – The Sequel

By Koen Verbeeck

A while ago I blogged about a use case where a pipeline fails during...

Why I stopped using MCP for AI coding stuff

Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...

AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning

By Vinay Thakur

Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...

Read the latest Blogs

Forums

Dynamic Unpivot

I have a table I didn't design that has tons of repeating groups in...

Writing as an Art and a Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing as an Art and...

String Similarity II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item String Similarity II

Visit the forum

Question of the Day

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

See possible answers