Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
880 reads
Blog Posts
Relationships - T-SQL Tuesday #3
I missed T-SQL Tuesday #1, but participated in T-SQL Tuesday #2. Now it's time for #3, and I'm making my...
2010-02-09
3,377 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
527 reads
Speaking at the Rocky Mountain Tech Trifecta on February 27
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With...
2010-02-09
503 reads
SQL Server Useful Reading
I have been having an IO subsystem issue recently and I found the whitepapers very useful and wanted to post...
2010-02-09
780 reads
What is SQL Server? – Rocky Mountain Tech Trifecta
I’m doing a basic presentation at the Rocky Mountain Tech Trifecta later this month on what SQL Server is from...
2010-02-09
428 reads
Who Would You Like To See as a PASS Summit Keynote Speaker?
Note: These are my opinions and don’t reflect the official views of PASS, just my thoughts!
I’ve been to every PASS...
2010-02-09
455 reads
Attending SQLSaturday #33 in Charlotte, NC
Just booked the travel, going up the afternoon of March 5th and returning on an early evening flight on the...
2010-02-08
340 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-08
328 reads
New Laptop
Due to arrive from China today. I got a shipping notice of 2nd day shipping from Lenovo last week, but...
2010-02-08
304 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