Being Responsible for Code
How responsible should developers be for their code? Facebook has an interesting way of looking at their engineers' performance.
2012-04-30
269 reads
Editorials
When Will You Upgrade to SQL Server 2012?
Having noticed a very low rate of migration to the latest version of SQL Server, Brad McGehee asks - when will you upgrade to 2012?
2012-04-30
732 reads
Security Outside the Database
Database security needs to improve, and while SQL Server continues to get better, there is more work to do. However there are plenty of security issues outside the database that also need to be addressed.
2012-04-26
180 reads
Technology for Sharing
Technology has been great for helping us work more efficiently by better sharing resources. Steve Jones sees this as both good and bad in different ways as well as a way of providing new opportunities.
2012-04-25
73 reads
Smelly Power
Power is a limited resource, but one that's required for computing. Microsoft has a new idea for generating power data centers that Steve Jones likes.
2012-04-24
162 reads
Buggy Forever
This week Steve Jones talks about forever day bugs, those bugs in industrial systems that haven't been patched, and are not likely to be ever fixed.
2012-04-23
116 reads
Social Media and Interviews
The requirement to disclose social media credentials to some employers has Steve Jones worried.
2012-04-23
154 reads
Small Management
This editorial was originally published on June 21, 2007. It is being republished as Steve is traveling. Today we take a poll on administration and management from devices smaller than a laptop.
2012-04-20
91 reads
Social Data Analysis
Today we have an editorial originally published on June 24, 2007. It is being republished as Steve is traveling. IBM has done some work to help people analyze sets of data with new visualizations.
2012-04-18
112 reads
The Best of the Best
Today's editorial was originally pubished on June 26, 2007. It is being re-run today as Steve is traveling. What were the best places to work in 2007? Steve Jones links to a list and talks about the value of using those lists.
2012-04-17
188 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