Backups – They Are Needed, Who Knew?
Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at...
2015-04-06 (first published: 2015-03-30)
7,137 reads
The SQL Professor
Impact Series – Part 2
It’s that time again to add another impact player to the roster; this time for the month of February.
This month...
2015-02-27
947 reads
Impact Series – Part 2
It’s that time again to add another impact player to the roster; this time for the month of February.
This month...
2015-02-27
742 reads
Q and A With SQL MVP Chris Shaw
This has been a long time in the making, back in 2011 I attended a session at PASS Summit by...
2015-02-17
953 reads
TSQL Tuesday #63 – Security
This months T-SQL Tuesday is hosted by none other than Kenneth Fisher (B|T). His topic for this month revolves around...
2015-02-12
566 reads
Friends Of Red Gate 2015
I’m excited that I’ve been asked to be back involved for another year in the Friends of Red Gate program. This...
2015-01-27
516 reads
Impact Player Series – Part 1
I wanted to start this series in regards to impact players that go above and beyond in the SQL Community....
2015-01-26
573 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
552 reads
Impact Players – SQL Style
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date...
2015-01-12
423 reads
Reports In SSISDB
I was approached with an in shop issue where a group could not view the execution reports in the SSISDB....
2015-01-09 (first published: 2015-01-07)
10,713 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