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

Steve Jones to Run for PASS Board

by Grant Fritchey

The Scary DBA

I couldn’t hide the lead. Steve Jones (blog|twitter) has announced he’s running for the PASS board. I’m excited. I’m almost as...

2010-07-16

942 reads

In the Clouds

by Grant Fritchey

The Scary DBA

The July meeting for the Southern New England SQL Server Users Group is tonight. Andrew Novick will be talking about...

2010-07-14

801 reads

Red Gate SQL Source Control

by Grant Fritchey

The Scary DBA

You just have to love Red Gate tools. They find the small area that they want to cover and then...

2010-07-14

1,860 reads

Delivering the Bad News

by Grant Fritchey

The Scary DBA

It’s a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week,...

2010-07-09

714 reads

Small PowerShell Script

by Grant Fritchey

The Scary DBA

I’m still trying to learn PowerShell better. The opportunity to answer simple questions and problems with the tool is hard...

2010-07-06

1,190 reads

One of these things is not like the other

by Grant Fritchey

The Scary DBA

I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later,...

2010-06-30

2,076 reads

Powershell Fundamentals

by Grant Fritchey

The Scary DBA

I’ve had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell...

2010-06-25

2,102 reads

Learning Powershell

by Grant Fritchey

The Scary DBA

I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware...

2010-06-23

1,694 reads

Sarasota SQL Server Users Group

by Grant Fritchey

The Scary DBA

Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...

2010-06-15

708 reads

Virtualizing Servers in Production

by Grant Fritchey

The Scary DBA

The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...

2010-06-15

861 reads

Blogs

In Memory of Andrew Clarke, AKA Phil Factor

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

Leading Through the Noise: Harnessing Data in the Age of Digital Overload

The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....

A New Word: Anderance

anderance – n. the awareness that your partner perceives the relationship from a totally...

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