Interesting Stuff - Christmas, New Year, Week 1

Throughout the week, I read a lot of blog-posts, articles, etc., that has to do with things that interest me:

This is the “roundup” of the posts that has been most interesting to me over the Christmas and New Year period.

SQL Server

Quite some JSON related topics in this roundup.

Building SQL REST API back-end for Angular apps. In this post Jovan (who is the SQL Server JSON “god”) shows how easy it is to build back-end REST API for Angular sample app using JSON functionalities in SQL Server.
Transitive closure clustering with CLR and JSON. Jovan shows how a transitive closure algorithm can be implemented using CLR aggregates that can be placed in SQL database.
Injecting JSON objects into existing JSON text with JSON_MODIFY function. Yet another post by “Mr. SQL Server JSON” - Jovan - showing how to update existing JSON text and inject JSON object in the text, avoiding some common mistakes.

KSQL December Release: Streaming SQL for Apache Kafka. A post about that is in the December release of the streaming SQL engine for Apache Kafka - KSQL.

A Machine Learning Approach to Databases Indexes. A white-paper about how traditional B-tree indexes potentially can be replaced with more flexible, faster, and smaller machine learned neural networks. Very interesting!!

WPaxos: a wide area network Paxos protocol (Part 1). Paxos is a protocol for solving the fault-tolerant coordination problem in a datacenter - and it is very good at what it is doing. However across datacenters the WAN latency may be too high. In this post Murat discusses an alternative to Paxos - WPaxos.
Entity Oriented Microservices. A very interesting article by David about Entity Services vs. Microservices vs. DDD.

DevOps for Data Science – Continuous Delivery. Buck Woody continues his series about DevOps for Data Science, and in this episode he discusses Continuous Delivery. A very interesting post as well as series!!
TensorFlow-Serving: Flexible, High-Performance ML Serving. Another post by Murat, this time about a system/framework to serve machine learning (ML) models.
Paper summary. Real-Time Machine Learning: The Missing Pieces. Murat has been busy the holiday period. In this post he dissects a white-paper about real time machine learning, and what is required. This is an area, I am really interested in BTW!!

During the holiday period I managed to get some work done on the Microsoft SQL Server R Services series:

Microsoft SQL Server R Services - Internals XVI. In Internals - XVI I talked about the result set data coming back from the SqlSatellite, and I looked at number of packets as well as packet sizes.
Microsoft SQL Server R Services - Internals XVII. Internals - XVII continues on from Internals - XVI, and looks at what happens inside SQL Server when result-set data comes back.

That’s all for this week. I hope you enjoy what I did put together. If you have ideas for what to cover, please comment on this post or ping me.