DBA relationships – The data custodian
G’day,
As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right...
2011-04-28
2,274 reads
Blog Posts
DevConnections – Heavily Discounted Passes !
DevConnections – London June 2011
DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of £100!!!
The first...
2011-04-28
704 reads
Drop the Noise
I’m reading Tim Ferriss’ “The Four Hour Work Week” (FHWW) right now, and it’s got me thinking about (among other...
2011-04-28
1,461 reads
Have You Heard? You Can Get a Mentor
Steve Jones and Andy Warren are at it again. The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new...
2011-04-28
709 reads
Have You Heard? You Can Get a Mentor
Steve Jones and Andy Warren are at it again. The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new program, The Mentoring Experiment, to try to match professionals...
2011-04-28
6 reads
How to determine the current SSIS runtime environment
If you want to test if you’re currently debugging an SSIS package via BIDS/Visual Studio, or running normally via DTExec,...
2011-04-28
2,412 reads
MS Certs Exam price is rising …
Today Marlon Ribunal twittes come with new info about MS Certifications exams are rising…
This is not a good news, so...
2011-04-28
749 reads
Powershell Day 28
Day 27 SQL Policy I highly recommand to go through the Policy –based management (BCM)’s official excellent site to learn...
2011-04-28
518 reads
SQL University: SQL Azure & PowerShell
Welcome once more to the Miskatonic branch of SQL University. I see that most off you survived out last encounter…...
2011-04-28
1,728 reads
SQLSat 83 – Johannesburg
Awesome news. I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011. I saw that...
2011-04-28
1,721 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