The End of an Era
I went and cleaned out the Central Publishing Group colocation cage at Viawest. We've been there for 3 years and...
2007-08-30
1,409 reads
Blog Posts
The Blogging Debate
It's an interesting debate on blogging in response to my editorial. I definitely thing blogging is worth a try. You...
2007-08-28
1,484 reads
Comments on the 2007 Jacksonville Code Camp
I attended for the morning and Brian attended in the afternoon and did a session as well. It was interesting...
2007-08-27
1,321 reads
SQLSaturday Schedule Announced
Our one day free SQL Server event is slowly gaining momentum! Draft schedule is at http://www.sqlsaturday.com/schedule.aspx. 30 sessions total and...
2007-08-27
1,571 reads
Getting Close
Actually we had a long meeting with the developers this morning and PMs over a remote desktop session and I...
2007-08-24
1,387 reads
Do You See What I See?
Working with developers is always very interesting, especially when you are a client. I'm sure that I'm not the best...
2007-08-21
1,410 reads
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
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
The Beta Cycle
I live in Denver. That's in the Mountain time zone, either MDT or MST depending on the time of year,...
2007-08-14
1,428 reads
The Performance Game
I've posted in the forums fairly often that there's kind of a black art to performance tuning. As with most...
2007-08-14
1,454 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