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/

SQL Intersection, Spring 2014

by Grant Fritchey

The Scary DBA

I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting...

2014-03-04 (first published: 2014-02-26)

1,628 reads

Let’s Talk Query Tuning

by Grant Fritchey

The Scary DBA

I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...

2014-02-27

1,278 reads

The CASE Statement and Performance

by Grant Fritchey

The Scary DBA

In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...

2014-02-25 (first published: 2014-02-18)

6,524 reads

SQL Server 2014 and the New Cardinality Estimator

by Grant Fritchey

The Scary DBA

Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...

2014-02-12

1,163 reads

Book Review: The Phoenix Project

by Grant Fritchey

The Scary DBA

Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...

2014-02-11 (first published: 2014-02-05)

1,923 reads

Speaker of the Month, February 2014

by Grant Fritchey

The Scary DBA

I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...

2014-02-07

706 reads

Thank You!

by Grant Fritchey

The Scary DBA

I am humbled and honored (and more than a little horrified) to be on this list of the Best of...

2014-02-06

701 reads

Time for a Quick Rant

by Grant Fritchey

The Scary DBA

This is an actual quote from what we can only assume is a functional human being:
The database is very big...

2014-01-20

697 reads

Database in Source Control

by Grant Fritchey

The Scary DBA

Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...

2014-01-15

1,189 reads

Sausage Making

by Grant Fritchey

The Scary DBA

For those who don’t know, I work for Red Gate Software. I’m not a developer, but I work directly for...

2014-01-15 (first published: 2014-01-08)

2,035 reads

Blogs

SQL Training: Black Friday Deals Up to 75% Off

By Tracy McKibben

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

When is the perfect moment to build a data strategy in a company?

By Joyful-Craftsmen

The post When is the perfect moment to build a data strategy in a...

How to Run Databases on Kubernetes: An 8-Step Guide

By Ige Adetokunbo Temitayo

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Read the latest Blogs

Forums

Rebuild Index Job on a Large DB

We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...

Authentication Error 0x8009030c

Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....

how to stop command prompt window from appearing when running PowerShell script?

Hi everyone I have a PowerShell script that is run by Execute Process Task...

Visit the forum

Question of the Day

Renaming a Database

If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)

See possible answers