Speaker Gift for SQLSaturday #49
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
505 reads
SQLAndy
Review: NPR Baseball Driveway Moments
NPR Baseball Driveway Moments ($15 @ Amazon) is an audio book I got from the local library to listen to on...
2010-10-12
389 reads
PASS Update #44 (Budget)
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
518 reads
Planning to Fail
Great title for a post, isn’t it? Seems foolish, lazy, or worse to plan for failure, right? Yet, in the...
2010-10-08
313 reads
Literacy & Teaching
I found The Literacy Project at Google after seeing a local op-ed piece about literacy. I love to read, a...
2010-10-07
441 reads
My Favorite Attorney – Chris D’Amico
Not often I do plugs here, but then again, it’s rare that I just get first class service, so read...
2010-10-07
384 reads
A Surprising Result from Ident_Current
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
958 reads
Reminder – Deadline for SQLRally Pre-Con Abstracts is October 15th
See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...
2010-10-05
357 reads
SSC Editorial – Great Service
I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....
2010-10-05
430 reads
SQLRally Event Flyer is Ready
The SQLRally marketing team put this flyer together last week. We’ll be trying to get Chapters and SQLSaturdays to link...
2010-10-04
333 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