Migrating Schema Between Platforms
The decision to change platforms isn't one Steve Jones takes lightly.
2017-06-20
81 reads
Editorials
DevOps Can Help
DevOps can help, not just development, but also infrastructure, if you spend time adapting the practices to your environment.
2017-06-19
43 reads
2017-06-19
202 reads
Your Job Description
This Friday Steve Jones talks about job posting and descriptions. This is the chance to think about what you do and how you might describe this to your replacement.
2017-06-16
106 reads
Securing the Things
The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.
2017-06-15
50 reads
2017-06-14
1,389 reads
2017-06-13
68 reads
Guilty of Over-Customising
Am I guilty of over-customising software? Read this and let us know what you think.
2017-06-12
106 reads
The Value of Surveys
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
2017-06-12
68 reads
SQL Server is Getting Smarter
SQL Server is becoming more capable all the time, requiring fewer human resources for basic management.
2017-06-08
90 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