No Caps for SQL Saturday : Speaker Edition
A few weeks back, I got into a conversation about whether PASS should put the boot down on events and...
2012-05-17
1,005 reads
StrateSQL
“Thou Shall Not Shrink the Database” #TSQL2sDay
This month, Chris Shaw (Blog | @sqlshaw) is leading the charge on the T-SQL Tuesday. This event is basically a blogging...
2012-05-08
1,001 reads
May 2012 – Monthly SQL Server Checklist
They say, “April showers bring May flowers.” But what if it doesn’t bring May flowers? What if instead you get...
2012-05-08
839 reads
Can You Dig It? – Determining Index Plan Usage
She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...
2012-05-04
1,443 reads
Changing Priorities
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
712 reads
SQLFriends in Minneapolis
Ever wanted to hang out and talk about SQL Server over lunch? Maybe get a chance to ask those questions...
2012-05-02
618 reads
April 2012 – Monthly SQL Server Checklist
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
892 reads
SQLCLR: Good? Or Evil? #MemeMonday
Is SQLCLR good or evil? Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...
2012-04-10
1,134 reads
April #Meme15 Assignment
Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...
2012-04-09
822 reads
Re-blog – March 23 – March 29
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-30
1,872 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