Skip to content

Commit 1d2f2df

Browse files
committed
Merge branch 'master' of https://github.com/MicrosoftDocs/sql-docs-pr into patch-23
2 parents 7a340b0 + a8f61af commit 1d2f2df

425 files changed

Lines changed: 2705 additions & 1651 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

.openpublishing.redirection.json

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -868,6 +868,11 @@
868868
{
869869
"source_path": "docs/advanced-analytics/machine-learning-troubleshooting-faq.md",
870870
"redirect_url": "/sql/machine-learning/machine-learning-troubleshooting-faq",
871+
"redirect_document_id": false
872+
},
873+
{
874+
"source_path": "docs/machine-learning/machine-learning-troubleshooting-faq.md",
875+
"redirect_url": "/sql/machine-learning/machine-learning-troubleshooting-overview",
871876
"redirect_document_id": true
872877
},
873878
{
@@ -1058,9 +1063,14 @@
10581063
{
10591064
"source_path": "docs/advanced-analytics/r/upgrade-and-installation-faq-sql-server-r-services.md",
10601065
"redirect_url": "/sql/machine-learning/r/upgrade-and-installation-faq-sql-server-r-services",
1061-
"redirect_document_id": true
1066+
"redirect_document_id": false
10621067
},
10631068
{
1069+
"source_path": "docs/machine-learning/r/upgrade-and-installation-faq-sql-server-r-services.md",
1070+
"redirect_url": "/sql/machine-learning/upgrade-and-installation-faq-sql-server-r-services",
1071+
"redirect_document_id": true
1072+
},
1073+
{
10641074
"source_path": "docs/advanced-analytics/r/using-data-from-olap-cubes-in-r.md",
10651075
"redirect_url": "/sql/machine-learning/r/using-data-from-olap-cubes-in-r",
10661076
"redirect_document_id": true

docs/azure-data-studio/download-azure-data-studio.md

Lines changed: 15 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@ author: yualan
88
ms.author: alayu
99
ms.reviewer: maghan
1010
ms.custom: seodec18
11-
ms.date: 6/15/2020
11+
ms.date: 7/17/2020
1212
---
1313

1414
# Download and install Azure Data Studio
@@ -22,9 +22,9 @@ Download and install the latest release:
2222
2323
|Platform|Download|Release date| Version |
2424
|:---|:---|:---|:---|
25-
| Windows | [User Installer (recommended)](https://go.microsoft.com/fwlink/?linkid=2132348)<br>[System Installer](https://go.microsoft.com/fwlink/?linkid=2132347)<br>[.zip](https://go.microsoft.com/fwlink/?linkid=2132518) | June 15, 2020 | 1.19.0 |
26-
| macOS | [.zip](https://go.microsoft.com/fwlink/?linkid=2132519) | June 15, 2020 | 1.19.0 |
27-
| Linux | [.deb](https://go.microsoft.com/fwlink/?linkid=2132350)<br>[.rpm](https://go.microsoft.com/fwlink/?linkid=2132351)<br>[.tar.gz](https://go.microsoft.com/fwlink/?linkid=2132349) | June 15, 2020| 1.19.0 |
25+
| Windows | [User Installer (recommended)](https://go.microsoft.com/fwlink/?linkid=2135512)<br>[System Installer](https://go.microsoft.com/fwlink/?linkid=2135513)<br>[.zip](https://go.microsoft.com/fwlink/?linkid=2135514) | July 17, 2020 | 1.20.1 |
26+
| macOS | [.zip](https://go.microsoft.com/fwlink/?linkid=2135266) | July 17, 2020 | 1.20.1 |
27+
| Linux | [.deb](https://go.microsoft.com/fwlink/?linkid=2135515)<br>[.rpm](https://go.microsoft.com/fwlink/?linkid=2135268)<br>[.tar.gz](https://go.microsoft.com/fwlink/?linkid=2135267) | July 17, 2020| 1.20.1 |
2828

2929
For details about the latest release, see the [release notes](release-notes.md).
3030

@@ -36,32 +36,32 @@ The *user installer* is recommended because it does not require administrator pr
3636

3737
**User Installer** (recommended)
3838

39-
1. Download and run the [[!INCLUDE[name-sos](../includes/name-sos-short.md)] *user* installer for Windows](https://go.microsoft.com/fwlink/?linkid=2132348).
39+
1. Download and run the [[!INCLUDE[name-sos](../includes/name-sos-short.md)] *user* installer for Windows](https://go.microsoft.com/fwlink/?linkid=2135512).
4040
2. Start the [!INCLUDE[name-sos-short](../includes/name-sos-short.md)] app.
4141

4242
**System Installer**
4343

44-
1. Download and run the [[!INCLUDE[name-sos](../includes/name-sos-short.md)] *system* installer for Windows](https://go.microsoft.com/fwlink/?linkid=2132347).
44+
1. Download and run the [[!INCLUDE[name-sos](../includes/name-sos-short.md)] *system* installer for Windows](https://go.microsoft.com/fwlink/?linkid=2135513).
4545
2. Start the [!INCLUDE[name-sos-short](../includes/name-sos-short.md)] app.
4646

4747
**.zip file**
4848

49-
1. Download [[!INCLUDE[name-sos](../includes/name-sos-short.md)] .zip for Windows](https://go.microsoft.com/fwlink/?linkid=2132518).
49+
1. Download [[!INCLUDE[name-sos](../includes/name-sos-short.md)] .zip for Windows](https://go.microsoft.com/fwlink/?linkid=2135514).
5050
2. Browse to the downloaded file and extract it.
5151
3. Run `\azuredatastudio-windows\azuredatastudio.exe`
5252

5353
## Get Azure Data Studio for macOS
5454

55-
1. Download [[!INCLUDE[name-sos](../includes/name-sos-short.md)] for macOS](https://go.microsoft.com/fwlink/?linkid=2132519).
55+
1. Download [[!INCLUDE[name-sos](../includes/name-sos-short.md)] for macOS](https://go.microsoft.com/fwlink/?linkid=2135266).
5656
2. To expand the contents of the zip, double-click it.
5757
3. To make Azure Data Studio available in the *Launchpad*, drag *Azure Data Studio.app* to the *Applications* folder.
5858

5959
## Get Azure Data Studio for Linux
6060

6161
1. Download [!INCLUDE[name-sos](../includes/name-sos-short.md)] for Linux by using one of the installers or the tar.gz archive:
62-
- [.deb](https://go.microsoft.com/fwlink/?linkid=2132350)
63-
- [.rpm](https://go.microsoft.com/fwlink/?linkid=2132351)
64-
- [.tar.gz](https://go.microsoft.com/fwlink/?linkid=2132349)
62+
- [.deb](https://go.microsoft.com/fwlink/?linkid=2135515)
63+
- [.rpm](https://go.microsoft.com/fwlink/?linkid=2135268)
64+
- [.tar.gz](https://go.microsoft.com/fwlink/?linkid=2135267)
6565
1. To extract the file and launch [!INCLUDE[name-sos](../includes/name-sos-short.md)], open a new Terminal window and type the following commands:
6666

6767
**Debian Installation:**
@@ -160,11 +160,10 @@ Azure Data Studio runs on Windows, macOS, and Linux, and is supported on the fol
160160

161161
## Recommended System Requirements
162162

163-
| | CPU Cores | Memory/RAM |
164-
|:-----------|:---------|:----------|
165-
| Recommended | 4 | 8 GB |
166-
| Minimum | 2 | 4 GB |
167-
| | | |
163+
| Recommended/Minimum | CPU Cores | Memory/RAM |
164+
|---------------------|-----------|------------|
165+
| Recommended | 4 | 8 GB |
166+
| Minimum | 2 | 4 GB |
168167

169168
## Check for updates
170169

docs/azure-data-studio/extensibility.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -43,9 +43,9 @@ This section covers the various contribution points that are defined in the pack
4343

4444
The IntelliSense is supported inside azuredatastudio.
4545

46-
## Contributes dashboard
46+
### Dashboard contribution points
4747

48-
Contribute tab, container, insight widget to the dashboard.
48+
Contribute a tab, container, and/or insight widget to the dashboard.
4949

5050
![Dashboard](media/extensibility/dashboard-page.png)
5151

@@ -271,4 +271,4 @@ In dashboard, we provide the following context variables:
271271
|`serverName`|A string of the server name of the current connection. Ex. `serverName == 'localhost'`.|
272272
|`databaseName` | A string of the database name of the current connection. Ex. `databaseName == 'master'`.|
273273
|`connection` | The full connection profile object for the current connection (IConnectionProfile)|
274-
|`dashboardContext` | A string of the context of the page of the dashboard is currently on. Either 'database' or 'server'. Ex. `dashboardContext == 'database'`|
274+
|`dashboardContext` | A string of the context of the page the dashboard is currently on. Either 'database' or 'server'. Ex. `dashboardContext == 'database'`|

docs/azure-data-studio/extension-authoring.md

Lines changed: 23 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
22
title: Create extensions
3-
description: Learn about creating and adding extensions to Azure Data Studio
3+
description: Learn about creating and publishing extensions to Azure Data Studio
44
ms.prod: azure-data-studio
55
ms.technology:
66
ms.topic: conceptual
@@ -26,14 +26,16 @@ If you're interested in extending Azure Data Studio, you can create your own ext
2626

2727
***Prerequisites***
2828

29-
To develop an extension you need Node.js installed and available in your $PATH. Node.js includes npm, the Node.js Package Manager, which will be used to install the extension generator.
29+
To develop an extension, you need [Node.js](https://nodejs.org/) installed and available in your `$PATH`. Node.js includes npm, the Node.js Package Manager, which will be used to install the extension generator.
3030

31-
To start your new extension, you can use the Azure Data Studio Extension generator. The Yeoman [extension generator](https://www.npmjs.com/package/generator-azuredatastudio) makes it very easy to create simple extension projects. To Launch the generator, type the following in a command prompt:
31+
To create your new extension, you can use the Azure Data Studio Extension Generator. The Yeoman [Extension Generator](https://www.npmjs.com/package/generator-azuredatastudio) is a beneficial starting point for extension projects. To launch the generator, type the following in a command prompt:
3232

33-
`npm install -g yo generator-azuredatastudio`
34-
35-
`yo azuredatastudio`
33+
```
34+
npm install -g yo generator-azuredatastudio # Install the generator
35+
yo azuredatastudio
36+
```
3637

38+
For an in-depth guide on how to get started with your extension template, see [Creating an Extension](https://docs.microsoft.com/sql/azure-data-studio/tutorial-create-extension?view=sql-server-ver15), which walks you through the creation of a keymap extension.
3739

3840
**Extensibility References**
3941

@@ -45,19 +47,24 @@ To learn about Azure Data Studio Extensibility see [Extensibility overview](exte
4547
You can debug your new extension using Visual Studio Code extension [Azure Data Studio Debug](https://github.com/kevcunnane/sqlops-debug).
4648

4749
Steps
48-
- Open your extension with [Visual Studio Code](https://code.visualstudio.com/)
49-
- Install Azure Data Studio Debug extension
50-
- Press **F5** or click the Debug icon and click **Start**.
51-
- A new instance of Azure Data Studio starts in a special mode (Extension Development Host) and this new instance is now aware of your extension.
50+
1. Open your extension with [Visual Studio Code](https://code.visualstudio.com/).
51+
1. Install the Azure Data Studio Debug extension.
52+
1. Press **F5** or click the Debug icon and click **Start**.
53+
1. A new instance of Azure Data Studio starts in a special mode (Extension Development Host) and this new instance is now aware of your extension.
5254

5355

5456
## Create an extension package
5557

56-
After writing your extension, you need to create a VSIX package to be able to install it in Azure Data Studio. You can use [vsce](https://github.com/Microsoft/vscode-vsce) to create the VSIX package.
58+
After writing your extension, you need to create a VSIX package to be able to install it in Azure Data Studio. You can use [vsce](https://github.com/Microsoft/vscode-vsce) (Visual Studio Code Extensions) to create the VSIX package.
5759

58-
`npm install -g vsce`
60+
```
61+
npm install -g vsce
62+
cd myExtensionName
63+
vsce package
64+
# The myExtensionName.vsix file has now been generated
65+
```
5966

60-
`vsce package`
67+
With a VSIX package, you can share your extension locally and privately by sharing the `.vsix` file and using the command **Extensions: Install From VSIX File** from the Command Palette to install the extension into Azure Data Studio.
6168

6269

6370
## Publish an extension
@@ -71,5 +78,6 @@ To publish your new extension to Azure Data Studio:
7178

7279
Your extension will be reviewed and added to the extension gallery.
7380

74-
**Publishing Extension Updates**
75-
The process to publish updates is similar to publishing the extension. Please make sure the version is updated in package.json
81+
**Publishing extension updates**
82+
83+
The process to publish updates is similar to publishing the extension. Please make sure the version is updated in package.json.

docs/azure-data-studio/extensions.md

Lines changed: 77 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,13 +19,14 @@ Extensions are provided by the Azure Data Studio team (Microsoft), as well as th
1919

2020
## Add Azure Data Studio extensions
2121

22-
1. Access the available extensions by selecting the Extensions Icon, or by selecting **Extensions** in the **View** menu.
22+
1. Access the available extensions by selecting the Extensions Icon, or by selecting **Extensions** in the **View** menu. You can use the **View: Show Extensions** command, available in the **Command Palette** (F1 or `Ctrl+Shift+P`).
2323

2424
![extension manager icon](media/extensions/extension-manager-icon.png)
2525

2626
You can also quickly access the extensions manager by pressing `Ctrl+Shift+X` (Windows/Linux) or `Command+Shift+X` (Mac).
2727

2828
2. Select an available extension to view its details.
29+
2930
![extension details](media/extensions/extension-details.png)
3031

3132
3. Select the extension you want and **Install** it.
@@ -35,6 +36,80 @@ Extensions are provided by the Azure Data Studio team (Microsoft), as well as th
3536
If you're having problems accessing the Extensions Manager on Azure Data Studio, you can download the extension you need on our [GitHub Wiki](https://github.com/microsoft/azuredatastudio/wiki/List-of-Extensions).
3637

3738

38-
## Access Installed Azure Data Studio Extensions
39+
## Manage extensions
40+
41+
### List installed extensions
42+
43+
The default Extensions view shows the extensions that are currently enabled, all extensions that are recommended for you, and a collapsed container of all currently disabled extensions. The **Extensions: Show Installed Extensions** command, available in the **Command Palette** or the **More Actions** `(...)` drop-down menu, shows a list of all installed extensions, including disabled extensions.
44+
45+
### Uninstall an extension
46+
47+
To uninstall an extension, click the gear icon on the right of an extension entry and choose **Uninstall** from the drop-down menu. This uninstalls the selected extension and will prompt you to reload Azure Data Studio.
48+
49+
![extension dropdown](media/extensions/extension-gear-dropdown.png)
50+
51+
### Disable an extension
52+
53+
You may temporarily disable an extension instead of permanently removing an extension. You can either disable an extension across all Azure Data Studio sessions (**Disable**) or just for your current Workspace (**Disable (Workspace)**). You can also disable all of your currently installed extensions through the **Command Palette** with the commands **Extensions: Disable All Extensions** and **Extensions: Disable All Extensions (Workspace)**.
54+
55+
### Enable an extension
56+
57+
If an extension has been disabled, it will be in the **Disabled** section of the extension list and marked as ***Disabled***. You can re-enable it with the **Enable** or **Enable (Workspace)** commands in the drop-down menu. The **Command Palette** also lets you enable all extensions with the commands **Extensions: Enable All Extensions** and **Extensions: Enable All Extensions (Workspace)**.
58+
59+
![extension enabling](media/extensions/extensions-enable.png)
60+
61+
### Updating an extension
62+
63+
Azure Data Studio automatically checks for and installs updates for any of your installed extensions. If you would like to turn off the auto-update feature, you can disable auto-update with the **Extensions: Disable Auto Updating Extensions** command.
64+
65+
To manually update an extension, you can check for extension updates with the **Extensions: Show Outdated Extensions** command which searches through your extension list using the `@outdated` filter. This will show any available updates for all currently installed extensions. Click the **Update** button on an outdated extension and the update will be installed. You will then be prompted to reload Azure Data Studio. You can also update all of your outdated extensions simultaneously with the **Extensions: Update All Extensions** command.
66+
67+
The **Extensions: Check for Extensions Updates** command is another way to check which of your extensions have updates available.
68+
69+
## Install from a VSIX
70+
71+
You can manually install an Azure Data Studio extension packaged in a `.vsix` file using the **Install from VSIX** command in the Extensions view command drop-down, or the **Extensions: Install from VSIX command** in the Command Palette and point to the extension's `.vsix` file.
72+
73+
## Access installed Azure Data Studio extensions
3974

4075
Each extension enhances your experience in Azure Data Studio in a different way. As a result, the entry point for extensions can vary. Refer to your installed extension's individual documentation for information on how its features can be accessed once it's installed.
76+
77+
## Extensions view filters
78+
79+
The Extensions view search box supports filters to help you find and manage extensions. The commands **Show Installed Extensions** and **Show Recommended Extensions** use filters such as `@installed` and `@recommended` in the search box.
80+
81+
You can see a complete listing of all filters and sort commands by typing @ in the extensions search box and navigating through the suggestions:
82+
83+
![extension sort](media/extensions/extension-sort.png)
84+
85+
Here are the Extensions view filters:
86+
87+
- `@builtin` - Show extensions that come with Azure Data Studio. Grouped by type (Programming Languages, Themes, etc.).
88+
- `@disabled` - Show disabled installed extensions.
89+
- `@enabled` - Show enabled installed extensions. Extensions can be individually enabled/disabled.
90+
- `@installed` - Show installed extensions.
91+
- `@outdated` - Show outdated installed extensions. A newer version is available on the Marketplace.
92+
- `@recommended` - Show recommended extensions. Grouped as Workspace specific or general use.
93+
- `@category` - Show extensions belonging to specified category. Below are a few of supported categories. For a complete list, type @category and follow the options in the suggestion list:
94+
- `@category:themes`
95+
- `@category:formatters`
96+
- `@category:snippets`
97+
These filters can be combined as well. For example, `@installed @category:themes` displays all installed themes.
98+
99+
If no filter is provided, the Extensions view displays currently installed and recommended extensions.
100+
101+
### Sorting
102+
You can sort extensions with the `@sort` filter, which can take the following values:
103+
104+
- `installs` - Sort by extension gallery installation count, in descending order.
105+
- `rating` - Sort by extension gallery rating (1-5 stars), in descending order.
106+
- `name` - Sort alphabetically by extension name.
107+
108+
## Common questions
109+
110+
### Where are extensions installed?
111+
Extensions are installed in a per user extensions folder. Depending on your platform, the location is in the following folder:
112+
113+
- Windows `%USERPROFILE%\.azuredatastudio\extensions`
114+
- macOS `~/.azuredatastudio/extensions`
115+
- Linux `~/.azuredatastudio/extensions`
25 KB
Loading
13.9 KB
Loading
25.6 KB
Loading

docs/azure-data-studio/release-notes-azure-data-studio.md

Lines changed: 33 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,13 +8,45 @@ author: yualan
88
ms.author: alayu
99
ms.reviewer: maghan
1010
ms.custom: seodec18
11-
ms.date: 06/15/2020
11+
ms.date: 07/17/2020
1212
---
1313

1414
# Release notes for Azure Data Studio
1515

1616
**[Download and install the latest release!](download.md)**
1717

18+
## July 2020 (hotfix)
19+
20+
July 17, 2020 &nbsp; / &nbsp; version: 1.20.1
21+
22+
&nbsp;
23+
24+
| Change | Details |
25+
| :----- | :------ |
26+
| Fix bug #11372 Object Explorer drag-and-drop table incorrectly wraps table names | [#11372](https://github.com/microsoft/azuredatastudio/issues/11372) |
27+
| Fix bug #11356 Dark theme is now the default theme | [#11356](https://github.com/microsoft/azuredatastudio/issues/11356) |
28+
| &nbsp; | &nbsp; |
29+
30+
### Known Issue
31+
32+
- Some users have reported connection errors from the new Microsoft.Data.SqlClient v2.0.0 included in this release. Users have found [following these instructions](https://github.com/microsoft/azuredatastudio/issues/11367#issuecomment-659614111) to successfully connect
33+
34+
## July 2020
35+
36+
July 15, 2020 &nbsp; / &nbsp; version: 1.20.0
37+
38+
&nbsp;
39+
40+
| Change | Details |
41+
| :----- | :------ |
42+
| Added new Feature Tour | From welcome page and command palette, users can now launch a feature tour to get a walkthrough of commonly used features including Connections Viewlet, Notebooks viewlet, and Extensions Marketplace |
43+
| New notebook features | &bull; &nbsp; Header support in Markdown Toolbar<br/> &bull; &nbsp; Side-by-side Markdown Preview in Text Cells
44+
| Drag and Drop Columns and Tables in Query Editor | Users can now directly drag and drop columns and tables from connections viewlet to query editor |
45+
| Azure Account icon added to Activity Bar) | More discoverable to sign in to Azure |
46+
| Resolved bugs and issues | For a complete list of fixes see [Bugs and issues, on GitHub](https://github.com/microsoft/azuredatastudio/issues?q=is%3Aissue+milestone%3A%22July+2020+Release%22+is%3Aclosed). |
47+
| &nbsp; | &nbsp; |
48+
49+
1850
## June 2020
1951

2052
June 15, 2020 &nbsp; / &nbsp; version: 1.19.0

docs/big-data-cluster/spark-create-machine-learning-model.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@ ms.metadata: seo-lt-2019
99
ms.date: 12/13/2019
1010
ms.topic: conceptual
1111
ms.prod: sql
12-
ms.technology: big-data-cluster
12+
ms.technology: machine-learning-bdc
1313
---
1414

1515
# Create, export, and score Spark machine learning models on [!INCLUDE[big-data-clusters-2019](../includes/ssbigdataclusters-ss-nover.md)]

0 commit comments

Comments
 (0)