2017-09-14
102 reads
Editorials
A Backup Change
Steve Jones talks about backup of data today and the challenges of managing this at scale.
2017-09-13
54 reads
The Randomness of Analog
A look back at the random nature of finding information in libraries and bookstores. A feeling Steve Jones misses.
2017-09-12
68 reads
2017-09-11
81 reads
The struggle to renormalize data
You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.
2017-09-11
217 reads
The Control Poll
Do you use version control for your databases? For your application code? Is there a time when you think it's not needed? Steve Jones asks the question today.
2017-09-08 (first published: 2013-05-17)
164 reads
Using Tools that Fit
Equipment can matter for IT professionals. Read a few thoughts from Andy Warren.
2017-09-07
66 reads
2017-09-06
270 reads
2017-09-05
315 reads
SQL Server in Space - HASSP
A successful launch, and recovery, of SQL Server running below a balloon.
2017-09-04
81 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