Great Leaders in My Career
My friend Grant Fritchey recently posted in response to a quiz and at the end of that mentioned that he'd...
2009-05-04
578 reads
Blog Posts
SQLSaturday #12 in Portland, OR on June 6, 2009
Just had a call with Ken Starnes last week and all is proceeding for a great two track event in...
2009-05-04
296 reads
Working Remotely
It's too quiet in the house.
So I headed out to get some lunch and work at Paradise Bakery. They have...
2009-05-04
395 reads
Writing a Technical Article - Structuring Your Article
This is part one of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-05-04
1,680 reads
Notes on SQLSaturday #15
I drove up on Friday night for the speaker dinner, getting there after a busy day trying to catch up...
2009-05-03
412 reads
Do You Have What It Takes?
I was engaged in a conversation recently where the topic under discussion was "What defines an "A" class player?" Others...
2009-05-02
375 reads
Published, Again!
I have written two new articles and they are going to be published, not on SSC but on SSWUG. I...
2009-05-02
1,284 reads
Featured Blog: The HOBT by Aaron Alton
I've been trying to feature a blog each month and for April (one day late!) it's Aaron Alton. HOBT stands...
2009-05-01
489 reads
Lost in the Chaos
This morning I had an 8am call with the owners of my company and a consultant that was proposing some...
2009-05-01
443 reads
New Community Resource for IT Pros - Server Fault
Not too long ago the developer community got a fantastic resource called Stack Overflow. It's a question and answer site,...
2009-05-01
1,061 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers