First published on MSDN on Mar 22, 2017
is the new and exciting ML packages added to Microsoft R Server 9.0.1 which offers increased speed, performance and scalability, especially for scenarios like deep neural network with GPU acceleration and highly-dimensional categorical data.
There has been some confusions on where to download MicrosoftML to get your hands on algorithms like rxFastLiner, rxFastTress and rxNeuralNet, especially when you plan to use MicrosoftML in SQL Server compute context. In this article, I will outline how can you download MicrosoftML and use MicrosoftML in SQL Server 2016.
If you installed Microsoft SQL Server VNext
You have the latest R Server bits that enable you to run MicrosoftML packages, you can start right away developing model in MicrosoftML. Just load MicrosoftML library in SSMS using the following script:-
If you installed Microsoft SQL Server 2016 RTM or SQL Server 2016 SP1
MicrosoftML shipped in R Server version 3.3.2. If you have installed and setup SQL Server 2016 RTM or SQL Server 2016 SP1, the R version shipped is version 3.2.2. You can run a simple sessionInfo script to verify in SQL Server Management Studio (SSMS).
In my machine that had SQL Server RTM installed, you can see that the
R version is 3.2.2
which does not have the MicrosoftML package shipped with it.
Binding R Component
In order to upgrade R Services to run MicrosoftML, we need to use a tool called
to upgrade the R components associated with an instance of R services. This process is called
. Binding allows you to upgrade the R instance to receive the most recent updates in Microsoft R Server packages. This is especially critical to a data scientist given R is progressing much faster and having more frequent updates in R packages. However, before explaining where to download SQLBindR and run SQLBindR, we need to understand the implication of binding from support policy perspective.
SQL Server supports 5 year mainstream and 5 year extended support. R Server and SQL Server R services adhere to the same SQL Server support policy. If you decide to receive most recent updates in R components, the support policy for R Server and R Services change from 5+5 to
Modern Lifecyle Policy
in which customer must stay current in the
product version to receive servicing updates.
For more details on binding, unbinding, and support policy implications, please refer to the
: you need to copy
in two locations in your system - 1.
which contains RServerSetup.exe. 2. Temp folder which is \Users<account-name>\AppData\Local\Temp. You may run into setup error if you do not copy to the %temp% folder.
few good examples using different MicrosoftML algorithms:-