Old and Wise
I'm not sure that I'm wise, but I do feel old quite often. I noticed that after my talk at...
2008-11-06
455 reads
Blog Posts
BootStrap - Why Did I Write This?
I attended the Business of Software a couple months ago and really enjoyed the conference. I wrote a series of...
2008-11-05
313 reads
DevTeach to be Held in Montreal December 1-5
DevTeach is offering 136 sessions, including 36 on SQL Server, 17 on Agile Development, 17 on Software Architecture, and 57...
2008-11-05
386 reads
MSSQLTips: How to setup and use a SQL Server alias
I've written my first tip for MSSQLTips.com:
How to setup and use a SQL Server alias
It's a pretty simple thing to...
2008-11-05
901 reads
PASS Board of Directors Part 3
Yesterday I posted about deciding to throw in my hat as far as running for the board, today I'll add...
2008-11-05
441 reads
The Wise Old Man Part 4
In my previous posts The Wise Old Man Part 1, The Wise Old Man Part 2 and The Wise Old...
2008-11-05
820 reads
Participation
With a large election year in the US (President + all the other races), I've been more interested than in some...
2008-11-04
392 reads
PASS Board of Directors, Part 2
A couple weeks ago I wrote about trying to decide whether to run for the PASS board. I talked about...
2008-11-04
535 reads
Election Day & Love of Country
I'm not trying to talk politics here, but I don't want to be so politically correct that I avoid important...
2008-11-03
452 reads
Microsoft Launches SQLServerEnergy.Com
Microsoft has launched a new SQL Server 2008 marketing-related website at www.sqlserverenergy.com. It is available in 11 languages, and offers...
2008-11-03
848 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