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

Approachable? Sometimes.

by Grant Fritchey

The Scary DBA

Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...

2014-03-06 (first published: 2014-02-25)

1,846 reads

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,634 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,281 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,541 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,169 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,930 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

708 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

698 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,192 reads

Blogs

SQL, MDX, DAX – the languages of data

By DataOnWheels

Ramblings of a retired data architect Let me start by saying that I have...

Setting PK Names in Redgate Data Modeler

A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....

Flyway Tips: AI Deployment Script Descriptions

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

Read the latest Blogs

Forums

Connecting Power BI to SSAS and effective user not working

By Paul Hernández

Hi everyone, Below is a consolidated summary of what we validated Architecture & data...

High Availability setup - has anyone seen this method?

By Paul Lancaster

Hi all, I recently moved to a new employer who have their HA setup...

Semantic Search in SQL Server 2025

By Deepam Ghosh

Comments posted to this topic are about the item Semantic Search in SQL Server...

Visit the forum

Question of the Day

Encoding URLs

I have this data in a SQL Server 2025 table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO

If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?

See possible answers