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

SQL Operations Studio (預覽)SQL Operations Studio (preview)是一套可在 Windows, macOS 和 Linux 上執行的免費工具,可用於管理 SQL Server、 Azure SQL Database 和 Azure SQL 資料倉儲,而毋須考慮其所在的平台。 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 (預覽)SQL Operations Studio (preview)Download and Install SQL Operations Studio (預覽)SQL Operations Studio (preview)

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

SQL Operations Studio (預覽)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. 使用智慧程式碼片段快速建立資料庫副本以進行開發或測試,並生成和執行 CREATE 和 INSERT 指令。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 (預覽)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. 若要深入了解 insight widget 和資料庫 (和伺服器)的儀表板,請參閱透過 insight widget 管理伺服器和資料庫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

SQL Operations Studio (預覽)SQL Operations Studio (preview) 使用者介面的整合式終端機視窗中,使用您喜歡的命令列工具 (例如:Bash, PowerShell, sqlcmd, bcp和 ssh)。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 (預覽)SQL Operations Studio (preview) user interface. 若要深入了解整合式終端機,請參閱[整合式驗證終端機] (整合 terminal.md)。To learn about the integrated terminal, see Integrated terminal.

後續步驟Next steps