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

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

508 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

512 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,237 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

526 reads

Query Hash Formula Changes Between Versions

by Grant Fritchey

The Scary DBA

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...

2015-04-21

619 reads

Azure SQL Database v12 and SQL Magazine

by Grant Fritchey

The Scary DBA

I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...

2015-04-16

681 reads

Constraints and SELECT Statements

by Grant Fritchey

The Scary DBA

I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...

2015-04-16 (first published: 2015-04-06)

7,517 reads

I Am Grateful For

by Grant Fritchey

The Scary DBA

I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts...

2015-04-10

532 reads

Error: Unknown Property ismemoryoptimized

by Grant Fritchey

The Scary DBA

If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one...

2015-04-07

2,063 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