Skip to content

notebooks-manage-sql-server.md

Latest commit

 

History

History
69 lines (43 loc) · 2.62 KB

notebooks-manage-sql-server.md

File metadata and controls

69 lines (43 loc) · 2.62 KB
title Manage a SQL Server notebook
description Learn how to manage notebooks in Azure Data Studio. This includes opening notebooks, saving them, and changing your big data cluster connection.
author markingmyname
ms.author maghan
ms.reviewer achatter, alayu, mikeray
ms.metadata seo-lt-2019
ms.topic conceptual
ms.prod sql
ms.technology azure-data-studio
ms.custom
ms.date 03/30/2020

How to manage notebooks in Azure Data Studio

[!INCLUDEtsql-appliesto-ssver15-xxxx-xxxx-xxx]

This article shows you how to open and save notebook files in Azure Data Studio with SQL Server. It also demonstrates how to change your connection to your SQL Server.

Open a notebook

There are several ways to open the Open Notebook dialog. You can use the File menu, the Dashboard, and the Command Palette. The following sections describe each method.

File menu

Select File Open from the File menu Ctrl+O (in Windows) and Cmd+O (in Mac).

Open the Open File dialog by selecting File Open

Dashboard

Click Open Notebook in the dashboard to open the File Open dialog.

Open the Open File dialog by selecting Open Notebook in the dashboard

Command Palette

Use command File: Open from command palette by typing Ctrl+Shift+P (in Windows) and Cmd+Shift+P (in Mac).

Open the Open File dialog by entering File: Open in the command palette

Save a notebook

There's currently one way to save a notebook. Select Save from the notebook toolbar.

Save File by selecting Save in the notebook toolbar

Note

The following methods currently do not save changes to notebooks:

  • File Save, File Save As... and File Save All commands from the File menu.
  • File: Save commands entered in the command palette.

Change the connection

To change the connection for a notebook:

  1. Select the Attach to menu from the notebook toolbar and then select Change Connection.

    Click the Attach to menu in the notebook toolbar

  2. Now you can either select a recent connection server or enter new connection details to connect.

    Select a server from the Attach to menu

Next steps

For more information about notebooks in Azure Data Studio, see How to use notebooks in SQL Server 2019.