QNAP Launches QNA-UC5G1T: A USB 3.0 to 5 GbE Network Adapter
QNAP has introduced its USB 3.0 to 5 GbE network a...
2019-05-23
Hardware
Silicon Power’s Bolt B75 Pro: An External SSD up to 2 TB, USB 3.1 Gen 2 Type-C
Silicon Power has introduced its new external SSD ...
2019-05-23
2019-05-22
Kingston Launches Client-Focused KC2000 M.2 NVMe SSD: 96L TLC On SM2262EN
Kingston's latest flagship client/consumer SSD is launching today: the KC2000, which is set to replace the two year old KC1000. The KC2000 was previewed early this year at CES,...
2019-05-20
2019-05-11
128 reads
HP Spectre 15 x360 2019 review: Carving a niche in a crowded space
The "gem-cut" design isn't for everybody, but it sure is striking.
2019-05-10
Upgrading from an Intel Core i7-2600K: Testing Sandy Bridge in 2019
One of the most popular processors of the last decade has been the Intel Core i7-2600K. The design was revolutionary, as it offered a significant jump in single core...
2019-05-10
Samsung EVO Plus microSDXC UHS-I 512GB Memory Card Capsule Review
As content capture devices are recording ever-higher bitrate videos and higher resolution photos, high capacity memory cards are increasingly in demand. Everything from smartphones to game consoles to PCs...
2019-05-10
2019-05-09
Intel Process Technology Update: 10nm Server Products in 1H 2020, Accelerated 7nm in 2021
Intel provided an update regarding its upcoming fabrication technologies at its 2019 Investor Meeting. The company is on track to produce server-class products using its l0 nm manufacturing technology...
2019-05-08
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
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