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

Extended Events, the system_health Session, and Waits

by Grant Fritchey

The Scary DBA

I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...

2018-06-04

356 reads

Why PASS?

by Grant Fritchey

The Scary DBA

In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...

2018-05-21

707 reads

When Simple Parameterization…Isn’t

by Grant Fritchey

The Scary DBA

I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...

2018-05-16 (first published: 2018-05-07)

2,575 reads

A View Will Not Make Your Query Faster

by Grant Fritchey

The Scary DBA

Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...

2018-05-14

307 reads

YouTube Channel Update: 11 May 2018

by Grant Fritchey

The Scary DBA

I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...

2018-05-11

228 reads

Automating Automatic Indexing in Azure SQL Database

by Grant Fritchey

The Scary DBA

I’ve been in love with the concept of a database as a service ever since I first laid eyes on...

2018-05-07 (first published: 2018-04-30)

1,936 reads

YouTube Channel Update: 27 April 2018

by Grant Fritchey

The Scary DBA

Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...

2018-04-27

467 reads

Execution Plan Shortcoming in Extended Events

by Grant Fritchey

The Scary DBA

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...

2018-04-26 (first published: 2018-04-16)

1,617 reads

Presentation Tools

by Grant Fritchey

The Scary DBA

Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through...

2018-04-23

294 reads

GDPR, Database Backups, and the Right to be Forgotten

by Grant Fritchey

The Scary DBA

I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...

2018-04-20 (first published: 2018-04-09)

3,431 reads

Blogs

A Prompt AI Experiment

Prompt AI released recently and I decided to try a few things with the...

Scaling PowerShell – Lessons from a Technical Interview

Recently, I was in a technical interview where the topic of running PowerShell at...

Installing Old Versions of PowerShell Modules with Their Dependencies

I don’t recall where this came up (probably in SQLSlack), but I had a...

Read the latest Blogs

Forums

how to get notification that my database has corssed 8gb

By rajemessage 14195

i have sqlexpress on rds, is there any way i can get notifacation that...

SQL Server, Heaps and Fragmentation

Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation

Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

SQL Server, Heaps and Fragmentation

A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?

See possible answers