2017-07-21
123 reads
Editorials
2017-07-20
3,520 reads
2017-07-18
103 reads
Short Names
Today Steve Jones talks about the short cuts that developers might take, many of which aren't necessarily helpful.
2017-07-17
105 reads
Cool Projects
This week Steve Jones wants to know what type of really interesting projects you are working on. Is there something you really enjoy and look forward to building?
2017-07-14 (first published: 2013-08-23)
255 reads
How do you go about team building?
Team building isn't easy, but important for people to work together well.
2017-07-11
66 reads
Birds of a Feather
What makes SQL Server professionals stick together? Can we draw any conclusions from this?
2017-07-10
145 reads
2017-07-07
223 reads
2017-07-06
65 reads
Independence Day 2017
A holiday in the US has Steve Jones thinking about compromise and communication.
2017-07-04
52 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