Saturday, June 11, 2016

What R language items are installed when you install SQL Server 2016?

R langugage support featured in SQL Server the  first time in SQL Server 2016. There were items  at isntallation time that explicitly shows the items.


Ritems_00 in help

The following items (RServer and R Services) were installed according to the above choice.

When you install SQL Server 2016 Developer you will be able to use the following:



SQL@2K16_defaultInstall


Also in the SQL Server Installation Center you can install a stand-alone Microsoft R Server by clicking the link in the installation center, if for some reason you do not find the Microsoft R Server in your search.

RServer_00

After installing SQL Server 2016 Developer edition you should be able to find the R Server related folders/files here:

R_Folder

R is Power full.
 
R is supposed to be the most powerful language when it comes to statistical processing of a large amount of data; machine learning and graphics. It is open, that means world is the player. Microsoft got into R for these strengths but still there were challenges when it comes to volume of data and deployment scenarios. The open software was further tuned for SQL Server to include in Microsoft R Server.

The Microsoft R product consists of the following:
  • Microsoft R Server
  • Microsoft R Client
  • Microsoft R Open
  • SQL Server R Services
You should jump into R if you are going to work with databases and specially analytics. Analytics is the future! believe me.

No comments: