MDX Utility Belt of Calculations Part 3
This is part three in a series of blog posts that will help you build an arsenal of MDX calculations...
2009-12-03
1,770 reads
Blog Posts
Thanksgiving Review
Last week I posted about planning to cook some for Thanksgiving, thought this week I’d share some of how it...
2009-12-03
469 reads
Transactional Replication Conversations –Must read
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,146 reads
You pulled BUILTIN\Administrators, but are you auditing?
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
2009-12-03
2,528 reads
Another Update on SQLSaturday
I’ve fallen behind a little on sharing SQLSaturday news, so I’ll try to catch up on the latest. First, we’re...
2009-12-02
485 reads
Authors Needed for the SQL Server Standard (PASS) & Almost Engraved Invitations
SQL Server Standard editor Grant Fritchey needs more content! We’ve got about three done and three more in the pipeline,...
2009-12-02
952 reads
Dr. DeWitt’s Key Note at the PASS Summit
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
713 reads
Explain it to yourself
I found a nice post from a friend, Roy Ernest, on an effective way to learn. He notes that one...
2009-12-02
672 reads
Featured Blogger: Tim Mitchell
I met Tim about a year and a half ago at SQLSaturday Jacksonville and from the start we hit it...
2009-12-02
271 reads
Fundamentals of Storage Systems – Testing IO Systems
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,576 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