Skip to content

Commit 628f695

Browse files
committed
Consolidated the in-db get started & overview, set up redirect, deleted the original gs file
1 parent 0dd0ccc commit 628f695

4 files changed

Lines changed: 29 additions & 147 deletions

File tree

.openpublishing.redirection.json

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -75,6 +75,11 @@
7575
"redirect_url": "/sql/advanced-analytics/r/r-server-standalone",
7676
"redirect_document_id": false
7777
},
78+
{
79+
"source_path": "docs/advanced-analytics/r/getting-started-with-sql-server-r-services.md",
80+
"redirect_url": "/sql/advanced-analytics/r/sql-server-r-services",
81+
"redirect_document_id": false
82+
},
7883
{
7984
"source_path": "docs/linux/sql-server-linux-azure-virtual-machine.md",
8085
"redirect_url": "/azure/virtual-machines/linux/sql/provision-sql-server-linux-virtual-machine",

docs/advanced-analytics/r/getting-started-with-sql-server-r-services.md

Lines changed: 0 additions & 128 deletions
This file was deleted.

docs/advanced-analytics/r/r-server-standalone.md

Lines changed: 8 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -45,21 +45,23 @@ SQL Server 2016 is R only. SQL Server 2017 supports R and Python. The following
4545
| 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. |
4646
| Anaconda | Anaconda is an open-source distribution of Python and essential packages. |
4747
| 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). |
4949

5050
## Get started step-by-step
5151

52-
### Step 1: Install
53-
5452
Start with setup, attach the binaries to your favorite development tool, and write your first script.
5553

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)
5760

5861
### Step 2: Configure a development tool
5962

6063
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).
6164

62-
6365
### Step 3: Write your first script
6466

6567
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
6870

6971
+ [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.
7072

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.
7374

7475
## Related machine learning products
7576

docs/advanced-analytics/r/sql-server-r-services.md

Lines changed: 16 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -49,15 +49,19 @@ SQL Server 2016 is R only. SQL Server 2017 supports R and Python. The following
4949
| 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. |
5050
| Anaconda | Anaconda is an open-source distribution of Python and essential packages. |
5151
| 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). |
5353

5454
## Get started step-by-step
5555

56-
### Step 1: Install
57-
5856
Start with setup, attach the binaries to your favorite development tool, and write your first script.
5957

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)
6165

6266
### Step 2: Configure a development tool
6367

@@ -79,14 +83,16 @@ With in-database analytics in SQL Server, there is no need to change this proces
7983

8084
Call R or Python functions from within T-SQL script:
8185

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.
8692

8793
### Step 4: Optimize your solution
8894

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:
9096

9197
+ Feature engineering
9298
+ Data ingestion and data transformation
@@ -98,14 +104,12 @@ Traditionally data scientists using R have had problems with both performance an
98104

99105
+ **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.
100106

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-
103107
**Resources**
104108

105109
+ [Performance Case Study](../../advanced-analytics/r/performance-case-study-r-services.md)
106110
+ [R and Data Optimization](../../advanced-analytics/r/r-and-data-optimization-r-services.md)
107111

108-
## Step 5: Deploy and Consume
112+
### Step 5: Deploy and Consume
109113

110114
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.
111115

0 commit comments

Comments
 (0)