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.

All authors

Blog Post

I’m a Pain

Or maybe I’m misreading that I’m supposed to be helping to alleviate pain. Either way, next Thursday, June 17, I’ll be...

2010-06-10

555 reads

All authors

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

data compare between 2 tables with same structure for any changes after etl run

By syam.tunuguntla

i have huge table with lot of data and is also wide. i took...

Creating a JSON Document II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document II

Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Backing Up Azure Key Vault...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table: 

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned? 
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers