Book Review: SQL Server 2008 Query Performance Tuning Distilled
I'm just finishing up SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey and Sajal Dam and overall I've...
2009-05-07
486 reads
SQLAndy
Xobni Add-In For Outlook
A few weeks back I wrote about trying out the LinkedIn Add-in and time has reinforced for me that it's...
2009-05-06
486 reads
Starting Conversations - Part 4
As I've mentioned in earlier posts (Part 1, Part 2, Part 3) I've engaged speaking and networking Don Gabor to...
2009-05-05
407 reads
SQLSaturday #12 in Portland, OR on June 6, 2009
Just had a call with Ken Starnes last week and all is proceeding for a great two track event in...
2009-05-04
296 reads
Great Leaders in My Career
My friend Grant Fritchey recently posted in response to a quiz and at the end of that mentioned that he'd...
2009-05-04
577 reads
Notes on SQLSaturday #15
I drove up on Friday night for the speaker dinner, getting there after a busy day trying to catch up...
2009-05-03
412 reads
Featured Blog: The HOBT by Aaron Alton
I've been trying to feature a blog each month and for April (one day late!) it's Aaron Alton. HOBT stands...
2009-05-01
489 reads
Building Something Fun - 2
Last Friday I posted about turning my first pen on a lathe, this week I'm discussing my other recent project,...
2009-04-30
1,740 reads
PASS Summit Early Bird Registration Ends Tomorrow - Why it Matters
I serve on the PASS Board of Directors, but this post reflects my personal views and not an official PASS...
2009-04-30
1,422 reads
SQLSaturday #15 is May 2nd, 2009 in Jacksonville
My friend Brian Knight is leading the 2nd annual SQLSaturday in Jacksonville on May 2nd. Right now it looks like...
2009-04-29
1,326 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