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 Cruise: Alaska 2017

by Grant Fritchey

The Scary DBA

We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more....

2017-08-01 (first published: 2017-07-19)

1,784 reads

There Is a Magic Button, a Rant

by Grant Fritchey

The Scary DBA

OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...

2017-08-01

477 reads

There Is a Magic Button, a Rant

by Grant Fritchey

The Scary DBA

OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...

2017-08-01

219 reads

Being a Positive Influencer

by Grant Fritchey

The Scary DBA

I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...

2017-07-31

350 reads

Database Fundamentals #5: Database Properties

by Grant Fritchey

The Scary DBA

Don’t let the ease of creating databases lull you into a false sense of security. They actually can be very...

2017-07-31 (first published: 2017-07-17)

2,260 reads

Database Fundamentals #6: Create a Table with the SSMS GUI

by Grant Fritchey

The Scary DBA

The whole idea behind databases is to store information, data, in order to look at it later. The place where...

2017-07-24

526 reads

The Choices We Make

by Grant Fritchey

The Scary DBA

If you keep your head up and look around you’ll see the choices people make all the time. I saw...

2017-07-21 (first published: 2017-07-10)

1,964 reads

Thoughts on the State of Data Management

by Grant Fritchey

The Scary DBA

I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share...

2017-07-18

298 reads

I Love Entity Framework

by Grant Fritchey

The Scary DBA

I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling...

2017-07-17 (first published: 2017-07-05)

2,775 reads

Database Fundamentals #4: Create a Database

by Grant Fritchey

The Scary DBA

SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works...

2017-07-06 (first published: 2017-06-26)

1,989 reads

Blogs

Azure SQL Managed Instance Next-Gen: Bring on the IOPS

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...

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....

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