Ed

Ed Leighton-Dick is a SQL Server performance and architecture expert and Founder/Principal Consultant of Kingfisher Technologies, a consultancy focused on SQL Server performance, architecture, and security. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQL Saturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQL Saturday events, and Iowa Code Camp. Ed can be reached through his blog, edleightondick.com, and on Twitter at @eleightondick.

All authors

Blog Post

Giving back [T-SQL Tuesday #102]

This post is part of the May 2018 T-SQL Tuesday blog challenge, “Giving Back“, from Riley Major. It’s been quite a while since I’ve participated in a T-SQL Tuesday....

2018-05-08

9 reads

Blog Post

Giving back [T-SQL Tuesday #102]

This post is part of the May 2018 T-SQL Tuesday blog challenge, “Giving Back“, from Riley Major. It’s been quite a while since I’ve participated in a T-SQL Tuesday....

2018-05-08

6 reads

Blog Post

Giving back [T-SQL Tuesday #102]

This post is part of the May 2018 T-SQL Tuesday blog challenge, “Giving Back“, from Riley Major. It’s been quite a while since I’ve participated in a T-SQL Tuesday....

2018-05-08

5 reads

All authors

Blogs

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

By

Hello, dear blog reader. Today’s post is coming to you straight from the home...

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

By

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...

Changing the Cardinality of a FK in Redgate Data Modeler

By

One of the things a customer asked recently about Redgate Data Modeler was how...

Read the latest Blogs

Forums

Creating a JSON Document I

By Steve Jones - SSC Editor

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

Who is Irresponsible?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who is Irresponsible?

Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments

By Massimo Preitano

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

Visit the forum

Question of the Day

Creating a JSON Document I

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

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933
If I run this code, what is returned? 
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers