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

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

610 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

679 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,512 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

530 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,060 reads

Does the New Cardinality Estimator Reduce Bad Parameter Sniffing

by Grant Fritchey

The Scary DBA

No. Next question.
Although, that answer can be slightly, ever so slightly, nuanced…
Parameter sniffing is a good thing. But, like a...

2015-04-06 (first published: 2015-03-30)

7,268 reads

Speaker of the Month: April 2015

by Grant Fritchey

The Scary DBA

One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...

2015-04-03

603 reads

Simple Parameterization and Data Types

by Grant Fritchey

The Scary DBA

Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the...

2015-04-02 (first published: 2015-03-24)

6,972 reads

PASS Board Update: March 2015

by Grant Fritchey

The Scary DBA

Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...

2015-03-31

1,090 reads

Toshiba Portege Z301-A Review

by Grant Fritchey

The Scary DBA

Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as...

2015-03-25

605 reads

Blogs

The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

By Monica Rathbun

Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...

A Prompt AI Experiment

Prompt AI released recently and I decided to try a few things with the...

SQL Server Is Slow (part 1 of 4)

How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...

Read the latest Blogs

Forums

statistics callection intervel in query store ?

By rajemessage 14195

Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...

Rounding Off issue in SQL Server

By vikramchander90

I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...

how to get notification that my database has corssed 8gb

By rajemessage 14195

i have sqlexpress on rds, is there any way i can get notifacation that...

Visit the forum

Question of the Day

SQL Server, Heaps and Fragmentation

A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?

See possible answers