8 Weeks In
I’m about eight weeks into my current project and while I’m certain I don’t know it all, I’m finally at...
2011-09-13
537 reads
SQLAndy
Checkers, Chess, and Politics
There are few games that don’t have some kind of strategy, from tic-tac-toe on up. Sometimes we take the time...
2011-09-12
1,155 reads
My Sessions & Schedule at the 2011 PASS Summit–Early View
I was just checking the event calendar and saw that my Building a Professional Development Plan presentation is on Wednesday...
2011-09-12
766 reads
PASS Update #64 (Officer Elections)
Recently former PASS President Kevin Kline posted his thoughts on the current slate of officers. I encourage you to read...
2011-09-07
1,019 reads
SQLSaturday #85 Is Just Around the Corner
Coming up on September 24th we’ll be doing our fifthannualSQLSaturday here in Orlando. We’re still at Seminole State College but...
2011-09-06
673 reads
Testing Decisions
One of the things I like to do is take some time on decisions that matter to me. That’s a...
2011-09-02
1,035 reads
Parking Places & Editorials
Parking places, that’s the topic of my recent editorial on SSC. A simple topic, but one that most of us...
2011-09-02
844 reads
Strong Manager or Weak Manager?
Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested...
2011-08-30
1,720 reads
Notes From The 2011 Jacksonville Code Camp
In a departure from my usual plan, this year I drove up to Jacksonville mid-morning in time to have a...
2011-08-29
828 reads
PASS Update #63 (How Do We Rate)
A short update today, following up on an email to the Board from incoming VP of Finance Douglas McDowell who...
2011-08-25
791 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
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