Crazy Egg
I know, I should have put more in the title. Crazy Egg is a web page traffic analysis tool that...
2009-10-28
564 reads
Blog Posts
Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-10-28
1,858 reads
How Many Rows Have Changed?
One of the things that I've asked DBAs, and I see asked often, is how much does your data change?...
2009-10-28
2,483 reads
2009-10-28
576 reads
My Schedule for the PASS Summit 2009
For the most part, I have an easy schedule. I’ll be in the 600 hallway most morning after the keynote...
2009-10-28
724 reads
Replication Setup:
I saw too many questions on forum asking step by step process of configuring replication I have these links in...
2009-10-28
1,129 reads
Snags With Profiler GUI
Running the Profiler GUI against a production server is not something you should do. I’ve outlined my research into exactly...
2009-10-28
878 reads
2009 PASS Community Summit and SQL Server Connections Conference, Both in November
If you will be attending either the 2009 PASS Community Summit in Seattle, WA, from November 2-5; or the SQL...
2009-10-27
438 reads
Deterministic Functions
Do you know what determinism is? It's something that comes up periodically in Books Online as various SQL objects require...
2009-10-27
1,835 reads
Four New Zealand Cities are Final Stops on 30 Day Speaking Tour
After making seven presentations in Australia, I headed to New Zealand where I made four presentations in four cities, on...
2009-10-27
484 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