SQL Saturday
I’ve been pretty lucky in my career to have the opportunity to attend quite a few conferences. I’ve attended one,...
2009-03-02
1,184 reads
Blog Posts
Red Gate Software Supports SQLSaturday
If you've read my blog over the past year and a half you know that I've been heavily involved in...
2009-03-01
281 reads
An Optimised Disaster Recovery Plan thanks to SQLBackup
The continuity of operations during a disaster is as critical to running a business as just about anything. Somewhere, within...
2009-02-28
2,298 reads
A Security Control Inconsistently Applied Is Not a Control
Some things and readings today reminded me of this: a security control inconsistently applied is not a control. The whole...
2009-02-27
2,819 reads
First Impressions of the Kindle 2
As I blogged about previously, I had decided to go ahead and pre-order the Kindle 2. It was slated for...
2009-02-27
1,542 reads
My First Computer
OK, I’m not going to make a huge habit of responding to these chains, but I have a few spare...
2009-02-27
1,655 reads
BoiseCodeCamp and TechFest to be Held March 28, 2009
The BoiseCodeCamp and TechFest will be held Saturday, March 28th at Boise State University. This free event include 57 one-hour...
2009-02-26
1,381 reads
Featured Blog - Linchi Shea
If you haven't visited yet, you definitely want to read Linchi's blog - it's packed full of on topic posts about...
2009-02-26
1,806 reads
The Downsides of e-Commerce
Last year I was in a bookstore and looking through some books with Andy Warren of End to End Training....
2009-02-26
1,658 reads
Upcoming Speaking Engagements
I've got three speaking engagements lined up in next two months:
Wed, March 11 @ oPASS: The Truth About Disk Performance & Configuration....
2009-02-26
1,401 reads
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