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

Developers Rate Azure One of Their Favorite Tools

by Grant Fritchey

The Scary DBA

Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...

2013-09-09

1,269 reads

Speaker of the Month: September 2013

by Grant Fritchey

The Scary DBA

This is my second post in what I hope will be an ongoing series. You can see the rules for...

2013-09-06

863 reads

sp_executesql, Parameters and Parameter Sniffing

by Grant Fritchey

The Scary DBA

I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess...

2013-09-05

1,528 reads

Azure Capabilities Expand

by Grant Fritchey

The Scary DBA

But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...

2013-09-04

625 reads

My Next Phone May Be a Nokia

by Grant Fritchey

The Scary DBA

I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...

2013-09-03

544 reads

Make the PASS Summit Work For Your Employer

by Grant Fritchey

The Scary DBA

It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy...

2013-09-02 (first published: 2013-08-26)

1,958 reads

One for My SQL Sisters

by Grant Fritchey

The Scary DBA

Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I...

2013-08-30

1,786 reads

Windows Azure SQL Database and Throttling

by Grant Fritchey

The Scary DBA

When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept...

2013-08-29

1,532 reads

Learn Query Tuning in Dallas

by Grant Fritchey

The Scary DBA

I am excited to be able to tell you about an all day seminar that I’ll be putting on prior...

2013-08-28

639 reads

Check Your Azure Account Usage

by Grant Fritchey

The Scary DBA

It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people...

2013-08-27

784 reads

Blogs

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

Presenting with Visual Studio Code

By Andrew Pruski

A while back I wrote a quick post on setting up key mappings in...

Read the latest Blogs

Forums

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

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

Creating JSON III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON III

Testing is Becoming More Important

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Testing is Becoming More Important

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