Last Minute Prep
Next week is the PASS Summit for 2008 in Seattle and I'm trying to close down the work I need...
2008-11-12
671 reads
Blog Posts
Latest Orlando User Group Meeting & Assorted Attendees
We had our meeting on November 11, 2008, with 27 people attending. Our featured speaker was Jessica Moss, SQL MVP...
2008-11-12
538 reads
Redoing Work
I hate redoing work. I really try to make sure that I pay attention to what I'm doing, slow down...
2008-11-12
672 reads
SQLSaturday #6 - Canceled
Just heard back from Allen White, due to his schedule and minimal success creating a true team effort plans for...
2008-11-12
544 reads
SQL Quiz - Mistakes You've Made?
I'd seen Jason Massie's post on Facebook of this SQL Quiz, but when I found Brian Kelley's post, I decided...
2008-11-11
791 reads
Two Mistakes
I don't typically do Internet chain mail, but Brian Kelley mentioned me in his post on his two mistakes and...
2008-11-11
737 reads
If You are Attending PASS, Please Say Hello
I will be attending the PASS Community Summit in Seattle, November 18-21, and will be making two presentations:
DBA 101: Best...
2008-11-10
398 reads
Member of PASS? Don’t Forget to Vote for PASS’s Board of Directors
As most of you know, PASS (the Professional Association for SQL Server) is an independent, not-for-profit association, dedicated to supporting,...
2008-11-10
560 reads
PASS Board of Directors Part 4
I'm going to share what I can from the interview, but I'm going to have to be a little less...
2008-11-10
378 reads
The Security of You - Why Did I Write This?
When I first got my new laptop, I thought it was very cool. It included a fingerprint reader below the...
2008-11-10
364 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