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
- Where do SQL Server tasks come from?. Ewald continues his tales, about thread and tasks and other cool stuff, from last week when he spoke about SQLOS threads. This time he looks at how threads and tasks fit together. I really, really like what he writes about, seeing that is deep down in SQLOS (and he uses WinDbg a lot :) ).
- SQL Server Memory Accounting: Aligning Perfmon & DMVs. Lonny writes a very interesting article about squaring up what you see in SQL Server performance counters with what you get from DMV’s.
.NET
- .NET Application Architecture Guidance. The .NET team has published some free eBooks as guidance to application architecture, especially microservices and container based applications (at least that’s the ones I am interested in).
- Get Started with F# as a C# developer. A nice introduction for C# developers how to get started with F#.
- Performance Improvements in RyuJIT in .NET Core and .NET Framework. A blog-post pointing out some of the improvements that have gone into the RyuiJIT compiler for .NET Core (x64 and x86) as well as .NET Framework (x64). Pretty impressive stuff!
Data Science
- Passing two SQL queries to sp_execute_external_script. The procedure
sp_execute_external_scriptwhich 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.