You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/advanced-analytics/r/r-server-standalone.md
+8-7Lines changed: 8 additions & 7 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -45,21 +45,23 @@ SQL Server 2016 is R only. SQL Server 2017 supports R and Python. The following
45
45
| Python tools | The built-in Python command line tool is useful for ad hoc testing and tasks. Find the tool at \Program files\Microsoft SQL Server\140\PYTHON_SERVER\python.exe. |
46
46
| Anaconda | Anaconda is an open-source distribution of Python and essential packages. |
47
47
| Python samples and scripts | As with R, Python includes built-in data sets and scripts. Find the revoscalepy data at \Program files\Microsoft SQL Server\140\PYTHON_SERVER\lib\site-packages\revoscalepy\data\sample-data. |
48
-
| Pre-trained models in R and Python | Pre-trained models are supported and usable on a standalone server, but you cannot install them through SQL Server Setup. The setup program for Microsoft Machine Learning Server provides the models, which you can install free of charge. For more information, see [Install pretrained machine learning models on SQL Server](install-pretained-models-sql-server.md). |
48
+
| Pre-trained models in R and Python | Pre-trained models are supported and usable on a standalone server, but you cannot install them through SQL Server Setup. The setup program for Microsoft Machine Learning Server provides the models, which you can install free of charge. For more information, see [Install pretrained machine learning models on SQL Server](install-pretrained-models-sql-server.md). |
49
49
50
50
## Get started step-by-step
51
51
52
-
### Step 1: Install
53
-
54
52
Start with setup, attach the binaries to your favorite development tool, and write your first script.
55
53
56
-
+[SQL Server 2017 Machine Learning Server (standalone)](../install/sql-machine-learning-standalone-windows-install.md) or [SQL Server 2016 R Server (Standalone)](../install/sql-r-standalone-windows-install.md)
54
+
### Step 1: Install the software
55
+
56
+
Install either one of these versions:
57
+
58
+
+[SQL Server 2017 Machine Learning Server (standalone)](../install/sql-machine-learning-standalone-windows-install.md)
59
+
+[SQL Server 2016 R Server (Standalone) - R only](../install/sql-r-standalone-windows-install.md)
57
60
58
61
### Step 2: Configure a development tool
59
62
60
63
Configure your development tools to use the Machine Learning Server binaries. For more information about Python, see [Link Python binaries](https://docs.microsoft.com/machine-learning-server/python/quickstart-python-tools). For instructions on how to connect in R Studio, see [Using Different Versions of R](https://support.rstudio.com/hc/en-us/articles/200486138-Using-Different-Versions-of-R) and point the tool to C:\Program Files\Microsoft SQL Server\140\R_SERVER\bin\x64. You could also try [R Tools for Visual Studio](https://docs.microsoft.com/visualstudio/rtvs/installation).
61
64
62
-
63
65
### Step 3: Write your first script
64
66
65
67
Write R or Python script using functions from RevoScaleR, revoscalepy, and the machine learning algorithms.
@@ -68,8 +70,7 @@ Write R or Python script using functions from RevoScaleR, revoscalepy, and the m
68
70
69
71
+[Quickstart: An example of binary classification with the microsoftml Python package](https://docs.microsoft.com/machine-learning-server/python/quickstart-binary-classification-with-microsoftml): Create a binary classification model using the functions from microsoftml and the well-known breast cancer dataset.
70
72
71
-
72
-
73
+
Choose the best language for the task. R is best for statistical computations that are difficult to implement using SQL. For set-based operations over data, leverage the power of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to achieve maximum performance. Use the in-memory database engine for very fast computations over columns.
Copy file name to clipboardExpand all lines: docs/advanced-analytics/r/sql-server-r-services.md
+16-12Lines changed: 16 additions & 12 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -49,15 +49,19 @@ SQL Server 2016 is R only. SQL Server 2017 supports R and Python. The following
49
49
| Python tools | The built-in Python command line tool is useful for ad hoc testing and tasks. Find the tool at \Program files\Microsoft SQL Server\140\PYTHON_SERVER\python.exe. |
50
50
| Anaconda | Anaconda is an open-source distribution of Python and essential packages. |
51
51
| Python samples and scripts | As with R, Python includes built-in data sets and scripts. Find the revoscalepy data at \Program files\Microsoft SQL Server\140\PYTHON_SERVER\lib\site-packages\revoscalepy\data\sample-data. |
52
-
| Pre-trained models in R and Python | Pre-trained models are supported and usable on a standalone server, but you cannot install them through SQL Server Setup. The setup program for Microsoft Machine Learning Server provides the models, which you can install free of charge. For more information, see [Install pretrained machine learning models on SQL Server](install-pretained-models-sql-server.md). |
52
+
| Pre-trained models in R and Python | Pre-trained models are supported and usable on a standalone server, but you cannot install them through SQL Server Setup. The setup program for Microsoft Machine Learning Server provides the models, which you can install free of charge. For more information, see [Install pretrained machine learning models on SQL Server](install-pretrained-models-sql-server.md). |
53
53
54
54
## Get started step-by-step
55
55
56
-
### Step 1: Install
57
-
58
56
Start with setup, attach the binaries to your favorite development tool, and write your first script.
59
57
60
-
+ Install the server: [SQL Server 2017 Machine Learning Services (In-Database)](install/sql-machine-learning-services-windows-install.md) or [SQL Server 2016 R Services (In-Database)](install/sql-r-services-windows-install.md)
58
+
### Step 1: Install the software
59
+
60
+
Install either one of these versions:
61
+
62
+
+[SQL Server 2017 Machine Learning Services (In-Database)](../install/sql-machine-learning-services-windows-install.md)
63
+
64
+
+[SQL Server 2016 R Services (In-Database) - R only](../install/sql-r-services-windows-install.md)
61
65
62
66
### Step 2: Configure a development tool
63
67
@@ -79,14 +83,16 @@ With in-database analytics in SQL Server, there is no need to change this proces
79
83
80
84
Call R or Python functions from within T-SQL script:
81
85
82
-
+[R: Use R code in Transact-SQL](tutorials/rtsql-using-r-code-in-transact-sql-quickstart.md)
83
-
+[R: In-database analytics for SQL developers](tutorials/sqldev-in-database-r-for-sql-developers.md)
84
-
+[Python: Run Python using T-SQL](tutorials/run-python-using-t-sql.md)
85
-
+[Python: In-database analytics for SQL developers](tutorials/sqldev-in-database-python-for-sql-developers.md)
86
+
+[R: Use R code in Transact-SQL](../tutorials/rtsql-using-r-code-in-transact-sql-quickstart.md)
87
+
+[R: In-database analytics for SQL developers](../tutorials/sqldev-in-database-r-for-sql-developers.md)
88
+
+[Python: Run Python using T-SQL](../tutorials/run-python-using-t-sql.md)
89
+
+[Python: In-database analytics for SQL developers](../tutorials/sqldev-in-database-python-for-sql-developers.md)
90
+
91
+
Choose the best language for the task. R is best for statistical computations that are difficult to implement using SQL. For set-based operations over data, leverage the power of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to achieve maximum performance. Use the in-memory database engine for very fast computations over columns.
86
92
87
93
### Step 4: Optimize your solution
88
94
89
-
When the model is ready to scale on enterprise data, the data scientist will often work with the DBA or SQL developer to optimize processes such as:
95
+
When the model is ready to scale on enterprise data, the data scientist often works with the DBA or SQL developer to optimize processes such as:
90
96
91
97
+ Feature engineering
92
98
+ Data ingestion and data transformation
@@ -98,14 +104,12 @@ Traditionally data scientists using R have had problems with both performance an
98
104
99
105
+**revoscalepy**. This Python library, available in SQL Server 2017, implements the most popular functions in RevoScaleR, such as remote compute contexts, and many algorithms that support distributed processing.
100
106
101
-
+ Choose the best language for the task. R is best for statistical computations that are difficult to implement using SQL. For set-based operations over data, leverage the power of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to achieve maximum performance. Use the in-memory database engine for very fast computations over columns.
102
-
103
107
**Resources**
104
108
105
109
+[Performance Case Study](../../advanced-analytics/r/performance-case-study-r-services.md)
106
110
+[R and Data Optimization](../../advanced-analytics/r/r-and-data-optimization-r-services.md)
107
111
108
-
## Step 5: Deploy and Consume
112
+
###Step 5: Deploy and Consume
109
113
110
114
After the script or model is ready for production use, a database developer might embed the code or model in a stored procedure, so that the saved R or Python code can be called from an application. Storing and running R code from [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] has many benefits: you can use the convenient [!INCLUDE[tsql](../../includes/tsql-md.md)] interface, and all computations take place in the database, avoiding unnecessary data movement.
0 commit comments