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

Input Into Azure Data Studio

by Grant Fritchey

The Scary DBA

I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going...

2019-02-15 (first published: 2019-01-28)

1,797 reads

Query Store and a READ_ONLY Database

by Grant Fritchey

The Scary DBA

What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is...

2019-02-11

2 reads

Combine Extended Events and TagWith to Monitor Entity Framework

by Grant Fritchey

The Scary DBA

I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is...

2019-02-04

10 reads

Combine Extended Events and TagWith to Monitor Entity Framework

by Grant Fritchey

The Scary DBA

I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer,...

2019-02-04

161 reads

Opening a Twitch Channel, Data Wisdom

by Grant Fritchey

The Scary DBA

I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...

2019-01-29

2 reads

Opening a Twitch Channel, Data Wisdom

by Grant Fritchey

The Scary DBA

I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here....

2019-01-29

181 reads

All Day, Training Day at SQLBits

by Grant Fritchey

The Scary DBA

It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February...

2019-01-23

227 reads

DevOps and Automation Will Eliminate the DBA

by Grant Fritchey

The Scary DBA

I’ve been reading about the death of the DBA ever since I first made the jump from full time developer...

2019-01-23 (first published: 2019-01-14)

2,683 reads

Critiquing Grant Fritchey: Circa 2008

by Grant Fritchey

The Scary DBA

For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of...

2019-01-22

159 reads

Get Your Learn On

by Grant Fritchey

The Scary DBA

There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...

2019-01-21

153 reads

Blogs

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

In Memory of Andrew Clarke, AKA Phil Factor

One of the parts of getting older that really sucks is I seem to...

Read the latest Blogs

Forums

taking the rcsi dive

Hi, we put together an extract that runs every 15 minutes against what i...

Parameter Sensitive Plan Optimization in SQL Server 2022

By Deepam Ghosh

Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...

Minimum Change Tracking Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimum Change Tracking Retention

Visit the forum

Question of the Day

Minimum Change Tracking Retention

If I am running this code:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);

What is the minimum amount of time I can set?

See possible answers