Inconvenient – Reading on Paper
I woke up this morning to find Tia reading an actual paper books. That’s become a rarity for both of...
2010-01-17
716 reads
Blog Posts
January Roundup
I have just put together the January newsletter for www.gre-sqlserver-solutions.com and scheduled it to run Sunday night/Monday morning. It is...
2010-01-16
698 reads
Second Shot Promotion For Microsoft Certification Exams
Microsoft and Prometric have renewed their Second Shot promotion for certification exams. This allows you to retake a failed exam...
2010-01-16
907 reads
The Energy Detective TED 5000 Installed And Working
Back in October, I ordered one of the new TED 5000 energy monitors directly from Energy, Inc. in Charleston, SC....
2010-01-16
822 reads
Admitting When You're Wrong
As a father of two head-strong boys (inherited trait), I struggle with getting them to admit they are wrong when they...
2010-01-15
1,012 reads
PASS 2009 Speaker Evaluation Scores
Since quite a few PASS 2009 speakers have gone public with their speaker evaluation scores, I might as well do...
2010-01-15
772 reads
Presentations – Lessons Learned
This will be a very short entry. I just wanted to share a few things I learned very quickly while...
2010-01-15
865 reads
Recommend a Book I Should Read
I read a lot and like to think my interests are wide, but I fall into ruts all the same....
2010-01-15
530 reads
Scripting Indexes
I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.In the posting the author explained...
2010-01-15
1,457 reads
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
580 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