Podcast Upgrades
A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a bit...
2008-05-02
1,917 reads
Blog Posts
Looking for Incremental Improvements
If you've read my blog much you'll know that I'm deeply involved in trying to figure out how to build...
2008-05-01
530 reads
Technorati
I've never really been a big fan of many of the aggregation sites. As such I have never really used...
2008-05-01
713 reads
The Post Count
One of the things that I made a conscious effort to do last summer was make a regular effort to...
2008-05-01
726 reads
Review of Pro SQL Server 2005 High Availability
I grabbed Pro SQL Server 2005 High Availability by Allan Hirt recently to add to the library and I've been...
2008-04-30
1,365 reads
Building Raffle Tickets for SQLSaturday
Raffle tickets have become a mainstay of our events, making it easy to handle the large volume of items donated...
2008-04-29
1,611 reads
Mentoring
I've never been much of a mentor to people, partially not having the chance, partially focusing too much on myself,...
2008-04-29
2,033 reads
More on Mentoring
Two weeks ago I did five posts on mentoring, and based on that I received a couple interesting notes, here...
2008-04-28
1,368 reads
SQLSaturday #3 Jacksonville - Final Reminder!
Just checked the registrations and we're at 354, with plenty of room for more! Brian has been busy tweaking the...
2008-04-28
1,354 reads
Visiting the Space Coast .Net Users Group in June
My friend Ken Tucker invited me to speak on June 11, I'll be doing a short presentation on SQL performance...
2008-04-28
1,567 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