SQL Server Management Studio

E56734
database management tool graphical user interface integrated development environment

SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.

Jump to: Surface forms Statements Referenced by

Observed surface forms (4)

Surface form Occurrences
IntelliSense for T-SQL 2
SQL Server Agent job management 1
SQL Server Management Studio Live Query Statistics 1

Statements (59)

Predicate Object
instanceOf database management tool ⓘ
graphical user interface ⓘ
integrated development environment ⓘ
developer Microsoft ⓘ
distributionModel separate download from SQL Server engine ⓘ
standalone installer ⓘ
fileExtension .sql ⓘ
hasComponent Activity Monitor ⓘ
Database Diagrams ⓘ
Object Explorer ⓘ
Query Editor ⓘ
Registered Servers ⓘ
Solution Explorer ⓘ
Template Explorer ⓘ
hasFeature Database Tuning Advisor integration ⓘ
SQL Server Management Studio self-linksurface differs ⓘ
surface form: IntelliSense for T-SQL

SQL Server Management Studio self-linksurface differs ⓘ
surface form: SQL Server Agent job management

SQL Server Profiler integration ⓘ
activity monitoring ⓘ
graphical execution plan viewer ⓘ
import and export wizard ⓘ
linked server configuration ⓘ
live query statistics ⓘ
login and user management ⓘ
maintenance plan wizard ⓘ
policy-based management ⓘ
query execution statistics ⓘ
role-based security management ⓘ
source control integration via extensions ⓘ
table designer ⓘ
introducedWith SQL Server ⓘ
surface form: SQL Server 2005
license freeware ⓘ
proprietary software ⓘ
operatingSystem Windows ⓘ
primaryLanguage English ⓘ
publisher Microsoft ⓘ
replaced Enterprise Manager ⓘ
shortName SQL Server Management Studio self-linksurface differs ⓘ
surface form: SSMS
supportsAuthentication SQL Server Authentication ⓘ
Windows Authentication ⓘ
supportsDatabaseSystem Azure SQL Database ⓘ
Azure SQL Managed Instance ⓘ
SQL Server ⓘ
surface form: Microsoft SQL Server
supportsLanguage SQL ⓘ
SQL ⓘ
surface form: Transact-SQL
supportsPlatform Windows ⓘ
surface form: Microsoft Windows
usedFor administering Microsoft SQL Server ⓘ
backing up SQL Server databases ⓘ
configuring Microsoft SQL Server ⓘ
debugging T-SQL code ⓘ
designing database schemas ⓘ
developing T-SQL scripts ⓘ
executing queries ⓘ
managing SQL Server Agent jobs ⓘ
managing SQL Server security ⓘ
monitoring SQL Server performance ⓘ
querying Microsoft SQL Server ⓘ
restoring SQL Server databases ⓘ
website https://learn.microsoft.com/sql/ssms/sql-server-management-studio-ssms ⓘ

Referenced by (12)

Full triples — surface form annotated when it differs from this entity's canonical label.

Management Data Warehouse → accessedBy → SQL Server Management Studio ⓘ
SQL Server Profiler → accessedVia → SQL Server Management Studio ⓘ
Policy-Based Management → configuredWith → SQL Server Management Studio ⓘ
Resource Governor → configuredWith → SQL Server Management Studio ⓘ
SQL Server → hasComponent → SQL Server Management Studio ⓘ
SQL Server Management Studio → hasFeature → SQL Server Management Studio self-linksurface differs ⓘ
this entity surface form: IntelliSense for T-SQL
SQL Server Management Studio → hasFeature → SQL Server Management Studio self-linksurface differs ⓘ
this entity surface form: SQL Server Agent job management
Always Encrypted → integratesWith → SQL Server Management Studio ⓘ
Data Quality Services → integratesWith → SQL Server Management Studio ⓘ
SQL Server Profiler → recommendedReplacement → SQL Server Management Studio ⓘ
this entity surface form: SQL Server Management Studio Live Query Statistics
SQL Server Management Studio → shortName → SQL Server Management Studio self-linksurface differs ⓘ
this entity surface form: SSMS
SQL Server Data Tools → supportsFeature → SQL Server Management Studio ⓘ
this entity surface form: IntelliSense for T-SQL