I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild guess. They restrict the amount of time that I can spend in preparation and research so that I can do things right; they squeeze the artistic quality out of my work as a […]
2017-05-01
55 reads
Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.
2017-04-28
141 reads
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
2017-04-27
100 reads
The path to becoming a data scientist isn't simple or easy, but it might be for you.
2017-04-26
187 reads
2017-04-25
259 reads
Have you ever given up on your brainchild? If yes, how did you deal with it?
2017-04-24
113 reads
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
2017-04-24
80 reads
It takes a creative mind to come up with new ideas. So how do you do it?
2017-04-21
111 reads
2017-04-20
366 reads
SQL Server captures information about usage and send it to Microsoft. Is that a problem? Not for Steve Jones.
2017-04-18
865 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers