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

Trace Flags in Azure SQL Database

by Grant Fritchey

The Scary DBA

One of the ways that you take more direct control over your SQL Server instances is through the use of...

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

1,219 reads

Argenis Without Borders: Fun For a Good Cause

by Grant Fritchey

The Scary DBA

This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...

2015-10-12

516 reads

Speaker of the Month: October 2015

by Grant Fritchey

The Scary DBA

Working on my third year of “Speaker of the Month” posts now. The good news, I haven’t run out of...

2015-10-02

474 reads

Yes, Foreign Keys Help Performance

by Grant Fritchey

The Scary DBA

I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....

2015-09-21 (first published: 2015-09-09)

2,683 reads

PASS Nominations Committee 2015

by Grant Fritchey

The Scary DBA

The Nominations Committee has done their job and the final report has been published.
Good luck to everyone running. Thank you...

2015-09-14

472 reads

Speaker of the Month: September 2015

by Grant Fritchey

The Scary DBA

Feast or famine.
The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then,...

2015-09-04

455 reads

Targeted Plan Cache Removal

by Grant Fritchey

The Scary DBA

A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing...

2015-09-02 (first published: 2015-08-24)

1,584 reads

Time to Change

by Grant Fritchey

The Scary DBA

I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team...

2015-08-19

756 reads

Generating Estimated Plan and the Plan Cache

by Grant Fritchey

The Scary DBA

Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
No.

What? Still here? You want more?...

2015-08-18 (first published: 2015-08-10)

1,781 reads

PASS Board Update: July 2015

by Grant Fritchey

The Scary DBA

I was actually travelling for most of July and some of that was on holiday with the family, the real...

2015-08-13

587 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