Skip to content

what-is.md

Latest commit

 

History

History
51 lines (34 loc) · 3.14 KB

what-is.md

File metadata and controls

51 lines (34 loc) · 3.14 KB
title What is SQL Operations Studio (preview)? | Microsoft Docs
description SQL Operations Studio (preview) is a free, light-weight tool, that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they're running.
ms.custom tools|sos
ms.date 11/17/2017
ms.prod sql
ms.reviewer alayu; sstein
ms.suite sql
ms.prod_service sql-tools
ms.component sos
ms.tgt_pltfrm
ms.topic overview
author stevestein
ms.author sstein
manager craigg

What is [!INCLUDEname-sos]?

[!INCLUDEname-sos] is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they're running.

[Download and Install [!INCLUDEname-sos]](download.md)

Transact-SQL (T-SQL) code editor with IntelliSense

[!INCLUDEname-sos] offers a modern, keyboard-focused T-SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich T-SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand T-SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. To learn how to use the T-SQL editor, see Use the T-SQL editor to create database objects.

Smart T-SQL code snippets

T-SQL code snippets generate the proper T-SQL syntax to create databases, tables, views, stored procedures, users, logins, roles, etc., and to update existing database objects. Use smart snippets to quickly create copies of your database for development or testing purposes, and to generate and execute CREATE and INSERT scripts.

[!INCLUDEname-sos] also provides functionality to create custom T-SQL code snippets. To learn more, see Create and use code snippets.

Customizable Server and Database Dashboards

Create rich customizable dashboards to monitor and quickly troubleshoot performance bottlenecks in your databases. To learn about insight widgets, and database (and server) dashboards, see Manage servers and databases with insight widgets.

Connection management (server groups)

Server groups provide a way to organize connection information for the servers and databases you work with. For details, see Server groups.

Integrated Terminal

Use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, and ssh) in the Integrated Terminal window right within the [!INCLUDEname-sos] user interface. To learn about the integrated terminal, see [Integrated terminal] (integrated-terminal.md).

Next steps