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
Jump-start your entry into machine learning by getting this complete machine learning solution from the Azure Marketplace. The data science virtual machine (frequently shortened to "DSVM") includes SQL Server, Microsoft Machine Learnign Server, and all development tools.
70
+
Jump-start your entry into machine learning by getting this complete machine learning solution from the Azure Marketplace. The data science virtual machine (frequently shortened to "DSVM") includes SQL Server, Microsoft Machine Learning Server, and all development tools.
71
71
72
72
The latest version of the Data Science Virtual Machine (DSVM) runs on Windows 2016 Preview Edition, to provide the clean customizable look of Windows 10. It comes pre-configured with NVIDIA drivers, CUDA Toolkit 8.0, and the NVIDIA cuDNN library for GPU workloads.
73
73
@@ -79,7 +79,7 @@ You can also install R Server through platform-specific installers available fro
79
79
80
80
### R tutorials
81
81
82
-
+[Use R in SQL Server](/tutorials/sql-server-r-tutorials.md)
82
+
+[SQL Server R tutorials](../advanced-analytics/tutorials/sql-server-r-tutorials.md)
83
83
84
84
Learn how to run R in SQL Server, create and use remote compute contexts, or perform simulations in R using SQL Server.
85
85
@@ -91,7 +91,7 @@ You can also install R Server through platform-specific installers available fro
91
91
92
92
### Python tutorials
93
93
94
-
+[Use Python in SQL Server](/tutorials/sql-server-r-tutorials.md)
94
+
+[SQL Server Python tutorials](../advanced-analytics/tutorials/sql-server-r-tutorials.md)
95
95
96
96
Learn how to run Python in SQL Server. Build a model using Python and use it to score SQL Server data.
Copy file name to clipboardExpand all lines: docs/advanced-analytics/operationalization-with-mrsdeploy.md
+5-5Lines changed: 5 additions & 5 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "Deploy and consume analytics using mrsdeploy | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: "07/26/2017"
4
+
ms.date: "08/20/2017"
5
5
ms.prod: "sql-server-2016"
6
6
ms.reviewer: ""
7
7
ms.suite: ""
@@ -36,13 +36,13 @@ The word *operationalization* can mean many things:
36
36
37
37
If you have installed Machine Learning Services with SQL Server, *operationalization* is a matter of wrapping your R or Python code in a stored procedure. Any application can then call the stored procedure to retrain a model, generate scores, or create reports. You can also automate jobs using existing scheduling mechanisms in SQL Server.
38
38
39
-
However, Microsoft R Server provides a different mechanism for deployment support, using web services that support publishing of R jobs, and an administrative utility for running distributed R jobs. Microsoft R Server uses the functions in the **mrsdeploy** package to establish a session with remote compute nodes and execute R code in a console application.
39
+
However, Microsoft R Server provides a different mechanism for deployment support, using web services that support publishing of R jobs, and an administrative utility for running distributed R jobs. Microsoft R Server uses the functions in the **mrsdeploy** package to establish a session with remote compute nodes and execute R code in a console application.
40
40
41
41
This deployment feature of R Server provides these benefits:
42
42
43
43
+ Role-based access control to analytical web services
44
44
45
-
Determine who can publish, update, and delete their own web services, those who can also update and delete the web services published by other users, and who can only list and consume web services. Learn more about [roles](https://msdn.microsoft.com/microsoft-r/operationalize/security-roles.md).
45
+
Determine who can publish, update, and delete their own web services, those who can also update and delete the web services published by other users, and who can only list and consume web services.
46
46
47
47
+ Faster scoring
48
48
@@ -68,7 +68,7 @@ This deployment feature of R Server provides these benefits:
68
68
69
69
SQL Server 2017 CTP 2.0 and later includes this feature, which was previously available only with R Server, and not installed with SQL Server R Services. The **mrsdeploy** package is installed on the SQL Server computer, if you select the option to install **Microsoft Machine Learning Server**, from the **Shared Features** section of SQL Server setup.
70
70
71
-
Typically, we do not recommend that you install Machine Learning Server on the same computer that is running SQL Server Machine Learning Services. We recommend that you install **Microsoft Machine Learning Server** on a separate computer from SQL Server, and then configure the operationalization features on that computer.
71
+
Typically, we do not recommend that you install Machine Learning Server on the same computer that is running SQL Server Machine Learning Services. We recommend that you install **Microsoft Machine Learning Server** on a separate computer from SQL Server, and then configure the operationalization features on that computer.
72
72
73
73
However, if you need to install them together, follow these additional steps to successfully configure the service.
74
74
@@ -83,7 +83,7 @@ However, if you need to install them together, follow these additional steps to
83
83
+ Create a new registry key `H_KEY_LOCAL_MACHINE\SOFTWARE\R Server\Path`
84
84
+ Set the value of the key to `"C:\Program Files\Microsoft SQL Server\140\R_SERVER"`.
85
85
86
-
4. When done, open the [Administrator Utility](https://docs.microsoft.com/r-server/operationalize/configure-use-admin-utility).
86
+
4. When done, open the [Administrator Utility](https://docs.microsoft.com/r-server/operationalize/configure-use-admin-utility).
87
87
88
88
5. Continue to configure the **mrsdeploy** service as described here: [Configuration for administrators](https://docs.microsoft.com/r-server/operationalize/configure-start-for-administrators)
Copy file name to clipboardExpand all lines: docs/advanced-analytics/python/what-is-revoscalepy.md
+5-5Lines changed: 5 additions & 5 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "Introducing revoscalepy | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: "07/19/2017"
4
+
ms.date: "08/20/2017"
5
5
ms.prod: "sql-server-2017"
6
6
ms.reviewer: ""
7
7
ms.suite: ""
@@ -19,12 +19,12 @@ manager: "jhubbard"
19
19
20
20
It is based on the **RevoScaleR** package for R, which was provided in Microsoft R Server and SQL Server R Services, and aims to provide the same functionality:
21
21
22
-
+ Supports multiple compute contexts, remote or local
22
+
+ Supports multiple compute contexts, both remote and local
23
23
+ Provides functions equivalent to those in RevoScaleR for data transformation and visualization
24
24
+ Provides Python versions of RevoScaleR machine learning algorithms for distributed or parallel processing
25
25
+ Improved performance, including use of the Intel math libraries
26
26
27
-
MicrosoftML packages are also proided for both R and Python. For more information, see [Using MicrosoftML in SQL Server](../using-the-microsoftml-package.md)
27
+
MicrosoftML packages are also provided for both R and Python. For more information, see [Using MicrosoftML in SQL Server](../using-the-microsoftml-package.md)
28
28
29
29
> [!WARNING]
30
30
>
@@ -62,7 +62,7 @@ You create the data source object by using functions listed in the following tab
62
62
63
63
+ Use [RxSqlServerData](https://docs.microsoft.com/r-server/python-reference/revoscalepy/rxsqlserverdata) to define a data source from a query or table
64
64
+ Use [RxInSqlServer](https://docs.microsoft.com/r-server/python-reference/revoscalepy/rxinsqlserver) to create a SQL Server compute context
65
-
+ Use [RxOdbcData](https://docs.microsoft.com/r-server/python-reference/revoscalepy/rxodbbcdata) to create a data source from an ODBC connection
65
+
+ Use [RxOdbcData](https://docs.microsoft.com/r-server/python-reference/revoscalepy/rxodbcdata) to create a data source from an ODBC connection
66
66
67
67
**revoscalepy** also supports the [XDF data source](https://docs.microsoft.com/r-server/python-reference/revoscalepy/rxxdfdata), used for moving data between memory and other data sources.
68
68
@@ -93,7 +93,7 @@ New machine learning algorithms are also provided by the Python version of [Micr
93
93
|`rx_fast_trees`| Create a boosted tree model |
94
94
|`rx_logistic_regression`| Create a logistic regression model|
95
95
|`rx_neural_network`| Create a customizable neural network model |
96
-
|`rx_oneclass_svm`| Creates a SVM model for imabalnced datsets, for use in anomaly detection|
96
+
|`rx_oneclass_svm`| Creates a SVM model on an imbalanced dataset, for use in anomaly detection|
97
97
98
98
> [!TIP]
99
99
> Many of these algorithms are already provided as modules in Azure Machine Learning.
Copy file name to clipboardExpand all lines: docs/advanced-analytics/r/how-to-do-realtime-scoring.md
+3-3Lines changed: 3 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "How to perform realtime scoring or native scoring in SQL Server | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: "07/14/2017"
4
+
ms.date: "08/20/2017"
5
5
ms.prod: "sql-server-2016"
6
6
ms.reviewer: ""
7
7
ms.suite: ""
@@ -13,7 +13,7 @@ author: "jeannt"
13
13
ms.author: "jeannt"
14
14
manager: "jhubbard"
15
15
---
16
-
##How to perform realtime scoring or native scoring in SQL Server
16
+
# How to perform realtime scoring or native scoring in SQL Server
17
17
18
18
This topic provides instructions and sample code for how to execute the realtime scoring and native scoring features in SQL Server 2016 and SQL Server 2017. The goal of both realtime scoring and native scoring is to improve the performance of scoring operations in small batches.
19
19
@@ -58,7 +58,7 @@ For more information, see [rxSerializeModel](https://docs.microsoft.com/r-server
58
58
59
59
From SQL code, you can train the model using `sp_execute_external_script`, and directly insert the trained models into a table, in a column of type **varbinary(max)**.
60
60
61
-
For a simple example, see [this tutorial](/tutorials/rtsql-create-a-predictive-model-r.md)
61
+
For a simple example, see [this tutorial](../tutorials/rtsql-create-a-predictive-model-r.md)
Copy file name to clipboardExpand all lines: docs/advanced-analytics/r/r-package-management-for-sql-server-r-services.md
+11-11Lines changed: 11 additions & 11 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "R package management for SQL Server | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: "07/31/2017"
4
+
ms.date: "08/20/2017"
5
5
ms.prod: "sql-server-2016"
6
6
ms.reviewer: ""
7
7
ms.suite: ""
@@ -19,7 +19,7 @@ manager: "jhubbard"
19
19
---
20
20
# R package management for SQL Server
21
21
22
-
This topic describes the package management features that you can use to manage R packages that are running on an instance of SQL Server.
22
+
This topic describes the package management features that you can use to manage R packages that are running on an instance of SQL Server.
23
23
24
24
**Applies to:** SQL Server 2016 R Services, SQL Server 2017 Machine Learning Services
25
25
@@ -35,13 +35,13 @@ The database administrator is responsible for setting up roles and adding users
35
35
36
36
The following new database roles support secure installation and R package management in SQL Server:
37
37
38
-
-**rpkgs-users** Allows users to use any shared packages that were installed by members of the **rpkgs-shared** role.
38
+
-`rpkgs-users`: Allows users to use any shared packages that were installed by members of the `rpkgs-shared` role.
39
39
40
-
-**rpkgs-private** Provides access to shared packages with the same permissions as the **rpkgs-users** role. Members of this role can also install, remove and use privately scoped packages.
40
+
-`rpkgs-private`: Provides access to shared packages with the same permissions as the `rpkgs-users` role. Members of this role can also install, remove and use privately scoped packages.
41
41
42
-
-**rpkgs-shared** Provides the same permissions as the **rpkgs-private** role. Users who are members of this role can also install or remove shared packages.
42
+
-`rpkgs-shared`: Provides the same permissions as the `rpkgs-private` role. Users who are members of this role can also install or remove shared packages.
43
43
44
-
-**db_owner** - Has the same permissions as the **rpkgs-shared** role. Can also grant users the right to install or remove both shared and private packages.
44
+
-`db_owner`: Has the same permissions as the `rpkgs-shared` role. Can also grant users the right to install or remove both shared and private packages.
45
45
46
46
### Creating an external package library using T-SQL
47
47
@@ -61,7 +61,7 @@ The **RevoScaleR** package now includes functions to support easier installation
61
61
62
62
### R package management functions
63
63
64
-
The following package management functions are provided in RevoScaleR, for installation and removal of packages in a specified compute context.
64
+
The following package management functions are provided in RevoScaleR, for installation and removal of packages in a specified compute context:
65
65
66
66
+[rxInstalledPackages](https://docs.microsoft.com/r-server/r-reference/revoscaler/rxinstalledpackages): Find information about packages installed in the specified compute context.
67
67
@@ -75,7 +75,7 @@ The following package management functions are provided in RevoScaleR, for insta
75
75
76
76
+[rxSqlLibPaths](https://docs.microsoft.com/r-server/r-reference/revoscaler/rxsqllibpaths): Get the search path for the library trees for packages while executing inside the SQL Server.
77
77
78
-
These packages are also included by default in SQL Server 2017. You can add the packages to an instance of SQL Server 2016 if you upgrade the instance to use at least Microsoft R 9.0.1. For more information, see [Using SqlBindR.exe to Upgrade R](/use-sqlbindr-exe-to-upgrade-an-instance-of-sql-server.md).
78
+
These packages are also included by default in SQL Server 2017. You can add the packages to an instance of SQL Server 2016 if you upgrade the instance to use at least Microsoft R 9.0.1. For more information, see [Using SqlBindR.exe to upgrade R](use-sqlbindr-exe-to-upgrade-an-instance-of-sql-server.md).
79
79
80
80
For information about these functions, see the RevoScaleR function reference pages: (https://docs.microsoft.com/r-server/r-reference/revoscaler/revoscaler)
81
81
@@ -97,17 +97,17 @@ The new package management functions provide two scopes for installation and use
97
97
98
98
-**Shared scope**
99
99
100
-
*Shared scope* means that users who have been given permission to the shared scope role (**rpkgs-shared**) can install and uninstall packages to a specified database. A package that is installed in a shared scope library can be used by other users of the database on SQL Server, provided those users are allowed to use installed R packages.
100
+
*Shared scope* means that users who have been given permission to the shared scope role (`rpkgs-shared`) can install and uninstall packages to a specified database. A package that is installed in a shared scope library can be used by other users of the database on SQL Server, provided those users are allowed to use installed R packages.
101
101
102
102
-**Private scope**
103
103
104
-
*Private scope* means that users who have been given membership in the private scope role (**rpkgs-private**) can install or uninstall packages into a private library location defined per user. Therefore, any packages installed in the private scope can be used only by the user who installed them. In other words, a user on SQL Server cannot use private packages that were installed by a different user.
104
+
*Private scope* means that users who have been given membership in the private scope role (`rpkgs-private`) can install or uninstall packages into a private library location defined per user. Therefore, any packages installed in the private scope can be used only by the user who installed them. In other words, a user on SQL Server cannot use private packages that were installed by a different user.
105
105
106
106
These models for *shared* and *private* scope can be combined to develop custom secure systems for deploying and managing packages on SQL Server.
107
107
108
108
For example, by using shared scope, the lead or manager for a group of data scientists could be granted permission to install packages, and those packages could then be used by all other users or data scientists in the same SQL Server instance.
109
109
110
-
Another scenario might require greater isolation among users, or use of different versions of packages. In that case, private scope can be used to give individual permissions to data scientists, who would be responsible for installing and using just the packages they need. Because packages are installed on a per-user basis, packages installed by one user would not affect the work of other users who are using the same SQL Server database.
110
+
Another scenario might require greater isolation among users, or use of different versions of packages. In that case, private scope can be used to give individual permissions to data scientists, who would be responsible for installing and using just the packages they need. Because packages are installed on a per-user basis, packages installed by one user would not affect the work of other users who are using the same SQL Server database.
0 commit comments