2017-06-06
101 reads
Editorials
2017-06-05
82 reads
Wanna Cry? Me too
I don’t doubt for a minute that on a certain level you’re sick to death of people talking about the Wanna Cry ransomware. However, bear with me, we need to go through it just a little more because it actually has some bearing on us as data professionals. OK, more than some bearing, it’s a […]
2017-06-05
190 reads
Presentations that are Easy on the Eyes
Today Steve Jones talks presentations, specifically the best way to share information on a projector.
2017-06-02
174 reads
Consider the Downside
Steve Jones asks software developers to consider the issues we may have with lax internal security.
2017-06-01
90 reads
DNA for Data Storage
Data storage is something all data professionals need to care about, and today Steve Jones talks about a research project from Microsoft.
2017-05-31
104 reads
2017-05-30
58 reads
2017-05-29
40 reads
The Rate of Change of Data
Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.
2017-05-29
102 reads
Do I Need to Learn Linux and R and Python?
The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.
2017-05-26
850 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