Starting with R (as in SqlServer R server and VS package)

Part 1: Starting with R – installation : http://msprogrammer.serviciipeweb.ro/2016/10/03/starting-with-r-as-in-sqlserver-r-server-and-vs-package/

Part 2: Starting with R – language and data http://msprogrammer.serviciipeweb.ro/2016/10/10/starting-with-r-language-and-data/

Part 3: Starting with R – basic and statistics http://msprogrammer.serviciipeweb.ro/2016/10/17/starting-with-r-basic-and-statistics/

Part 4: Making diagrams with R ( and transformation of data) : http://msprogrammer.serviciipeweb.ro/2016/10/31/making-diagrams-with-r/

Part 5:  Forecasting currency exchange with R   http://msprogrammer.serviciipeweb.ro/2016/11/06/forecasting-eurbnr-currency-exchange/

First, start with installing Sql Server 2016 Developer ( free from https://www.microsoft.com/en-us/cloud-platform/sql-server-editions-developers )

Ensure that R is selected when installing.

Start SSMS ( Sql Server Management Studio) and ensure that R is configured and running ( https://msdn.microsoft.com/en-us/library/mt590884.aspx  or more detailed https://msdn.microsoft.com/en-us/library/mt696069.aspx )

Then install R Client from http://aka.ms/rclient/download ( see https://msdn.microsoft.com/en-us/library/mt696067.aspx ) . It features also an package for Visual Studio

Once you install R Client, start RGUI ( press Windows key and type RGUI ) .

In the window of RCLient, type getwd() ( R is case sensitive – does not work GetWD() )

( The same thing you can do in Visual Studio, from R Tools =>Windows=>R interactive)

Then you can follow the tutorial from https://msdn.microsoft.com/microsoft-r/scaler-getting-started# -  it is ok and easy to  reproduce.