Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
7 reads
Interview with Joe Sack
This is the seventh interview we have done. This time our guest is Joe Sack! Joe is Principal Program Manager for Azure SQL Database with a focus on query...
2019-10-03
6 reads
Weekly reading #27
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-01
27 reads
Weekly reading #27
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-01
3 reads
Interview with Greg Low
This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...
2019-09-27 (first published: 2019-09-17)
243 reads
Interview with Greg Low
This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...
2019-09-17
7 reads
Weekly reading #26
Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...
2019-09-17
23 reads
Weekly reading #26
Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by...
2019-09-17
5 reads
Weekly reading #25
It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...
2019-09-11
26 reads
Weekly reading #25
It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...
2019-09-11
4 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
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