Book Review: SQL Server 2008 Query Performance Tuning Distilled
I recently finished reading the Apress book SQL Server 2008 Performance Tuning Distilled by Grant Fritchey and Sajal Dam. I...
2010-01-07
1,341 reads
Jack Corbett
- Interests: Sports, books, Bible
2010-01-04
757 reads
Final Recap – 2009 Goals
Well, I set 7 professional goals for 2009 and I did okay in meeting them, but I was not successful...
2009-12-31
1,385 reads
Presenting a Live Meeting vs. a Real Meeting
I recently had the opportunity to present, Nuggets Found by Mining the Default Trace, for SQLLunch. This was my first...
2009-12-28
342 reads
OT: What Christmas Means to Me
Merry Christmas to everyone. As many of you know, at least I hope you do, I am a born-again Christian...
2009-12-24
352 reads
Speaking at SQLSaturday #32 – Tampa
I just found out that I’ve been accepted to speak at SQLSaturday #32 – Tampa on January 23, 2010. My session...
2009-12-23
372 reads
SQLLunch Resources – Mining Nuggets from the Default Trace
I did my first SQLLunch today and it was fun. I don’t know how many attended, my last look was...
2009-12-21
351 reads
Have Lunch with Me
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
340 reads
Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
404 reads
What is Your Biggest Weakness?
I was tagged by Ken Simmons (@kensimmons) in the blog chain started by David Stein (@made2mentor). Here’s Ken’s post and...
2009-12-14
506 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