Basics of R and Python Execution in SQL Server

In a previous post, we talked about how to set up Machine Learning Services in SQL Server. Now I will cover the basics of how to Execute R and Python in T-SQL statements. The video below will help you understand the basic syntax, parameter names, and data types used. I also summarized the key steps…

0

Getting Started with Machine Learning Services in SQL Server

I would like to introduce you to some simple videos that will help you get started with Machine Learning Services in SQL Server. The videos below cover how to install and enable Machine Learning Services. After completing the instructions found here, you will be ready to execute R and Python in SQL Server. I summarized…

0

Getting Started with Python Web Services using Machine Learning Server

Machine Learning Server 9.2 adds support for the full data science lifecycle of your Python-based analytics. In this article, we will go through step by step details of implementing data science lifecycle using Python. These steps include : Creating a VM configured as One-Box [using ARM Templates] Developing python models [using revoscalepy, microsoftml packages in any IDE]…


Pre-trained AlexNet model for MicrosoftML’s rxNeuralNet

The rxNeuralNet model in MicrosoftML package supports custom neural networks defined using the NET# language. We can use the NET# language to define a convolutional neural network. In this blog we will give a NET# definition string for the AlexNet model. The model is a direct conversion of the Caffe implementation. It’s worth noting that an R implementation of AlexNet is barely available at the time this…


Running MicrosoftML in SQL Server 2016

MicrosoftML 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,…


Predicting NYC Taxi Tips using MicrosoftML

MicrosoftML is a new package for Microsoft R Server that adds state-of-the-art algorithms and data transforms to Microsoft R Server functionality. MicrosoftML includes these algorithms: Fast linear learner, with support for L1 and L2 regularization. Fast boosted decision tree. Fast random forest. Logistic regression, with support for L1 and L2 regularization. GPU-accelerated Deep Neural Networks…


Microsoft R Server 9.0.1 is Packed with Exciting New Capabilities

Microsoft R Server has just released a feature-packed version 9.0.1. Customers can download from MSDN from this link. Enterprise customers with EA agreement will be able to download from Microsoft Volume Licensing Software Center in January 2017. There are major enhancements and brand new face lifts in some of the capabilities in Microsoft R Server that worth mentioning: -…