Brian Knight’s Texas Tornado Tour!
Its been fun and fulfilling getting neck deep into the Central Texas Capitol Area Users of SQL Server again after...
2009-08-02
498 reads
Blog Posts
Fusion-IO Update
I’ve done all the testing I can do for now. There were some unexpected developments that I will cover in...
2009-08-02
553 reads
LinkedIn References
One of the interesting features of LinkedIn is the ability to post a reference about a connection. If you think...
2009-08-02
869 reads
Active August #1
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...
2009-08-01
621 reads
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
2009-08-01
1,116 reads
Revive your User Group, part IV
Over the past three posts in this series entitled “Revive your User Group”, I’ve shared some of best practices that...
2009-08-01
520 reads
Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,414 reads
Heading to N'Awlins
I'm leaving today for SQLSaturday #17, actually in Baton Rouge. I'll be at the speaker party tonight and hope to...
2009-07-31
1,553 reads
No really. When did this statement start?
I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific...
2009-07-31
1,319 reads
PASS & SQL Bloggers
PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage...
2009-07-31
1,317 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