SQLSaturday Update
We went for a site visit Tues and I think it will really work out well for us. Good parking,...
2007-08-17
1,396 reads
SQLAndy
Replication Book Review/Intereview Posted on SSC
Book reviews aren't easy and it's always hard to tell if you're telling the reader anything they can't learn from...
2007-08-17
1,349 reads
Table Partioning Article Posted on SSC
Article is at http://www.sqlservercentral.com/columnists/awarren/3135.asp. I'll have quite a few more on this subject over the next few months. As I...
2007-08-09
1,359 reads
Fewer Seats Make for Better User Group Meetings?
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,333 reads
User Groups, Geeks, and Puzzles
Last night we had one of bi-monthly meetings of oPASS (Orlando SQL Servers User Group) and we had a pretty...
2007-08-08
1,440 reads
Professional Development Plans Article on SSC
This was fun to write. It's a subject I'm passionate about and that too few in our field seem to...
2007-08-07
532 reads
Celko, SQL, and SQLSaturday
Big news here in Orlando is that Joe Celko will be presenting two sessions at SQLSaturday on Nov 10. Once...
2007-08-02
469 reads
Revisit What You Know - Published on SSC
The article went live earlier this week. Didn't quite accomplish what I had hoped I think, which was to point...
2007-08-02
446 reads
User Groups Moved to New Domain
We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of...
2007-07-27
1,555 reads
SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 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