June 2010 S3OLV Meeting
The S3OLV monthly meeting is being held this Thursday. We will be meeting at the same location and time as...
2010-06-07
488 reads
Blog Posts
Master Data Services
You need consistent, reliable data. You want data that you can trust.
This is usually data about your transactions, slowly changing...
2010-06-07
545 reads
Pensacola Holds Second Annual SQL Saturday
SQL Saturday #22 was held on Saturday, June 5, 2010, with about 224 attendees participating in this free event. It...
2010-06-07
1,087 reads
Professional Development Event:Taking Control of Your Career
This is just a reminder that this month’s Professional Development virtual chapter meeting we have MVP, PASS Board member, and...
2010-06-07
402 reads
StreamInsight
This is one of my favorite technologies for SQL Server 2008 R2. This session was from Torsten Grabs, the program...
2010-06-07
2,108 reads
Tech Ed Conference 2010 – New Orleans
SUNDAY 6/6/2010
While sitting in the conference center for Tech Ed 2010, I thought, why not blog about my trip. Even...
2010-06-07
494 reads
TechEd 2010 – Monday Morning
One of the nice unplanned parts of the trip was walking out the front door of the hotel to realize...
2010-06-07
545 reads
TechEd 2010 – Sunday
Flew out of Orlando Sunday morning via Southwest. It was my first time flying SW, I usually go with whoever...
2010-06-07
521 reads
Teched 2010 – Sunday Part 2
Checkin at TechEd was fast, people were moving through very quickly. Photo ID required, get your badge, and then down...
2010-06-07
315 reads
TechEd 2010 Opening Keynote
It’s a zoo.
Once again wifi sucks, sitting in the keynote room, unable to join the wireless network and get a...
2010-06-07
353 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