Serverless
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
2019-05-02
363 reads
Editorials
Are you a Data Scientist?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
2019-05-01 (first published: 2015-09-29)
586 reads
Guest editorial: SQL Code Metrics
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
2019-04-30 (first published: 2009-02-17)
645 reads
2019-04-29 (first published: 2015-09-14)
320 reads
2019-04-27
164 reads
2019-04-26
230 reads
The Database Giveth and Taketh Away
A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.
2019-04-25
303 reads
Can Azure Stack Reduce Software Development Costs?
Azure Stack provides a hybrid cloud infrastructure platform. Steve wonders if this really helps reduce software development costs.
2019-04-24
212 reads
Changing Context and Data Reuse
We don't have strong data consent rules in the US, but Steve thinks we should.
2019-04-23
262 reads
Protecting Data Between Services
Microsoft is shutting down HealthVault, which means that customers need to manage their records. That's a challenge for many people.
2019-04-22
175 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