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

12 Days of SQL, On the 2nd Day of SQL…

by Grant Fritchey

The Scary DBA

Microsoft gave to me, an excellent new management language. Yeah, so it doesn’t rhyme or match the song in any...

2010-12-10

780 reads

SQL Saturday New England, #71

by Grant Fritchey

The Scary DBA

I’ve finally got everything together to get the web site going for SQL Saturday #71. The call for speakers is...

2010-12-09

586 reads

So you want to write a book

by Grant Fritchey

The Scary DBA

I had posted a while back on the process of book writing. It was an attempt to educate while scaring...

2010-12-08

688 reads

Review: Idera SQL Doctor

by Grant Fritchey

The Scary DBA

Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...

2010-12-06

2,605 reads

SQL Spackle

by Grant Fritchey

The Scary DBA

I previously mentioned how SQL Server Central was listing ideas for articles, primarily for short, quick, pointed articles that they...

2010-12-02

1,197 reads

Regressions

by Grant Fritchey

The Scary DBA

Hannah Dustin, Upset about Regression
One of the most important take-aways from David Dewitt’s presentation at the PASS Summit was the...

2010-11-30

1,620 reads

FreeCon

by Grant Fritchey

The Scary DBA

I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...

2010-11-24

1,611 reads

Do Foreign Key Constraints Help Performance?

by Grant Fritchey

The Scary DBA

Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...

2010-11-22

1,699 reads

Un-SQL Friday: Branding?

by Grant Fritchey

The Scary DBA

Following in Midnight DBA’s more interesting half new blog fest topic.
My branding? I don’t have a clue. There, I said...

2010-11-19

662 reads

Reason for Early Termination of Statement

by Grant Fritchey

The Scary DBA

Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...

2010-11-18

3,042 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

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

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

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