Skip to content

Commit 7947bf4

Browse files
VanMSFTVanMSFT
committed
Merge branch 'main' of https://github.com/MicrosoftDocs/sql-docs-pr into q1Freshness_5
2 parents 5e8e898 + 0f6df55 commit 7947bf4

249 files changed

Lines changed: 3933 additions & 3538 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: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -50,6 +50,11 @@
5050
"redirect_url": "/previous-versions/sql/2014/2014-toc/sql-server-transaction-log-architecture-and-management",
5151
"redirect_document_id": false
5252
},
53+
{
54+
"source_path": "docs/database-engine/availability-groups/windows/always-on-availability-groups-sql-server.md",
55+
"redirect_url": "/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server",
56+
"redirect_document_id": true
57+
},
5358
{
5459
"source_path": "docs/2014/analysis-services/4-6-specifying-attribute-relationships-in-user-defined-hierarchy.md",
5560
"redirect_url": "/previous-versions/sql/2014/analysis-services/4-6-specifying-attribute-relationships-in-user-defined-hierarchy",
@@ -41325,14 +41330,9 @@
4132541330
"redirect_url": "/sql/sql-server/azure-arc/automatically-connect",
4132641331
"redirect_document_id": false
4132741332
},
41328-
{
41329-
"source_path": "docs/sql-server/azure-arc/prerequisites.md",
41330-
"redirect_url": "/azure/azure-arc/servers/prerequisites",
41331-
"redirect_document_id": false
41332-
},
4133341333
{
4133441334
"source_path": "docs/sql-server/azure-arc/plan-evaluate-on-azure-virtual-machine.md",
41335-
"redirect_url": "/sql/sql-server/azure-arc/automatically-connect",
41335+
"redirect_url": "/sql/sql-server/azure-arc/automatically-connect#evaluate-azure-arc-enabled-sql-server-on-an-azure-vm",
4133641336
"redirect_document_id": false
4133741337
},
4133841338
{

‎azure-sql/database/connect-query-vscode.md‎

Lines changed: 30 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -1,16 +1,15 @@
11
---
22
title: Use Visual Studio Code to connect and query
33
titleSuffix: Azure SQL Database & SQL Managed Instance
4-
description: Learn how to connect to Azure SQL Database or SQL Managed Instance on Azure by using Visual Studio Code. Then, run Transact-SQL (T-SQL) statements to query and edit data.
4+
description: Learn how to connect to Azure SQL Database or Azure SQL Managed Instance by using Visual Studio Code. Then, run Transact-SQL (T-SQL) statements to query and edit data.
55
author: dzsquared
66
ms.author: drskwier
77
ms.reviewer: wiassaf, mathoma, randolphwest
8-
ms.date: 08/29/2023
8+
ms.date: 09/27/2023
99
ms.service: sql-database
1010
ms.subservice: connect
1111
ms.topic: quickstart
1212
ms.custom:
13-
- sqldbrb=2
1413
- mode-ui
1514
keywords: connect to sql database
1615
monikerRange: "=azuresql || =azuresql-db || =azuresql-mi"
@@ -19,7 +18,7 @@ monikerRange: "=azuresql || =azuresql-db || =azuresql-mi"
1918

2019
[!INCLUDE [appliesto-sqldb-sqlmi](../includes/appliesto-sqldb-sqlmi.md)]
2120

22-
[Visual Studio Code](https://code.visualstudio.com/docs) is a graphical code editor for Linux, macOS, and Windows. It supports extensions, including the [mssql extension](https://aka.ms/mssql-marketplace) for querying a SQL Server instance, Azure SQL Database, an Azure SQL Managed Instance, and a database in Azure Synapse Analytics. In this quickstart, you'll use Visual Studio Code to connect to Azure SQL Database or Azure SQL Managed Instance and then run Transact-SQL statements to query, insert, update, and delete data.
21+
[Visual Studio Code](https://code.visualstudio.com/docs) is a graphical code editor for Linux, macOS, and Windows. It supports extensions, including the [mssql extension](https://aka.ms/mssql-marketplace) for querying SQL Server, Azure SQL Database, Azure SQL Managed Instance, and a database in Azure Synapse Analytics. In this quickstart, you use Visual Studio Code to connect to Azure SQL Database or Azure SQL Managed Instance and then run Transact-SQL statements to query, insert, update, and delete data.
2322

2423
## Prerequisites
2524

@@ -40,11 +39,20 @@ monikerRange: "=azuresql || =azuresql-db || =azuresql-mi"
4039
4140
## Install Visual Studio Code
4241

43-
Make sure you have installed the latest [Visual Studio Code](https://code.visualstudio.com/Download) and loaded the [mssql extension](https://aka.ms/mssql-marketplace). For guidance on installing the mssql extension, see [Install Visual Studio Code](/sql/linux/sql-server-linux-develop-use-vscode#install-and-start-visual-studio-code) and [mssql for Visual Studio Code
44-
](https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql).
42+
Make sure you have installed the latest [Visual Studio Code](https://code.visualstudio.com/Download). For installation guidance, see [Install Visual Studio Code](/sql/linux/sql-server-linux-develop-use-vscode#install-and-start-visual-studio-code).
4543

4644
## Configure Visual Studio Code
4745

46+
### Windows
47+
48+
Load the [mssql extension](https://aka.ms/mssql-marketplace) by following these steps:
49+
50+
1. Open Visual Studio Code.
51+
1. Open the Extensions pane (or **Ctrl + Shift + X**).
52+
1. Search for `sql` and then install the **SQL Server (mssql)** extension.
53+
54+
For additional installation guidance, see [mssql for Visual Studio Code](https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql).
55+
4856
### macOS
4957

5058
For macOS, you need to install OpenSSL, which is a prerequisite for .NET Core that mssql extension uses. Open your terminal and enter the following commands to install **brew** and **OpenSSL**.
@@ -60,15 +68,17 @@ ln -s /usr/local/opt/openssl/lib/libssl.1.0.0.dylib /usr/local/lib/
6068

6169
### Linux (Ubuntu)
6270

63-
No special configuration needed.
71+
Load the [mssql extension](https://aka.ms/mssql-marketplace) by following these steps:
6472

65-
### Windows
73+
1. Open Visual Studio Code.
74+
1. Open the Extensions pane (or **Ctrl + Shift + X**).
75+
1. Search for `sql` and then install the **SQL Server (mssql)** extension.
6676

67-
No special configuration needed.
77+
For additional installation guidance, see [mssql for Visual Studio Code](https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql).
6878

6979
## Get server connection information
7080

71-
Get the connection information you need to connect to Azure SQL Database. You'll need the fully qualified server name or host name, database name, and login information for the upcoming procedures.
81+
Get the connection information you need to connect to Azure SQL Database. You need the fully qualified server name or host name, database name, and login information for the upcoming procedures.
7282

7383
1. Sign in to the [Azure portal](https://portal.azure.com/).
7484

@@ -82,7 +92,7 @@ In Visual Studio Code, set the language mode to **SQL** to enable mssql command
8292

8393
1. Open a new Visual Studio Code window.
8494

85-
1. Press **Ctrl**+**N**. A new plain text file opens.
95+
1. Press **Ctrl + N**. A new plain text file opens.
8696

8797
1. Select **Plain Text** in the status bar's lower right-hand corner.
8898

@@ -95,13 +105,13 @@ Use Visual Studio Code to establish a connection to your server.
95105
> [!IMPORTANT]
96106
> Before continuing, make sure that you have your server and sign-in information ready. Once you begin entering the connection profile information, if you change your focus from Visual Studio Code, you have to restart creating the profile.
97107
98-
1. In Visual Studio Code, press **Ctrl+Shift+P** (or **F1**) to open the Command Palette.
108+
1. In Visual Studio Code, press **Ctrl + Shift + P** (or **F1**) to open the Command Palette.
99109

100-
1. Select **MS SQL:Connect** and choose **Enter**.
110+
1. Type `connect` and then choose **MS SQL:Connect**.
101111

102-
1. Select **Create Connection Profile**.
112+
1. Select **+ Create Connection Profile**.
103113

104-
1. Follow the prompts to specify the new profile's connection properties. After specifying each value, choose **Enter** to continue.
114+
1. Follow the prompts to specify the new profile's connection properties. After specifying each value, press **Enter** to continue.
105115

106116
| Property       | Suggested value | Description  |
107117
| --- | --- | --- |
@@ -129,9 +139,9 @@ Run the following [SELECT](/sql/t-sql/queries/select-transact-sql) Transact-SQL
129139
ON pc.ProductCategoryId = p.ProductCategoryId;
130140
```
131141

132-
1. Press **Ctrl**+**Shift**+**E** to run the query and display results from the `Product` and `ProductCategory` tables.
142+
1. Press **Ctrl + Shift + E** to run the query and display results from the `Product` and `ProductCategory` tables.
133143

134-
:::image type="content" source="./media/connect-query-vscode/query.png" alt-text="Screenshot of query to retrieve data from 2 tables.":::
144+
:::image type="content" source="./media/connect-query-vscode/query.png" alt-text="Screenshot of query to retrieve data from 2 tables." lightbox="./media/connect-query-vscode/query.png":::
135145

136146
## Insert data
137147

@@ -160,7 +170,7 @@ Run the following [INSERT](/sql/t-sql/statements/insert-transact-sql) Transact-S
160170
);
161171
```
162172

163-
1. Press **Ctrl**+**Shift**+**E** to insert a new row in the `Product` table.
173+
1. Press **Ctrl + Shift + E** to insert a new row in the `Product` table.
164174

165175
## Update data
166176

@@ -174,7 +184,7 @@ Run the following [UPDATE](/sql/t-sql/queries/update-transact-sql) Transact-SQL
174184
WHERE Name = 'myNewProduct';
175185
```
176186

177-
1. Press **Ctrl**+**Shift**+**E** to update the specified row in the `Product` table.
187+
1. Press **Ctrl + Shift + E** to update the specified row in the `Product` table.
178188

179189
## Delete data
180190

@@ -187,7 +197,7 @@ Run the following [DELETE](/sql/t-sql/statements/delete-transact-sql) Transact-S
187197
WHERE Name = 'myNewProduct';
188198
```
189199

190-
1. Press **Ctrl**+**Shift**+**E** to delete the specified row in the `Product` table.
200+
1. Press **Ctrl + Shift + E** to delete the specified row in the `Product` table.
191201

192202
## Next steps
193203

‎azure-sql/database/connectivity-architecture.md‎

Lines changed: 0 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -51,8 +51,6 @@ Servers in SQL Database and dedicated SQL pools (formerly SQL DW) in Azure Synap
5151

5252
We highly recommend the `Redirect` connection policy over the `Proxy` connection policy for the lowest latency and highest throughput. However, you need to meet the extra requirements for allowing network traffic as outlined above. If the client is an Azure Virtual Machine, you can accomplish this using Network Security Groups (NSG) with [service tags](/azure/virtual-network/network-security-groups-overview#service-tags). If the client is connecting from a workstation on-premises, you may need to work with your network admin to allow network traffic through your corporate firewall.
5353

54-
> [!IMPORTANT]
55-
> Connections to private endpoint only support **Proxy** as the [connection policy](connectivity-architecture.md#connection-policy).
5654

5755
## Connectivity from within Azure
5856

0 commit comments

Comments
 (0)