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

Implicit Conversion and Performance

by Grant Fritchey

The Scary DBA

Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...

2016-05-03

596 reads

How to Convince the Boss to Send You to PASS Summit

by Grant Fritchey

The Scary DBA

August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...

2016-05-02

973 reads

Customizing Your Azure Portal

by Grant Fritchey

The Scary DBA

Not all of us are going to use Azure in the same way. That’s just common sense. Therefore, not all...

2016-04-27

1,835 reads

Microsoft’s Commitment to Azure

by Grant Fritchey

The Scary DBA

For several years, many of us who were involved with working in Azure from the early days, were concerned that...

2016-04-21

525 reads

Payment and the Board

by Grant Fritchey

The Scary DBA

If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and...

2016-04-20

483 reads

A View Is Not A Table

by Grant Fritchey

The Scary DBA

Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...

2016-04-19 (first published: 2016-04-12)

3,132 reads

Query Store and Optimize For Ad Hoc

by Grant Fritchey

The Scary DBA

I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...

2016-04-11 (first published: 2016-03-28)

1,930 reads

Views and Simplification

by Grant Fritchey

The Scary DBA

I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...

2016-04-05

549 reads

Speaker of the Month: April 2016

by Grant Fritchey

The Scary DBA

THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...

2016-04-01

492 reads

Do You Teach Azure Data Platform?

by Grant Fritchey

The Scary DBA

I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....

2016-03-29

813 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