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

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,208 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,816 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

722 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

616 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

915 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

745 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

735 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

973 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

720 reads

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,822 reads

Blogs

Keeping Redshift System Table History Past 7 Days with S3 Tables

By Eduardo Pivaral

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...

Updating the Data API Builder

I was updating my session for the Data API Builder (DAB) recently, mostly to...

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

By MarlonRibunal

I am excited to host T-SQL Tuesday for the first time. I want to...

Read the latest Blogs

Forums

advice on ssrs version control

Hi we're a bit behind on versioning ssrs. I think we have over 1600...

Practical Ways to Approach SQL Server Problems and Case Studies

By academicexpertt

Working with SQL Server can involve more than just writing queries. Understanding database design,...

Measuring Productivity

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Measuring Productivity

Visit the forum

Question of the Day

Tracking All the Queries

I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?

See possible answers