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


Data Science

  • Passing two SQL queries to sp_execute_external_script. The procedure sp_execute_external_script which is used to execute R or Python scripts, has an input parameter: @input_data_1. It is used to input a dataset to the external script. Based on the name you might expect that there would be more parameters for input of data (@input_data_2, @input_data_3, etc.) However, that is not the case, and there has been quite a few questions on various newsgroups what to do if you want to send in multiple datasets. In this blog-post, Tomaz, shows a way you can achieve to input multiple datasets. Cool!!
  • Running R scripts on Azure Function. Serverless computing is really an “in thing”, and in AWS you have Lambda, and in Azure; Azure Functions (geez, what is it with Microsoft and naming of stuff?). Anyway Thomas Delteil from Microsoft shows how you can deploy a R scripts on Azure Function.
  • Data Science: Start at the very Beginning, It’s a very good place to start. Buck Woody posts about two different types of data science projects, and which type of project won’t work, and why.

~ 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