Skip to content

Commit 7f3f5ec

Browse files
rothjarothja
committed
Freshness updates
1 parent 4393acc commit 7f3f5ec

10 files changed

Lines changed: 160 additions & 182 deletions

‎docs/includes/sql-linux-quickstart-connect-query.md‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -109,8 +109,9 @@ In addition to **sqlcmd**, you can use the following cross-platform tools to man
109109
|||
110110
|---|---|
111111
| [Azure Data Studio](../azure-data-studio/index.md) | A cross-platform GUI database management utility. |
112-
| [mssql-cli](https://github.com/dbcli/mssql-cli/tree/master/doc) | A cross-platform command-line interface for running Transact-SQL commands. |
113112
| [Visual Studio Code](../linux/sql-server-linux-develop-use-vscode.md) | A cross-platform GUI code editor that run Transact-SQL statements with the mssql extension. |
113+
| [PowerShell Core](../linux/sql-server-linux-manage-powershell-core.md) |
114+
| [mssql-cli](https://github.com/dbcli/mssql-cli/tree/master/doc) | A cross-platform command-line interface for running Transact-SQL commands. |
114115

115116
## Connecting from Windows
116117

‎docs/linux/media/sql-server-linux-develop-use-vscode/vscode-connection-status.png‎

-1.88 KB
Loading

‎docs/linux/media/sql-server-linux-develop-use-vscode/vscode-extension.png‎

-377 Bytes
Loading

‎docs/linux/media/sql-server-linux-develop-use-vscode/vscode-install-success-notification.png‎

-15.3 KB
Binary file not shown.

‎docs/linux/media/sql-server-linux-develop-use-vscode/vscode-language-mode.png‎

-1.17 KB
Loading

‎docs/linux/quickstart-install-connect-docker.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@ ms.date: 05/14/2019
99
ms.topic: conceptual
1010
ms.prod: sql
1111
ms.technology: linux
12-
ms.custom: "sql-linux, seodec18"
12+
ms.custom: "sqlfreshmay19"
1313
ms.prod_service: linux
1414
ms.assetid: 82737f18-f5d6-4dce-a255-688889fdde69
1515
moniker: ">= sql-server-linux-2017 || >= sql-server-2017 || =sqlallproducts-allversions"

‎docs/linux/quickstart-install-connect-ubuntu.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -5,10 +5,10 @@ description: This quickstart shows how to install SQL Server 2017 or SQL Server
55
author: rothja
66
ms.author: jroth
77
manager: craigg
8-
ms.date: 07/16/2018
8+
ms.date: 05/28/2019
99
ms.topic: conceptual
1010
ms.prod: sql
11-
ms.custom: "sql-linux, seodec18"
11+
ms.custom: "sqlfreshmay19"
1212
ms.technology: linux
1313
ms.assetid: 31c8c92e-12fe-4728-9b95-4bc028250d85
1414
---
@@ -30,13 +30,13 @@ In this quickstart, you install SQL Server 2019 preview on Ubuntu 16.04. You the
3030
::: moniker-end
3131

3232
> [!TIP]
33-
> This tutorial requires user input and an internet connection. If you are interested in the [unattended](sql-server-linux-setup.md#unattended) or [offline](sql-server-linux-setup.md#offline) installation procedures, see [Installation guidance for SQL Server on Linux](sql-server-linux-setup.md).
33+
> This tutorial requires user input and an internet connection. If you are interested in the unattended or offline installation procedures, see [Installation guidance for SQL Server on Linux](sql-server-linux-setup.md).
3434
3535
## Prerequisites
3636

3737
You must have a Ubuntu 16.04 machine with **at least 2 GB** of memory.
3838

39-
To install Ubuntu on your own machine, go to [https://www.ubuntu.com/download/server](https://www.ubuntu.com/download/server). You can also create Ubuntu virtual machines in Azure. See [Create and Manage Linux VMs with the Azure CLI](https://docs.microsoft.com/azure/virtual-machines/linux/tutorial-manage-vm).
39+
To install Ubuntu 16.04 on your own machine, go to [http://releases.ubuntu.com/xenial/](http://releases.ubuntu.com/xenial/). You can also create Ubuntu virtual machines in Azure. See [Create and Manage Linux VMs with the Azure CLI](https://docs.microsoft.com/azure/virtual-machines/linux/tutorial-manage-vm).
4040

4141
> [!NOTE]
4242
> At this time, the [Windows Subsystem for Linux](https://msdn.microsoft.com/commandline/wsl/about) for Windows 10 is not supported as an installation target.
@@ -91,7 +91,7 @@ To configure SQL Server on Ubuntu, run the following commands in a terminal to i
9191
5. Once the configuration is done, verify that the service is running:
9292

9393
```bash
94-
systemctl status mssql-server
94+
systemctl status mssql-server --no-pager
9595
```
9696

9797
6. If you plan to connect remotely, you might also need to open the SQL Server TCP port (default 1433) on your firewall.
@@ -137,7 +137,7 @@ To configure SQL Server on Ubuntu, run the following commands in a terminal to i
137137
5. Once the configuration is done, verify that the service is running:
138138

139139
```bash
140-
systemctl status mssql-server
140+
systemctl status mssql-server --no-pager
141141
```
142142

143143
6. If you plan to connect remotely, you might also need to open the SQL Server TCP port (default 1433) on your firewall.

‎docs/linux/sql-server-linux-develop-use-vscode.md‎

Lines changed: 119 additions & 138 deletions
Large diffs are not rendered by default.

‎docs/linux/sql-server-linux-setup-tools.md‎

Lines changed: 23 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -1,13 +1,14 @@
11
---
2-
title: Install SQL Server command-line tools on Linux | Microsoft Docs
2+
title: Install SQL Server command-line tools on Linux
3+
titleSuffix: SQL Server
34
description: This article describes how to install the SQL Server Tools on Linux.
45
author: rothja
56
ms.author: jroth
67
manager: craigg
7-
ms.date: 10/02/2017
8+
ms.date: 05/28/2019
89
ms.topic: conceptual
910
ms.prod: sql
10-
ms.custom: "sql-linux"
11+
ms.custom: "sqlfreshmay19"
1112
ms.technology: linux
1213
ms.assetid: eff8e226-185f-46d4-a3e3-e18b7a439e63
1314
---
@@ -197,43 +198,39 @@ The SQL Server command-line tools are included in the Docker image. If you attac
197198
198199
[!INCLUDE[SQL Server Linux offline package installation](../includes/sql-server-linux-offline-package-install-intro.md)]
199200
200-
The following table provides the location for the latest tools packages:
201+
1. First, locate and copy the **mssql-tools** package for your Linux distribution:
201202
202-
| Tools package | Version | Download |
203-
|-----|-----|-----|
204-
| Red Hat RPM tools package | 14.0.5.0-1 | [mssql-tools RPM package](https://packages.microsoft.com/rhel/7.3/prod/mssql-tools-14.0.5.0-1.x86_64.rpm) |
205-
| SLES RPM tools package | 14.0.5.0-1 | [mssql-tools RPM package](https://packages.microsoft.com/sles/12/prod/mssql-tools-14.0.5.0-1.x86_64.rpm) |
206-
| Ubuntu 16.04 Debian tools package | 14.0.5.0-1 | [mssql-tools Debian package](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/mssql-tools/mssql-tools_14.0.5.0-1_amd64.deb) |
207-
| Ubuntu 16.10 Debian tools package | 14.0.5.0-1 | [mssql-tools Debian package](https://packages.microsoft.com/ubuntu/16.10/prod/pool/main/m/mssql-tools/mssql-tools_14.0.5.0-1_amd64.deb) |
203+
| Linux distribution | **mssql-tools** package location |
204+
|---|---|
205+
| Red Hat | [https://packages.microsoft.com/rhel/7.3/prod](https://packages.microsoft.com/rhel/7.3/prod) |
206+
| SLES | [https://packages.microsoft.com/sles/12/prod](https://packages.microsoft.com/sles/12/prod)|
207+
| Ubuntu 16.04 | [https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/mssql-tools](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/mssql-tools) |
208208
209-
These packages depend on **msodbcsql**, which must be installed first. The **msodbcsql** pacakage also has a dependency on either **unixODBC-devel** (RPM) or **unixodbc-dev** (Debian). The location of the **msodbcsql** packages are listed in the following table:
209+
1. Also locate and copy the **msodbcsql** package, which is a dependency. The **msodbcsql** package also has a dependency on either **unixODBC-devel** (Red Hat and SLES) or **unixodbc-dev** (Ubuntu). The location of the **msodbcsql** packages are listed in the following table:
210210
211-
| msodbcsql package | Version | Download |
212-
|-----|-----|-----|
213-
| Red Hat RPM msodbcsql package | 13.1.6.0-1 | [msodbcsql RPM package](https://packages.microsoft.com/rhel/7.3/prod/msodbcsql-13.1.6.0-1.x86_64.rpm) |
214-
| SLES RPM msodbcsql package | 13.1.6.0-1 | [msodbcsql RPM package](https://packages.microsoft.com/sles/12/prod/msodbcsql-13.1.6.0-1.x86_64.rpm) |
215-
| Ubuntu 16.04 Debian msodbcsql package | 13.1.6.0-1 | [msodbcsql Debian package](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/msodbcsql_13.1.6.0-1_amd64.deb) |
216-
| Ubuntu 16.10 Debian msodbcsql package | 13.1.6.0-1 | [msodbcsql Debian package](https://packages.microsoft.com/ubuntu/16.10/prod/pool/main/m/msodbcsql/msodbcsql_13.1.6.0-1_amd64.deb) |
217-
218-
To manually install these packages, use the following steps:
211+
| Linux distribution | ODBC packages location |
212+
|---|---|
213+
| Red Hat | [https://packages.microsoft.com/rhel/7.3/prod](https://packages.microsoft.com/rhel/7.3/prod) |
214+
| SLES | [https://packages.microsoft.com/sles/12/prod](https://packages.microsoft.com/sles/12/prod)|
215+
| Ubuntu 16.04 | [**msodbcsql**](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql)<br/>[**unixodbc-dev**](https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/u/unixodbc/) |
219216
220217
1. **Move the downloaded packages to your Linux machine**. If you used a different machine to download the packages, one way to move the packages to your Linux machine is with the **scp** commmand.
221218
222219
1. **Install the and packages**: Install the **mssql-tools** and **msodbc** packages. If you get any dependency errors, ignore them until the next step.
223220
224221
| Platform | Package install commands |
225222
|-----|-----|
226-
| Red Hat | `sudo yum localinstall msodbcsql-13.1.6.0-1.x86_64.rpm`<br/>`sudo yum localinstall mssql-tools-14.0.5.0-1.x86_64.rpm` |
227-
| SLES | `sudo zypper install msodbcsql-13.1.6.0-1.x86_64.rpm`<br/>`sudo zypper install mssql-tools-14.0.5.0-1.x86_64.rpm` |
228-
| Ubuntu | `sudo dpkg -i msodbcsql_13.1.6.0-1_amd64.deb`<br/>`sudo dpkg -i mssql-tools_14.0.5.0-1_amd64.deb` |
223+
| Red Hat | `sudo yum localinstall msodbcsql-<version>.rpm`<br/>`sudo yum localinstall mssql-tools-<version>.rpm` |
224+
| SLES | `sudo zypper install msodbcsql-<version>.rpm`<br/>`sudo zypper install mssql-tools-<version>.rpm` |
225+
| Ubuntu | `sudo dpkg -i msodbcsql_<version>.deb`<br/>`sudo dpkg -i mssql-tools_<version>.deb` |
229226
230227
1. **Resolve missing dependencies**: You might have missing dependencies at this point. If not, you can skip this step. In some cases, you must manually locate and install these dependencies.
231228
232229
For RPM packages, you can inspect the required dependencies with the following commands:
233230
234231
```bash
235-
rpm -qpR msodbcsql-13.1.6.0-1.x86_64.rpm
236-
rpm -qpR mssql-tools-14.0.5.0-1.x86_64.rpm
232+
rpm -qpR msodbcsql-<version>.rpm
233+
rpm -qpR mssql-tools-<version>.rpm
237234
```
238235
239236
For Debian packages, if you have access to approved repositories containing those dependencies, the easiest solution is to use the **apt-get** command:
@@ -248,8 +245,8 @@ To manually install these packages, use the following steps:
248245
If this does not work for your Debian package, you can inspect the required dependencies with the following commands:
249246
250247
```bash
251-
dpkg -I msodbcsql_13.1.6.0-1_amd64.deb | grep "Depends:"
252-
dpkg -I mssql-tools_14.0.5.0-1_amd64.deb | grep "Depends:"
248+
dpkg -I msodbcsql_<version>_amd64.deb | grep "Depends:"
249+
dpkg -I mssql-tools_<version>_amd64.deb | grep "Depends:"
253250
```
254251
255252
## Next steps

‎docs/linux/sql-server-linux-setup.md‎

Lines changed: 9 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,13 +1,14 @@
11
---
2-
title: Installation guidance for SQL Server on Linux | Microsoft Docs
2+
title: Installation guidance for SQL Server on Linux
3+
titleSuffix: SQL Server
34
description: Install, update, and uninstall SQL Server on Linux. This article covers online, offline, and unattended scenarios.
45
author: rothja
56
ms.author: jroth
67
manager: craigg
7-
ms.date: 04/07/2018
8+
ms.date: 05/28/2019
89
ms.topic: conceptual
910
ms.prod: sql
10-
ms.custom: "sql-linux"
11+
ms.custom: "sqlfreshmay19"
1112
ms.technology: linux
1213
ms.assetid: 565156c3-7256-4e63-aaf0-884522ef2a52
1314
---
@@ -34,8 +35,8 @@ SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Ente
3435
|-----|-----|-----
3536
| **Red Hat Enterprise Linux** | 7.3, 7.4, 7.5, 7.6 | [Get RHEL 7.6](https://access.redhat.com/products/red-hat-enterprise-linux/evaluation)
3637
| **SUSE Linux Enterprise Server** | v12 SP2 | [Get SLES v12 SP2](https://www.suse.com/products/server)
37-
| **Ubuntu** | 16.04 | [Get Ubuntu 16.04](https://www.ubuntu.com/download/server)
38-
| **Docker Engine** | 1.8+ | [Get Docker](https://www.docker.com/products/overview)
38+
| **Ubuntu** | 16.04 | [Get Ubuntu 16.04](http://releases.ubuntu.com/xenial/)
39+
| **Docker Engine** | 1.8+ | [Get Docker](https://www.docker.com/get-started)
3940

4041
Microsoft also supports deploying and managing SQL Server containers by using OpenShift and Kubernetes.
4142

@@ -65,9 +66,6 @@ If you use **Network File System (NFS)** remote shares in production, note the f
6566

6667
When you install or upgrade SQL Server, you get the latest version of SQL Server from your configured Microsoft repository. The quickstarts use the SQL Server 2017 Cumulative Update **CU** repository. But you can instead configure the **GDR** repository or the **Preview (vNext)** repository. For more information on repositories and how to configure them, see [Configure repositories for SQL Server on Linux](sql-server-linux-change-repo.md).
6768

68-
> [!IMPORTANT]
69-
> If you previously installed a CTP or RC version of SQL Server 2017, you must remove the preview repository and register a General Availability (GA) one. For more information, see [Configure repositories for SQL Server on Linux](sql-server-linux-change-repo.md).
70-
7169
## <a id="platforms"></a> Install SQL Server 2017
7270

7371
You can install SQL Server 2017 on Linux from the command line. For step-by-step instructions, see one of the following quickstarts:
@@ -78,12 +76,12 @@ You can install SQL Server 2017 on Linux from the command line. For step-by-step
7876
- [Run on Docker](quickstart-install-connect-docker.md)
7977
- [Provision a SQL VM in Azure](/azure/virtual-machines/linux/sql/provision-sql-server-linux-virtual-machine?toc=/sql/toc/toc.json)
8078

79+
After installing, consider making additional configuration changes for optimal performance. For more information, see [Performance best practices and configuration guidelines for SQL Server on Linux](sql-server-linux-performance-best-practices.md).
80+
8181
## <a id="sqlvnext"></a> Install SQL Server 2019 preview
8282

8383
You can install SQL Server 2019 preview on Linux using the same quickstart links in the previous section. However, you must register the **Preview (vNext)** repository instead of the **CU** repository. The quickstarts provide instructions on how to do this.
8484

85-
After installing, consider making additional configuration changes for optimal performance. For more information, see [Performance best practices and configuration guidelines for SQL Server on Linux](sql-server-linux-performance-best-practices.md).
86-
8785
## <a id="upgrade"></a> Update SQL Server
8886

8987
To update the **mssql-server** package to the latest release, use one of the following commands based on your platform:
@@ -214,6 +212,7 @@ After installation, you can also install or enable optional SQL Server features.
214212
- [SQL Server command-line tools](sql-server-linux-setup-tools.md)
215213
- [SQL Server Agent](sql-server-linux-setup-sql-agent.md)
216214
- [SQL Server Full Text Search](sql-server-linux-setup-full-text-search.md)
215+
- [Machine Learning Services (R, Python)](sql-server-linux-setup-machine-learning.md)
217216
- [SQL Server Integration Services](sql-server-linux-setup-ssis.md)
218217

219218
[!INCLUDE[Get Help Options](../includes/paragraph-content/get-help-options.md)]

0 commit comments

Comments
 (0)