SQL machine learning documentation

Learn how to use machine learning on SQL to run Python and R on relational data, both on-premises and in the cloud. Tutorials, code examples, installation guides, and other documentation show you how to use SQL machine learning.

Machine learning on SQL Server

Overview

• What is SQL Server Machine Learning Services with Python and R?

Get Started

• Install Machine Learning Services on Windows
• Install Machine Learning Services on Linux

video

• How to Execute R/Python in SQL Server with Machine Learning Services

Get started with Python

Quickstart

• Run simple Python scripts
• Handle inputs and outputs
• Use Python data structures in SQL
• Train and use your first model

Tutorial

• Predict ski rental with linear regression
• Categorizing customers using k-means clustering

Get started with R

Quickstart

• Run simple R scripts
• Handle inputs and outputs
• Use R data structures in SQL
• Train and use your first model

Tutorial

• Predict ski rental with decision tree
• Categorizing customers using k-means clustering

Azure SQL Managed Instance

Overview

• Machine Learning Services in Azure SQL Managed Instance
• Key differences between ML in Azure SQL Managed Instance and SQL Server

How-To Guide

• Deploy and make predictions with an ONNX model in Azure SQL Managed Instance

Azure SQL Edge

Overview

• Machine learning and AI with ONNX in Azure SQL Edge

How-To Guide

• Deploy and make predictions with an ONNX model in Azure SQL Edge

Azure Data Studio ML extension

Overview

• What is the Machine Learning extension for Azure Data Studio?

How-To Guide

• Manage packages in database
• Make predictions
• Import or view models

SQL Server Big Data Clusters

Overview

• What are SQL Server Big Data Clusters?

Get Started

• Enable Machine Learning Services on SQL Server Big Data Clusters

How-To Guide

• Spark machine learning models with MLeap
• Sparklyr in SQL Server Big Data Cluster
• Integrate Spark with SQL Server

Azure Synapse Analytics

Overview

• Machine Learning capabilities in Azure Synapse Analytics
• Train machine learning models

Quickstart

• Create a new Azure Machine Learning linked service in Synapse

Tutorial

• Train a model in Python with automated machine learning
• Build a machine learning app with Apache Spark MLlib and Azure Synapse Analytics