什麼是Microsoft SQL Operations Studio (預覽)Microsoft SQL Operations Studio (preview)What is Microsoft SQL Operations Studio (預覽)Microsoft SQL Operations Studio (preview)?

SQL Operations Studio (preview)SQL Operations Studio (preview) 是免費的工具來管理 SQL Server、 Azure SQL Database 和 Azure SQL 資料倉儲; 在 Windows、 macOS 和 Linux 上執行只要它們正在執行。 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.

下載並安裝 SQL Operations Studio (preview)SQL Operations Studio (preview)Download and Install SQL Operations Studio (preview)SQL Operations Studio (preview)

IntelliSense 的 TRANSACT-SQL (T-SQL) 程式碼編輯器Transact-SQL (T-SQL) code editor with IntelliSense

SQL Operations Studio (preview)SQL Operations Studio (preview) 提供現代、 鍵盤焦點 T-SQL 程式碼撰寫體驗,讓您日常工作更容易,因為內建功能,例如多個索引標籤視窗、 豐富的 T-SQL 編輯器、 IntelliSense、 關鍵字完成、 程式碼片段中,巡覽程式碼和原始檔控制整合 (Git)。 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). 執行隨 T-SQL 查詢、 檢視並將結果儲存為 text、 JSON 或 Excel。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. 若要深入了解如何使用 T-SQL 編輯器,請參閱使用 T-SQL 編輯器來建立資料庫物件To learn how to use the T-SQL editor, see Use the T-SQL editor to create database objects.

智慧 T-SQL 程式碼片段Smart T-SQL code snippets

T-SQL 程式碼片段會產生適當的 T-SQL 語法來建立資料庫、 資料表、 檢視、 預存程序、 使用者、 登入、 角色等等,並更新現有的資料庫物件。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.

SQL Operations Studio (preview)SQL Operations Studio (preview) 也提供功能,以建立自訂的 T-SQL 程式碼片段。 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. 若要深入了解深入了解 widget 和資料庫 (和伺服器) 的儀表板,請參閱管理伺服器和資料庫,以深入了解 widgetTo 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

使用您最愛的命令列工具 (例如,被,PowerShell、 sqlcmd、 bcp,和 ssh) 在整合式終端機視窗內SQL Operations Studio (preview)SQL Operations Studio (preview)使用者介面。Use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, and ssh) in the Integrated Terminal window right within the SQL Operations Studio (preview)SQL Operations Studio (preview) user interface. 若要深入了解整合的終端機,請參閱 [整合式驗證終端機] (整合 terminal.md)。To learn about the integrated terminal, see Integrated terminal.

後續步驟Next steps