Interesting Stuff - Week 6, 2020

Posted by nielsb on Sunday, February 9, 2020

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

  • data science
  • data in general
  • distributed computing
  • SQL Server
  • transactions (both db as well as non db)
  • and other “stuff”

This blog-post is the “roundup” of the things that have been most interesting to me, for the week just ending.

Azure SQL Server

  • Autoscaling Azure SQL Hyperscale. Azure SQL Hyperscale is the latest architectural model fro Azure SQL Database. It allows for a complete separation of compute nodes and storage nodes, which makes it possible to independently scale each service, making Hyperscale more flexible and elastic. The article linked to here describes how it is possible to implement a solution to automatically scale Azure SQL Hyperscale database up or down, to dynamically and automatically adapt to different workload levels.

Streaming

  • Building a Materialized Cache with ksqlDB. This post is excellent, and the title says it all: how to create materialized caches using Kafka and ksqlDB! At Derivco we are looking at this right now, so the post came in the right time.
  • Primitive Keys in ksqlDB. In this post Robin Moffat looks at a new feature in ksqlDB 0.7: support for message keys as primitive data types other than just strings. This new feature is very welcome, especially for us who stream database data into ksqlDB where the keys are integers.
  • Keystone Real-time Stream Processing Platform. The article linked to here is from the Netflix Tech Blog, and it discusses one of Netflix’s system for real-time stream processing. As with the post mentioned above about materialized caches this post gives us at Derivco some food for thoughts.

~ Finally

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.


comments powered by Disqus