Editorial - MP3

Technical Article

Communication Issues

  • Article

When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.

You rated this post out of 5. Change rating

2009-11-23

1,074 reads

Technical Article

Easy Licenses

  • Article

Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.

You rated this post out of 5. Change rating

2009-11-19

2,933 reads

Technical Article

Testing at Scale

  • Article

It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.

You rated this post out of 5. Change rating

2009-11-16

2,954 reads

Blogs

Identity Columns Can’t Be Updated: #SQLNewBlogger

By

I’m not sure I knew identity column values could not be updated. I ran...

Rolling Back a Broken Release

By

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

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Read the latest Blogs

Forums

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Creating JSON III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON III

Testing is Becoming More Important

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Testing is Becoming More Important

Visit the forum

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
8Kirin
I run this code:
SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;
What are the results?

See possible answers