Ten Essential Traits for DBA Success
There is greatness within you whether you believe it or not. Over the years there are certain skills that have...
2016-08-31 (first published: 2016-08-23)
2,267 reads
The SQL Professor
Are SQL Saturday’s Worth It?
This past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held...
2016-08-18 (first published: 2016-08-12)
1,674 reads
T-SQL Tuesday #080–Round Up
The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month...
2016-07-19
358 reads
T-SQL Tuesday #080
T-SQL Tuesday time is here again! And I’m honored to be hosting this months block party. Why you ask? T-SQL...
2016-07-07
916 reads
Is Today Your Last Day Working With SQL?
Please entertain this thought for a moment – If today was your last day working with SQL how would you spend...
2016-07-08 (first published: 2016-06-29)
3,326 reads
Interview with Warwick Rudd
Part of traveling to various events and being a part of the SQL Community means one can meet some pretty...
2016-05-09 (first published: 2016-04-26)
1,008 reads
The Next Chapter ~ A SQL Journey
The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”....
2016-04-14
410 reads
Time Management–Leadership
To many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails...
2016-03-16
484 reads
T-SQL Tuesday #75 Invitation: Jump into Power BI!
This month the talented Jorge Segarra (B|T) hosts the T-SQL Tuesday block party, and he has chosen the topic of...
2016-02-16
488 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,799 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