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

SQL Saturday #39, New York, New York

by Grant Fritchey

The Scary DBA

A town so big they named it twice.
If you’re not excited about SQL Saturday in NYC this weekend… why not?...

2010-04-20

508 reads

Powershell Script for Verifying Space

by Grant Fritchey

The Scary DBA

First let me say, I know my Powershell skills are sub-par. I’m working on it. Slowly but surely. That said,...

2010-04-19

1,198 reads

Confio Ignite: Part II

by Grant Fritchey

The Scary DBA

I’m continuing to evaluate Confio’s Ignite database monitoring tool. I’ve had it collecting data on a couple of production servers...

2010-04-16

1,807 reads

Powershell SMO Problem

by Grant Fritchey

The Scary DBA

We’ve been running the Enterprise Policy Management tools available from Codeplex for a few months now (Thanks to Buck Woody’s...

2010-04-16

710 reads

SNESSUG 4/14/2010

by Grant Fritchey

The Scary DBA

Tonight’s Southern New England SQL Server Users group is sponsored by Idera. Our presenter is Scott Abrants of Iron Mountain....

2010-04-14

612 reads

The SQL Server Community

by Grant Fritchey

The Scary DBA

I attended, and spoke at, the inaugural meeting of the Seacoast SQL Server User’s group last night. There were about...

2010-04-14

911 reads

Southern New England SQL Server Users Group

by Grant Fritchey

The Scary DBA

Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on...

2010-04-13

737 reads

Seacoast SQL Users Group

by Grant Fritchey

The Scary DBA

Tomorrow is the Seacost SQL Server User’s Group inaugural meeting. I’ll be presenting a session called “Understanding Execution Plans.” It’s...

2010-04-12

731 reads

Thoughts on ORM

by Grant Fritchey

The Scary DBA

I’ve posted before about issues I’m having either with behaviors of nHibernate, or behaviors of teams using nHibernate, but I...

2010-04-09

963 reads

24 Hours of PASS v2.0

by Grant Fritchey

The Scary DBA

The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...

2010-04-06

710 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