Creative IT Learning
If a successful IT career is just as much about tenacity, interest and retention as it is about brainpower, then how does one go about continuous learning?
2017-03-06
97 reads
Editorials
A Welcome Delay
An open letter to Microsoft from the CEO of Mandriva Linux might not have been the best idea.
2017-03-04 (first published: 2007-11-30)
368 reads
Null Defaults
Today Steve Jones asks what default values you might choose for new columns in a table.
2017-03-03
125 reads
Why I am Excited about SQL Server on Linux
Read why Solomon Rutzky is excited about SQL Server running on Linux.
2017-03-02
566 reads
2017-02-28
229 reads
Human and Machine Learning
Machine learning and AI are becoming more and more prevalent, which Steve Jones thinks is good.
2017-02-27
113 reads
The Secure Medical Data Challenge
This week Steve looks at the challenges of security for medical data.
2017-02-27
87 reads
The Cloud is Just a Tool
Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered.
2017-02-23
122 reads
Why Object Databases will always be Tomorrow's Technology
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
752 reads
Approaching Politics in IT
The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is probably going to lead to you being displeased with your fellow man. Luckily, we work in IT, so we can avoid politics. BWA-HA-HA-HA-HA! Politics goes way beyond […]
2017-02-20
126 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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