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

Confio Ignite: First Impressions

by Grant Fritchey

The Scary DBA

One of the national sponsors for SQL Satuday is Confio Software. Just because they sponsor SQL Saturday, it’s worth checking out their...

2010-04-06

2,803 reads

nHibernate, First Look at TSQL

by Grant Fritchey

The Scary DBA

I’ve blogged in the past about the nHibernate project that has been going on at my company for the last...

2010-04-05

1,008 reads

Renewed as an MVP

by Grant Fritchey

The Scary DBA

I received my renewal notice and, after checking the message header, it is April 1st, I got very happy. I’d...

2010-04-01

507 reads

SQL Saturday #39 New York

by Grant Fritchey

The Scary DBA

New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...

2010-03-23

551 reads

Undocumented Virtual Column: %%lockres%

by Grant Fritchey

The Scary DBA

One of my development teams needed a mechanism for identifying the value of a key that was part of a...

2010-03-18

4,666 reads

SNESSUG March Meeting

by Grant Fritchey

The Scary DBA

Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our...

2010-03-15

609 reads

Location of the PASS Summit Follow-up

by Grant Fritchey

The Scary DBA

I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision...

2010-03-11

615 reads

Location of the PASS Summit

by Grant Fritchey

The Scary DBA

There has been some discussion recently around the location of the PASS Summit. The debate was centered on the results...

2010-03-10

859 reads

Blog Anniversary

by Grant Fritchey

The Scary DBA

Two years old. In March of 2008 I received a whopping 96 visits. I’m up to 1900 so far this...

2010-03-09

531 reads

MacGyver?

by Grant Fritchey

The Scary DBA

Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com…
Oh, the late eighties… Yeah,...

2010-03-08

674 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