The Next Generation DBA
DBA, database developer, analyst, SQL grunt, or whatever your title may be, there is no question that your role will...
2008-12-02
795 reads
Tim Mitchell
[Off Topic] Web host is down
For my colleagues and friend who visit my websites (www.bucketofbits.com, www.tyleris.com, www.timmitchell.net), I just discovered that my web host has...
2008-12-01
794 reads
Microsoft Certified Master program – Is This The Answer to Certification Woes?
In the past few years, many people - myself included - have expressed a desire to see the quality of the Microsoft...
2008-11-29
1,709 reads
Does regulation make data any safer?
Working with healthcare organizations, I am constantly aware of the restrictions my staff and I must abide by according to HIPAA constraints. ...
2008-11-27
1,670 reads
Raising the Bar
Turning up the heat. Take it up a notch. Stepping up to the plate. Less talk, more action.
However you choose...
2008-11-24
1,636 reads
Immersed in work, and missing out on everything else
After 2 years working on a data conversion and software implementation project, I’ve finally started to get caught up on...
2008-11-24
1,663 reads
Vista, Day 5
I broke down and bought my first Vista machine last Sunday, an HP Pavilion from a local box store. From...
2008-11-21
599 reads
SMO Videos on JumpStartTV.com
Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the...
2008-09-28
1,670 reads
Data Quality, Part 1: The Discovery
I wrote a post a few months back about a healthcare data conversion project that I’ve been working on for...
2008-09-28
1,963 reads
Defining Value
I've been thinking a lot lately about the concept of value. Earlier this week a colleague of mine tendered his...
2008-08-29
1,458 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