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

24 Hours of PASS, Fall 2012

by Grant Fritchey

The Scary DBA

It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...

2012-08-22

691 reads

Coming to Your Town

by Grant Fritchey

The Scary DBA

I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...

2012-08-16

1,168 reads

Being Right, the Other Side

by Grant Fritchey

The Scary DBA

I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...

2012-08-15

842 reads

Execution Plans … In the Cloud!

by Grant Fritchey

The Scary DBA

If you’re moving to a fully-fledged SQL database as part of Azure you may never even touch SQL Server Management...

2012-08-10 (first published: 2012-08-01)

2,723 reads

SQL In The City: London 2012, Recap

by Grant Fritchey

The Scary DBA

Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...

2012-07-17 (first published: 2012-07-16)

2,088 reads

Does Encryption Affect Seeing Statements in Deadlock Graphs?

by Grant Fritchey

The Scary DBA

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...

2012-07-03 (first published: 2012-06-25)

2,256 reads

Querying Information from the Plan Cache, Simplified

by Grant Fritchey

The Scary DBA

One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...

2012-07-02

1,501 reads

The New Phone Book Is Here!

by Grant Fritchey

The Scary DBA

I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....

2012-06-27

1,600 reads

Problems with my new book

by Grant Fritchey

The Scary DBA

First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...

2012-06-26

834 reads

PASS Summit 2012

by Grant Fritchey

The Scary DBA

I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....

2012-06-19

787 reads

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

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

March 2026 SQL Server Security Updates

By Brian Kelley

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

How Fabric Mirroring Transformed with SQL Server 2025

By Meagan Longoria

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

Read the latest Blogs

Forums

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...

Upgrading Admin Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrading Admin Queries

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