Data experiments with salary survey – I
As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how...
2018-03-22 (first published: 2018-03-12)
2,733 reads
Mala's Data Blog
My experience with TechOutbound 2018 – Caribbean
I am a passionate, regular attendee of Techoutbound (formerly SQLCruise) events. I try to do at least one every year. ...
2018-02-26
378 reads
DBA best practices..from the DBA from Heaven
I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right...
2018-02-01
691 reads
SQL Saturday Nashville 2018
I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in...
2018-01-15
444 reads
T-SQL Tuesday #97 Roundup: Learning goals for 2018
T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this...
2017-12-18
819 reads
T-SQL Tuesday #97 – My learning plan
This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December...
2017-12-25 (first published: 2017-12-11)
2,387 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!T-SQL Tuesday is the brainchild of well respected SQL Guru...
2017-12-04
950 reads
TSQL Tuesday #96 – Folks who have made a difference
This month’s T-SQL Tuesday is hosted by Ewald Cress, and the topic is ‘Folks who have made a difference’. This...
2017-11-14
432 reads
Dealing with disquiet
Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In...
2017-11-23 (first published: 2017-11-11)
1,964 reads
PASS Summit 2017 – the best ever
I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different...
2017-11-05
708 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