SQLSaturday Orlando 2010 - The Planning Begins
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
428 reads
Blog Posts
Test Driving a LinkedIn Poll
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
257 reads
Use a Clustered Index
I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d...
2010-04-07
537 reads
24 Hours of PASS Registration Now Open
Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...
2010-04-06
649 reads
24 Hours of PASS v2.0
The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...
2010-04-06
712 reads
24 Hours of PASS: Celebrating SQL Server 2008 R2
Well, we finally got the ok to start talking about the second 24 Hours of PASS event, called 24 Hours...
2010-04-06
573 reads
A DMV a Day – Day 6
The DMV for Day 6 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-06
854 reads
Big Iron on Windows 2008 R2, Earning its Keep!
This screenshot goes in the category of “geek porn”… It shows an IA64 system with 256 logical processors and 512GB...
2010-04-06
275 reads
Catching Transient CPU Spikes Using SQL Trace
Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...
2010-04-06
4,528 reads
Confio Ignite: First Impressions
One of the national sponsors for SQL Satuday is Confio Software. Just because they sponsor SQL Saturday, it’s worth checking out their...
2010-04-06
2,809 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