May Question: What is your favorite DBA joke?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-05-04
822 reads
Blog Posts
Nominations for the 2010 Exceptional DBA Award are Now Open
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the 2010 Exceptional DBA Awards are now...
2010-05-04
1,553 reads
PASS Update #31 (Election Prep)
Sometime soon we’ll start the process of the 2010 PASS election, with three seats on the Board of Directors being...
2010-05-04
402 reads
Spring 2010 Hardware Recommendations
Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments,...
2010-05-04
859 reads
SQL Server Replication - Replication Agents
My first post in my replication series gave a brief overview of replication, before I dive into setting up and...
2010-05-04
7,238 reads
Don’t Forget to Register for the Free 24 Hours of PASS
The free 24 Hours of PASS event will held May 19 & 20, and includes 24 different one hour presentations on...
2010-05-03
411 reads
Follow Up: LinkedIn Poll
A couple weeks ago I wrote about testing the LinkedIn polling capability, putting up this poll:
The response rate wasn’t great,...
2010-05-03
320 reads
PASS Summit 2010 Content Survey
The Issue
Being involved in PASS and the SQL Server community via blogging and Twitter, I get to see and hear...
2010-05-03
1,032 reads
Recap of April 2010 DMV a Day Series
Well, I managed to finish up my series that featured a DMV query every day during the month of April....
2010-05-03
2,905 reads
Register For 24 Hours of PASS Event
The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations...
2010-05-03
535 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