John

John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. John has passion around speaking, teaching technical topics and giving back to the technical community. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, http://sqlrus.com.

All authors

Blog Post

I’m Speaking!

After a long hiatus of not blogging, I’m trying to get back into writing.  So, to kick it off first thing in 2024, I’m speaking! I’m honored to have been...

2024-01-19

17 reads

Blog Post

Secure Travel

Last Updated on March 4, 2022 by John Morehouse Update: This post was originally published on March 8th, 2019 and a lot of things have changed over the last...

2022-03-04

57 reads

All authors

Blogs

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

Beware of Generic SQL Server License Keys (What to Use Instead)

By

Beware of Generic SQL Server License Keys (What to Use Instead) ...

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