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

Speaker of the Month, March 2014

by Grant Fritchey

The Scary DBA

This never gets easier. I was able to attend a bunch of sessions in the last month from a number...

2014-03-07

873 reads

Approachable? Sometimes.

by Grant Fritchey

The Scary DBA

Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...

2014-03-06 (first published: 2014-02-25)

1,846 reads

SQL Intersection, Spring 2014

by Grant Fritchey

The Scary DBA

I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting...

2014-03-04 (first published: 2014-02-26)

1,634 reads

Let’s Talk Query Tuning

by Grant Fritchey

The Scary DBA

I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...

2014-02-27

1,282 reads

The CASE Statement and Performance

by Grant Fritchey

The Scary DBA

In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...

2014-02-25 (first published: 2014-02-18)

6,542 reads

SQL Server 2014 and the New Cardinality Estimator

by Grant Fritchey

The Scary DBA

Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...

2014-02-12

1,170 reads

Book Review: The Phoenix Project

by Grant Fritchey

The Scary DBA

Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...

2014-02-11 (first published: 2014-02-05)

1,931 reads

Speaker of the Month, February 2014

by Grant Fritchey

The Scary DBA

I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...

2014-02-07

709 reads

Thank You!

by Grant Fritchey

The Scary DBA

I am humbled and honored (and more than a little horrified) to be on this list of the Best of...

2014-02-06

702 reads

Time for a Quick Rant

by Grant Fritchey

The Scary DBA

This is an actual quote from what we can only assume is a functional human being:
The database is very big...

2014-01-20

699 reads

Blogs

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers