Run R and Python Remotely in SQL Server from Jupyter Notebooks or any IDE

Did you know that you can execute R and Python code remotely in SQL Server from any IDE? This eliminates the need to move data around. Instead of transferring large and sensitive data over the network or losing accuracy with sample csv files, you can have your R/Python code execute within your database. You can work in Jupyter…

0

How we are fixing our installer for Microsoft R Open on Linux

This post is authored by Nagesh Pabbisetty, Partner Director of Program Management at Microsoft. On Monday, we were alerted to an issue in the Microsoft R Open install script on Linux-based systems, including Debian. We appreciate that Norbert Preining highlighted the problem. This blog describes what went wrong, what we learned and what we are…


Build Your Own Image Similarity Model

The Image Similarity with SQL Server solution on the Azure AI Gallery demonstrates how to apply transfer learning, incorporating a pretrained deep neural network (DNN) model (trained on ImageNet) to the problem of finding images that are similar to a target image. In this solution, we use an image based product recommendation scenario as an…

0

How to operationalize Keras models in Microsoft Machine Learning Server

Microsoft Machine Learning Server’s operationalization feature enables data scientists to operationalize their R and Python analytics. In this blog, we will see how to operationalize Keras models as web services in R and Python. Click here to know more about Microsoft Machine Learning Server Operationalization. You can configure Machine Learning Server to operationalize analytics on a single…

0

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

Build Your Own Text Classification Model

In a support center, text needs to be quickly routed to the correct person. Chatbots need to turn text into different scenarios to be addressed. Sentiment analysis determines whether text is positive, negative, or neutral. In all three of these examples, machine learning models can help. The Text Classification solution on the Azure AI Gallery…

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

On-Prem or On the Cloud

Learn more about SQL Server Machine Learning Services in the Azure AI Gallery If you store your data in SQL Server 2016 or above, you should know about SQL Server Machine Learning Services (ML Services). Instead of moving data out of SQL to perform analytics, ML Services allows you to move the analytics (in R…

0

Configuring Microsoft Machine Learning Server 9.3 to Operationalize Analytics using ARM Templates

Microsoft Machine Learning Server 9.3 released today. Operationalization refers to the process of deploying R and Python models to Machine Learning Server in the form of web services and the subsequent consumption of these services within client applications to deliver business results. We have now introduced Command Line Interface (CLI) for Machine Learning Server operationalization, making configuration both easy and…