Featured Blogger: Alexander Kuznetsov
I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog...
2009-08-25
718 reads
Blog Posts
Kalen Delaney Joins The SQLSaturday Advisory Council
Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we...
2009-08-25
570 reads
New Book
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
561 reads
PASS Board Nominations
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
663 reads
PASS Board of Directors - Call for Nominations
Well I feel a little strange making an announcement about this since I'm not running. A number of people have...
2009-08-25
1,618 reads
PASS Connector Editorial for August 26, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-25
534 reads
Professional Growth – Community Involvement
As part of my professional development and to help raise my professional profile, I have become more involved with my...
2009-08-25
611 reads
24 Hours of PASS
Image a full day of SQL Server and BI training. Even better yet, a full day of FREE training. Well PASS (Professional...
2009-08-24
537 reads
Article Of the Week
I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way...
2009-08-24
945 reads
I went silly
Well, a little silly at least. I wrote yesterday about winning a gift certificate to ThinkGeek, and wondering what to...
2009-08-24
943 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