Excel as a Database Professional
People ask me all the time how to become a DBA. This is a topic that so many colleagues of
mine...
2015-09-24
2,148 reads
Robert Pearl
T-SQL Tuesday #70 - SQL Server In the Enterprise
PearlKnows WeB log, Stardate 2015.9.8: This week’s topic is strategies for
managing an enterprise, brought to us by one half of...
2015-09-08
3,109 reads
Red Gate in the City - DLM Training workshop & UG in NYC - August 27, 2015
We have another great 1-DAY training workshop coming to New York City at MS NYC HQ 11 Times Square on...
2015-08-20 (first published: 2015-08-11)
1,564 reads
Remember Nepal - Lead by Example
Below is the original article in its entirety, that was published on the Americas MVP Community Facebook page, on July...
2015-08-20
1,415 reads
CNJSSUG Presents: Architecting a SQL Server Availability Groups Topology - Edwin Sarmiento
Tomorrow Wednesday, August 12, 2015 at 6PM EDT, my friend and SQL MVP colleague, Edwin Sarmiento will be in town...
2015-08-11
1,181 reads
SQLSaturday #386 - SQLSaturday in Albany, NY
Coming this Saturday, upstate rules, the official capitol of New York State is #SQLSat386, in Albany! Check out their event...
2015-07-23
1,063 reads
PASS Performance Virtual Chapter’s 2015 Performance Palooza - TOMORROW! - 7/23
PASS HEADQUARTERS:
The PASS Performance Virtual Chapter’s 2015 Performance Palooza is
tomorrow starting at 10AM Central Time! This event will feature...
2015-07-22
1,222 reads
T-SQL Tuesday #68 - Just Say No to Defaults & Stay Healthy
Happy T-SQL Tuesday,
July 14, 2015! (I have been time traveling, and now back on this continuum ;-) @SQLBek, Andy Yun, has...
2015-07-22 (first published: 2015-07-07)
2,653 reads
SQLSaturday #410 - Chattanooga, TN - This Weekend!
Kicking off the SQLSaturday#410 event down in Chattanooga, Tennessee, is the Pre-Con event Tune Like a Guru, by SQLGuru Kevin...
2015-06-25
975 reads
SQLSaturday#379 South Florida - Coming up this weekend!
June 13, 2015 - SQLSat379: Just wanted to make mention of the upcoming SQLSaturday#379 down in South Florida, it will be...
2015-06-11
1,009 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