I’m Not Presenting at PASS Summit 2013
Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing...
2013-05-22
675 reads
SQLAndy
Lost Phone, Ring,Glasses,Etc, At the Office
If you work at a company with more than a 100 or so employees you probably get an email every...
2013-05-16
626 reads
From Google Reader to Feedly
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
635 reads
Got Any Grapes?
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
Drafting Email You’ll Never Send-Probably
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
706 reads
Books On The Desk
I read quite a bit and it’s rare that I don’t have a book or magazine with me in case...
2013-05-07
677 reads
A SQL Shirt Style For Any Occasion
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
582 reads
Looking Forward
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,406 reads
Looking Back-Part 2
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away...
2013-04-29
1,254 reads
Assorted Links for April 27, 2013
Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining...
2013-04-27
809 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