Re-blog – March 16 – March 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-23
786 reads
StrateSQL
March #Meme15 Round-up – Facebook
Are you ready for the round-up of last week’s #meme15 Facebook question?
In total, there were eight participants in this month’s...
2012-03-22
1,016 reads
Re-blog – March 9 – March 15
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-16
701 reads
March #Meme15 – Facebook
It’s the early morning of the 16th, and time to write my #meme15 post. Remember, these are due on or...
2012-03-16
861 reads
Webcast: What Are You Waiting For?
What was the number one question from today’s webcast on wait statistics? Where can the slides and sample code be...
2012-03-15
738 reads
Happy #Pi Day
Here’s wishing you a Happy Pi Day…
If my picture isn’t good enough, here’s a better representation of pi.
3.14159265358979323846264338327950288419716939937510
Related posts:Happy Pi...
2012-03-14
580 reads
March #Meme15 Assignment
This month, the #meme15 post will fall on March 15th, often referred to as the Ides of March. This date...
2012-03-11
655 reads
Frozen for the Special Olympics
Last weekend, I braved to last hurrah of our Minnesota winter and jumped into Lake Calhoun in Minneapolis. It was...
2012-03-11
763 reads
Re-blog – March 2 – March 8
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-09
613 reads
March 2012 – Monthly SQL Server Checklist
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can...
2012-03-08
1,769 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