Fusion-io, What It Takes To Be On The Cutting Edge
I recently had the privilege to talk with David Flynn, former CTO, Founder and newly minted CEO about Fusion-io. How...
2010-11-01
1,521 reads
Blog Posts
Leaving (for) Las Vegas
Tomorrow I’m off to Las Vegas for SQL Connections. Since tomorrow is also T-SQL Tuesday #012, I’m writing a pre-trip...
2010-11-01
427 reads
More Voting
As if the US Election and SQL Rally voting were not enough (and have you voted yet for the SQL...
2010-11-01
639 reads
Motivational Monday
In life there are not many guarantees. For DBA’s and developers there are a few:
1. Backups will become corrupted but...
2010-11-01
395 reads
Movember – Team IPMO
Some friends of mine decided to support the Movember charity this year. I would try and explain what Movember is...
2010-11-01
713 reads
November Question: What steps do you include in your database maintenance?
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,436 reads
November Snuck Up on Me
I should have gotten this post out last week with another follow-up this week. Well, looks like I will have...
2010-11-01
450 reads
Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server
Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...
2010-11-01
706 reads
SQLSaturday#59 Update! - 3 weeks to go.....the after PASS East Coast Special!
SQLSaturday#59 Update!
Well, the event is now less than 3 weeks away (better finish my presentation 🙂 and there are 450+ attendees...
2010-11-01
564 reads
SQLServerCentral.com Track at SQL Server Connections This Week
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
626 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