The Financial Crisis - Why Did I Write This?
I've had a bunch of writings based on finances over the last couple weeks, and I've tried to spread them...
2008-10-17
659 reads
Blog Posts
When Do You Know That You Know
Why, when you can help others, that's when!
In my role as a senior Moderator with the MSDN SQL Forums, I am often...
2008-10-17
454 reads
How Many Drive Letters Do You Use for SQL Server?
I was teaching a private class recently that had both DBA's and network types in the room, one of the...
2008-10-16
821 reads
Uninstalling Software (Sucks) and Why Computers Are Still Slow
I've just recently acquired a new laptop and my resolution is to install no software on it that I'm not...
2008-10-16
674 reads
What's Your Job Title?
As I travel and visit DBAs from around the United States, I am always surprised at the job titles DBA...
2008-10-16
638 reads
Big and Small - Why Did I Write This?
I've always been very concerned about where I work. Well, maybe not always, since early in my career I took...
2008-10-15
631 reads
Looking for Free Educational Events to Attend?
Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that...
2008-10-15
625 reads
Financial Trust
I’m sure that the people at Mint and Thrive have people’s best interests at heart. They built services designed to...
2008-10-14
950 reads
Flyclear Revisited
Back in May I wrote about signing up for FlyClear as a way to save time travelling and in doing so,...
2008-10-14
520 reads
Too Good at Data Analysis - Why Did I Write This?
The past few weeks have been a rough one all around the globe as economies aren't doing well. I studied...
2008-10-14
604 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