Uredi

Deli z drugimi prek

Components and features in SQL Server Management Studio

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

This article describes the components and features available in SQL Server Management Studio (SSMS).

Feature overview

Component or feature Description Article
GitHub Copilot in SSMS (Preview) Chat, code actions (Document, Explain, Fix, Optimize), walkthrough, model selection, and Bring Your Own Model (BYOM). Get started with GitHub Copilot in SQL Server Management Studio (Preview)
Query Hint Recommendation Tool (Preview) Analyze statements and apply recommended hints. Installed via Visual Studio Installer > Individual Components > Code Tools. Query Hint Recommendation tool (Preview)
Git integration Integration with Git for tracking, managing, and collaborating on SQL scripts. Clone and create repositories, manage branches, and view diffs inside SSMS, using the same familiar interface as Visual Studio. About Git in Visual Studio
Modern connection dialog Browse Microsoft Fabric resources, copy and paste connection strings, and manage encryption and certificate options more easily. Quickstart: Connect and query a SQL Server instance
SQL Server migration component Assess, prepare, and migrate your SQL Server databases. SQL Server migration component in SQL Server Management Studio
Object Explorer View and manage all objects in one or more instances of the SQL Server Database Engine. Object Explorer
Template Explorer Build and manage files of boilerplate text that you use to speed the development of queries and scripts. Template Explorer
Visual Database Tools Use the visual design tools included in SSMS to build queries, tables, and diagram databases. Visual Database Tools
Query Editor Use the SSMS language editors to interactively build queries and scripts. Query and text editors

Management, security, and productivity

This section describes management, security, developer, and productivity capabilities in SSMS.

Database engine support

SSMS supports the following database engines:

Encryption and security

SSMS supports the latest TLS 1.3 and TDS 8 encryption options.

Indexes and data types

SSMS includes full support for JSON and vectors. You can also view JSON data in the results pane.

Business intelligence administration

You can use SSMS to access, configure, manage, and administer Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).

Note

To create and modify SSAS, SSIS, and SSRS solutions, use SQL Server Data Tools (SSDT).

Component Details
SSIS Manage the SSISDB catalog, execute packages, and use the Import/Export Wizard.
SSAS Script projects using MDX, DAX, DMX, or XMLA, and handle object processing and backups.
SSRS 1 Perform server-level administration tasks like managing roles, jobs, and schedules for SQL Server 2022 (16.x) and earlier versions.

1 For more information, see Reporting Services consolidation FAQ.

Productivity and user experience

SSMS includes the following new features and improvements:

  • Presenter mode improvements.
  • Integrated terminal access.
  • Dark mode theme.
  • Support for new data types and indexes in Object Explorer and results pane.

Platform compatibility

SSMS is available for x86-64 and Arm64 processors on Windows.

For more information about Arm64 support, see:

Release notes and known issues

Related content

  • Last updated on