Adios
If all goes well, by the time you read this on Thanksgiving I’ll be up in the mountains of Colorado....
2009-11-26
769 reads
Blog Posts
Book Review: Let’s Create (for children)
I’m fond of browsing the discount shelf at the bookstore, it’s another way to see books that I might otherwise...
2009-11-26
577 reads
Ft. Worth SQL Server User Group Meeting Recap
I’d like to say thanks to Andy and Judith over at the Ft. Worth SQL Server User Group for having...
2009-11-26
774 reads
Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3
Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of...
2009-11-26
1,437 reads
PASS European Conference 2010 Call for Speakers is Open
If you are interested in speaking at the PASS European Conference 2010, to be held in Neuss, Germany, April 21-23,...
2009-11-26
583 reads
A good way to learn
I have noticed that one of the best way to learn about a certain topic is to write an article...
2009-11-25
690 reads
Cleaning out Tempdb
I saw a post recently about the tempdb being overly large and causing issues for a user. The person was...
2009-11-25
2,280 reads
In Charge
I had to run our weekly conference call this week. My boss is out of the office, but he’s been...
2009-11-25
740 reads
More on DBAs and Local Administrator Rights
I'm looking over the comments about DBAs and local Administrator rights and I noticed an interesting trend: no one discussed...
2009-11-25
2,601 reads
Thanksgiving This Year, Stress, Cooking Something New, and Others
I know Thanksgiving has some deeper meanings, but at one level it’s all about the food. Food is a good...
2009-11-25
608 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