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
- Announcing SQL Operations Studio for preview. From the intro: “SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.”. Hmm, I don’t know, haven’t looked at it yet - but the name sux!
- JSON parsing 10x faster than XML parsing. Jovan is busy writing posts about JSOn in SQL Server. In this post he compares performance of parsing JSON, with parsing XML. The title says it all!
- JSON vs CLR UDT – performance comparison. Another post from Jovan about JSON in SQL Server. This time he takes a stab at comparing performance, parsing JSON using SQLCLR vs. the nvarchar JSON implementation in SQL Server 2016+. Interesting stuff!
- SQL Server 2017: A proven leader in database performance. Bob Ward posts about SQL Server 2017 running away with performance benchmarks both for OLTP as well as analytics,
.NET
- Introducing Nullable Reference Types in C#. Huh, “nullable reference types” in C#? I thought reference types were nullable by default? Well this post talks about a future version of C# where reference types would not be nullable by default, but how you can express your intent of a nullable reference type with new syntax. Looks interesting!
- Introducing Tensor for multi-dimensional Machine Learning and AI data. I have categorized this post as .NET, but it could as easily be Data Science. Anyway, this is about a new .NET data type - Tensor - whose purpose is to make it easy for Machine Learning library vendors like CNTK, Tensorflow, Caffe, Scikit-Learn to port their libraries over to .NET with minimal dependencies in place.
SQL Server R Services
It looks like I finally will get the Binary eXchange Language post published (this will probably jinx it). I have most of the post done, and with some luck it should be out there sometime before next weekend.
~ 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.