Meet Thomas Kejser in Aarhus
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
759 reads
SQL Rally 2012 Nordic
The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...
2012-06-26
886 reads
DBCC CHECKDB
Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s...
2012-05-31 (first published: 2012-05-29)
118,725 reads
Backup compression using IBM TDP for SQL Server
If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in...
2012-05-15
1,994 reads
Troubleshooting Database mail
Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to...
2012-05-08
9,815 reads
Automatic page repair with SQL Server Mirroring
Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...
2012-05-01 (first published: 2012-04-24)
3,202 reads
How to Configure Database mail
In my daily job as a SQL Server consultant I go to a lot of places, many days on the...
2012-05-01
8,479 reads
Visualize Wait stats with Microsoft Excel
In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...
2012-04-18
1,179 reads
Instance Wide Wait Stats
Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking...
2012-04-11 (first published: 2012-04-09)
2,475 reads
Nifty queries using a Numbers helper table
(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...
2012-04-09 (first published: 2012-04-04)
4,633 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