Interesting Stuff - Week 28

Throughout the week, I read a lot of blog-posts, articles, etc., 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 is the “roundup” of the posts that has been most interesting to me, for the week just gone by.

SQL Server

This weeks SQL Server topic, has quite a lot about graph databases. This is an interesting subject seeing SQL Server 2017’s built-in graph capability.

Do we need specialized graph databases? Benchmarking real-time social networking applications. In this white paper dissection, Andrew queries the need for specialized graph databases. Please read and judge for yourselves.
SQL Graph Objects in SQL Server 2017: the Good and the Bad. Dennes Torres has a really great blog-post about the graph capabilities in SQL Server 2017.
What’s in a name? How should SQL Server 2017 Graph Edge tables be named?. Based on the post by Dennes (mentioned above), Greg Low posts some thoughts about naming of edge tables in graph databases.
Setting up SQL Server High-Availability between Windows and Linux with SQL Server 2017. Slava Oks and Tobias Ternström (the “SQL Server on Linux” Brothers) talks about how to set up SQL server 2017 for high availability between Linux and Windows.

Streaming

Complex Event Generation for Business Process Monitoring using Apache Flink. Blog-post about how Apache Flink is being used for Complex Event Processing (CEP).

.NET

This week I came across two very interesting blogs, that cover the “nitty-gritty” of .NET, and here follows a couple of really interesting posts.

Value Types vs Reference Types. I certainly hope that every single .NET developer knows about value types and reference types, but I bet that this post by Adam Sitnik will blow everyones mind away, when he drills deep, deep into value types and reference types!
Memory Usage Inside the CLR. Another deep, deep drilling post about .NET. This time by Matthew Warren, and he goes into details about internal CLR memory! You gotta read it, it is awesome!
Span. Oooh, this is “sexy”! Adam Sitnik posts about how to work with both managed and unmanaged memory in ,NET in a safe and efficient way!

Data Science

Set up an auto-scale environment to operationalize your R analytics, with just ONE CLICK. How to set up an auto-scale environment for operationalization of R analytics using Azure and Microsoft R Server.

SQL Server R Services

Microsoft SQL Server R Services - Internals VII. I finally managed to get the Internals - VII post out there! I do apologize it took so long. Anyway, here we look at what files and sub-directories are created - and by whom - when executing an external R script.

I am busy working on Microsoft SQL Server R Services - Internals VIII, and hopefully it won’t take as long as VII.

~ 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.