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

Book Review: Connected

by Grant Fritchey

The Scary DBA

I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?)....

2015-05-29 (first published: 2015-05-19)

5,087 reads

PASS Board Update: May 2015

by Grant Fritchey

The Scary DBA

I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...

2015-05-27

540 reads

Database Engine Tuning Advisor

by Grant Fritchey

The Scary DBA

I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...

2015-05-26

818 reads

Is Performance Better With LEFT JOIN or RIGHT JOIN?

by Grant Fritchey

The Scary DBA

I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...

2015-05-20 (first published: 2015-05-11)

7,045 reads

I Am Grateful For…

by Grant Fritchey

The Scary DBA

I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...

2015-05-15

499 reads

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,927 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

507 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

508 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,234 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

519 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