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

Microsoft Teched 2013 Keynote

by Grant Fritchey

The Scary DBA

Welcome to Teched 2013
We’re starting off with some type of James Bond video. Chase scene with a really cool car....

2013-06-03

874 reads

Using PowerShell to move files to Azure Storage

by Grant Fritchey

The Scary DBA

I was searching all over the place to try to find out how to move files into Azure Storage. Most...

2013-06-03

2,375 reads

Painting the US Red

by Grant Fritchey

The Scary DBA

We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.
This...

2013-05-29

816 reads

SMO vs Invoke-Sqlcmd in Azure

by Grant Fritchey

The Scary DBA

I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...

2013-05-28

1,070 reads

A Little Azure Fun on Friday

by Grant Fritchey

The Scary DBA

You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions...

2013-05-24

726 reads

Azure does Powershell too

by Grant Fritchey

The Scary DBA

Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...

2013-05-23 (first published: 2013-05-20)

1,935 reads

PASS Summit 2013 is Looking Cloudy

by Grant Fritchey

The Scary DBA

No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...

2013-05-22

655 reads

Microsoft Lync Through the Web

by Grant Fritchey

The Scary DBA

Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...

2013-05-21

782 reads

How to Tell Your Windows Azure SQL Database Moved

by Grant Fritchey

The Scary DBA

The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies...

2013-05-13 (first published: 2013-05-07)

1,581 reads

Book Review: Business in the Trenches

by Grant Fritchey

The Scary DBA

I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...

2013-05-09

733 reads

Blogs

Identity Columns Can’t Be Updated: #SQLNewBlogger

I’m not sure I knew identity column values could not be updated. I ran...

Rolling Back a Broken Release

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By ChrisJenkins

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Read the latest Blogs

Forums

Can someone please explain what happens?

I have mentioned this several times over several years. Can someone please help me...

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?

See possible answers