The October 2008 Energy Update - So Much Passion
Do we have an energy crisis or not? Is global warming real? Are we being affected by burning fossil fuels?
I...
2008-10-30
1,457 reads
Blog Posts
The Wise Old Man Part 2
In my previous post The Wise Old Man Part 1 I wrote about a great session I attended during SQL...
2008-10-30
1,586 reads
The Wise Old Man Part 1
During one of the sessions that I attended during SQL Saturday in Orlando I had the privilege of listening to...
2008-10-29
1,688 reads
Thoughts on .Net Reflector Being Acquired by Red Gate
This is an unpaid/unsolicited comment about a product now owned by Red Gate Software. Purely my opinions, and I'll try...
2008-10-29
1,601 reads
A Break
Only a small one, but I appreciate every one I get. Not often that I get to leave the site...
2008-10-28
1,472 reads
Effecting Change
Over the years Andy Warren, Brian Knight, and I have talked about PASS quite a bit. It hasn't always been...
2008-10-28
1,433 reads
Free/Cheap/Good HTML Editor, Is There Such a Thing?
For the past few years I've been using Frontpage 2003 for basic HTML work, usually to write content for SQLServerCentral....
2008-10-28
1,351 reads
Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,564 reads
Post Event Notes - SQLSaturday #8
Yesterday I posted an overview of the event, today I want to go over some areas where we excelled, and...
2008-10-27
1,328 reads
Post Event SQL Saturday #8 Orlando
This weekend I spoke at Seminole Community College with a session on Reporting Services 2008. If your interested you can...
2008-10-27
1,417 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