My PASS Summit 2011 Experience
The 2011 PASS Summit is in the rear view mirror (has it really been almost three weeks now?)...and as always...
2011-11-02
931 reads
Blog Posts
Presenting at SQL Saturday #96
I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...
2011-11-02
789 reads
Presenting Tomorrow (Thursday) via Webinar - SQL Server Security
I have the privilege of being able to give a webinar tomorrow, November 3, at 11 AM EDT. It will...
2011-11-02
1,086 reads
Salaried employee vs contractor
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,116 reads
SQL Saturday #87 Report
I drove the over 250 miles from my home in Edwardsville, IL, to attend the SQL Server 87 in Louisville,...
2011-11-02
1,320 reads
WAN Optimization Solutions–Input Needed Please!
I was just wondering if anyone has a WAN optimization solution as part of their infrastructure. I have a few...
2011-11-02
756 reads
10 More Days Until Inspiration! - SQLInspireNYC 2011
Can't believe we're ONLY 10 days out from what's shaping up to be quite an extraordinary awesome event! We've been...
2011-11-01
1,293 reads
Backup/restore/checkdb/shrinkfile progress
Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you...
2011-11-01
1,112 reads
Being an Effective DBA Remotely
Do not let the phrase “out of sight, out of mind” apply to you.
As Data Professionals a lot of us...
2011-11-01
1,126 reads
BI Pyramid (read categories of users in a BI solution)
Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...
2011-11-01
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