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
- The SQL Hall of Shame. My old friend Adam Machanic asked for input from the SQL Server community, of “useless” features of SQL Server. This blog-post is the result. Some of the “features” submitted, I agree wholeheartedly with, others not so much. Among the ones I question are SQLCLR, as well as in-memory (Adam is on my side with those two).
- TPC-H Benchmarking with SQL Server on Linux. A Channel 9 presentation, where Slava Oks and my compatriot Tobias Ternstrom talks about how they have managed to get awesome performance out of SQL Server on Linux.
Data Science
- Data Science Walkthrough with SQL Server 2017 and Microsoft Machine Learning Services. Back in late April (this year - 2017), when SQL Server 2017 CTP 2.0 was introduced, I wrote a short post about running Python in SQL Server 2017. This post, is a complete walk through, how Python can be used in SQL Server 2017.
- Syberia: A development framework for R code in production. The guys at Revolution Analytics posts about a development framework for R: Syberia.
- Installing R packages with rxInstallPackages in Microsoft R Server. Tomaz blogs about new functionality in MicrosoftML, to help with installing new packages in SQL Server R Services, as well as Microsoft R Server.
- Demo: Real-Time Predictions with Microsoft R Server. David from Revolution Analytics blogs about a presentation he did at the R/Finance 2017 conference in Chicago in May. The presentation was about predicting fraud at a rate of 1 million transactions a second, using Microsoft R Server. The post links to a video of the presentation, and it also has links to the code used. It is well worth having a look at!
SQL Server R Services
For you who wonder about my SQL Server R Services series, I should be able to publish episode VII this coming week sometime.
~ 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.