2017-02-20
113 reads
Editorials
2017-02-16
115 reads
What Would You Do if Your Company Was Targeted?
Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.
2017-02-15
119 reads
Quality Provides Traction/Velocity
Quality is a driver for productivity. Or so say I. What do you think.
2017-02-14
94 reads
Problems With Database Problems
The GitLab crisis has Steve Jones thinking about two things: competence and care.
2017-02-13
121 reads
The Second Career
From a well-built cockney who knew how to avoid wheel clamps, to an ex-member of an elite anti-riot unit, some of the best DBAs have a surprising diversity of skills and experiences, according to Phil Factor.
2017-02-13
103 reads
Moving Through Five Years
An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.
2017-02-10
109 reads
Why Devops? For Better Security
DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.
2017-02-09
98 reads
2017-02-08
167 reads
A View of the Cloud
Today Steve Jones looks at how we can better build software by considering the cloud.
2017-02-06
78 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