SQL Server Disaster Recovery
I was reading a blog post by Steve Jones on Monday and I started to write a comment on his...
2012-12-11
1,094 reads
Gethyn Ellis
SQL Server Books–Query Tuning
Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization...
2012-12-10
1,052 reads
SQL Server Consulting Blog–Sunday Stats
I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done...
2012-12-09
801 reads
SQL Server Training in 2013
Unbelievably it is December already and 2013 is fast approaching. With the Christmas break fast approaching now is the time...
2012-12-03
1,081 reads
SQL Server Consulting Blog–Saturday Stats 1st Dec 2012
This post is little experiment I’m trying out this weekend. The SQL Server Consulting blog has been up and running...
2012-12-01
881 reads
Chicago: The Travels of a SQL Server Consultant
As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server...
2012-11-29
2,115 reads
Newsletter
Back in the old days before this blog when I was publishing a website instead that has long been consigned...
2012-11-22
881 reads
Top 3 Books on Writing Transact-SQL (TSQL)
This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server...
2012-11-21
957 reads
Top 5 Books on SQL Server 2008 Business Intelligence
Carrying on with book week and answering the question I’m often asked about what books I;d recommend to learn about...
2012-11-20
943 reads
Top 5 SQL Server 2008 DBA Books
I’m often asked about what books I would recommend for learning more about SQL Server 2008 and I always respond...
2012-11-19
1,035 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