Loading Up For Travel
I fly to the UK tomorrow, not really my favorite thing to do, so I’m trying to ensure I can...
2009-01-16
785 reads
Blog Posts
Comments on Pro Full-Text Search in SQL 2008 by Michael Coles
Apress sent me a free review copy, so I took a quick look through it at lunch. I've used full...
2009-01-15
603 reads
devLINK Technical Conference to Be Held in Nashville, TN in August
The 2009 devLINK Technical Conference will be held in Nashville, TN, August 13-15, 2009. This three-day conference provides technical content...
2009-01-15
474 reads
Have you disabled autoplay yet?
If not, you should. Because autoplay being on means any time a removable data device, such as a USB stick,...
2009-01-15
747 reads
Honoring a Contest
Over the last six months or so, Pepsi has been running a PepsiStuff promotion on many of their products. They...
2009-01-15
645 reads
How Humans Behave
It is strange how people react in different circumstances. Yesterday while going through the forums, there was an interesting post....
2009-01-15
444 reads
Microsoft Solution Accelerators on TechNet
I was browsing through the new titles that are on Safari and saw some planning guides around Windows Server 2008...
2009-01-15
815 reads
PASS BI SIG
Yesterday I participated in my first BI SIG live meeting. This special interest group is led by Amy Lewis who...
2009-01-15
671 reads
Thanks to PASS - Free Laptop
It seems like the benefits of being involved in PASS just never stopped. If you didn’t see the PASS newsletter...
2009-01-15
575 reads
The Story of the TV Stand
We all have those things that happen at work that somehow turn into something other than expected, and sometimes in...
2009-01-15
650 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