Who is cjsommer?
I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...
2015-03-24
259 reads
Blog Posts
0 to Speaker
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...
2015-03-23
699 reads
Exam Prep 70-463: Executing packages in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-23
1,071 reads
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...
2015-03-23
2,290 reads
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
684 reads
How to resolve Space issue in SQL server 2005 TIP #93
Hello friends,
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more...
2015-03-23
769 reads
New SQL Server Blog Author Challenge
My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back...
2015-03-23
461 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-23 (first published: 2015-03-16)
7,891 reads
Selected as a PernixPro
Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to...
2015-03-23
409 reads
Speaking at SQL Saturday #389 – Huntington Beach
I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM...
2015-03-23
911 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
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
A while back I wrote a quick post on setting up key mappings in...
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
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers