SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The...
2010-12-30
1,927 reads
Blog Posts
Wiring up a common click event handler in an ASP.NET page
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,111 reads
A Change of Pace
As some of you may have already heard, I spent much of December moving from Hawaii to Missouri. Generally, when...
2010-12-29
1,560 reads
Book Review: Bury My Heart at Conference Room B
Bury My Heart at Conference Room B: The Unbeatable Impact of Truly Committed Managers by Stan Slap ($15 @ Amazon) is...
2010-12-29
734 reads
Digineer Is Hiring
If you are in Minnesota and are looking for a new job, Digineer is hiring. Heck you can even be...
2010-12-29
598 reads
How to tell if a property exists by name
I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...
2010-12-29
677 reads
Looking Back at 2010–Goal Review
I had 8 goals for 2010, which I posted at the end of last year. That reminds me, I need...
2010-12-29
1,828 reads
Quick Thoughts on Learning
I’m looking for the attribution for a quote – it’s something I first heard from Sean, and we say it all...
2010-12-29
503 reads
SELECT TOP 5 * FROM BLOGGERS
Hopefully my title gives away what this post is about. This my list of the top five people or more...
2010-12-29
537 reads
SQL Server Storage Internals Part 6 – How to read Clustered and Non Clustered Index Pages
In this article we are going to see how index pages are organized with data pages and how to read different...
2010-12-29
7,598 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