2017-12-13
71 reads
Editorials
Advice for Newcomers
If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.
2017-12-12 (first published: 2014-04-18)
699 reads
2017-12-11
84 reads
2017-12-11
47 reads
The Relational Database is the Default
If you don't have a good reason not to, use a relational database. Always.
2017-12-07
105 reads
2017-12-06
91 reads
A Christmas Bug
A bug in American Airlines scheduling could impact travelers, but certainly will impact their bottom line.
2017-12-04
97 reads
The Appearance of the Flat File Wizard.
After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.
2017-12-04
89 reads
Certifying Schools
Schools don't necessarily teach people how to code, but they could do a better job.
2017-11-30
90 reads
2017-11-29
187 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