Install SQL Server Management Studio
Follow the steps in this tip to install SQL Server Management Studio (SSMS). The SSMS installation is very straight forward and is relevant for all versions of the product.
SQL Server Management Studio
SQL Server Management Studio (SSMS) how to download, install, configure, use and more from these articles for DBAs and Developers.
SQL Server Management Studio Time Saving Tips
This tip covers SSMS features like filter objects, debug, drag and drop object names, custom reports and use of operators for emails.
SQL Server Single User Mode Connection with SQL Server Management Studio
In this article we look at how to connect to SQL Server using SQL Server Management Studio when SQL Server is in single user mode.
SQL Server Management Studio Connection to Integration Services Error Class Not Registered
Resolve the SSMS to SSIS connection error with our guide. Learn how to troubleshoot the 'Class not registered' issue.
SQL Server Database Diagram Index was Outside the Bounds of the Array
In this article we look at the SSMS database diagram error index was outside the bounds of the array and how to fix this issue.
How does SQL Server Management Studio get its data
In this tip we look at a simple way to capture what queries SQL Server Management Studio uses to fill the screens when you navigate through SSMS.
Download, Install and Update SQL Server Management Studio
In this part we look at how to download, install and update SQL Server Management Studio.
Import and Export Data with SQL Server Management Studio
This section shows how SSMS allows you to quickly import and export data to or from a database.
SQL Server Management Studio Maintenance Plan
In this section we look at an overview of how to access and create Maintenance Plans with SSMS.
SQL Server Management Studio Backwards Compatibility
SSMS is backwards compatible and newer versions can work with older versions of SQL Server, so you don't need to install several different versions to support your environment.
SQL Server Management Studio Standard Reports
This part provides an overview of the available reports in SSMS to assist with performance tuning.
SQL Server Management Studio Object Explorer
In this part we look at how to open Object Explorer when using SSMS.
SQL Server Management Studio Overview (SSMS)
This gives an overview of what SQL Server Management Studio is and what it is used for.
SQL Server Management Studio Shortcut Keys
This section looks at some useful shortcuts you can use with SQL Server Management Studio.
Using Activity Monitor in SQL Server Management Studio
In this part we look at how to access Activity Monitor to assist you with monitoring current performance and performance related items.
Use SQL Server Management Studio to Connect to Database
In this section we look at how to use SSMS to connect to a SQL Server database engine.
Who Uses SQL Server Management Studio and Why
In this section we look at the various uses of SSMS and the different types of SQL professionals that might use SSMS.
Working with Error Logs in SQL Server Management Studio
In this part we look at how to access the SQL Server log files that are generated by SQL Server to track and report on various things.
Working with SQL Server Agent in SQL Server Management Studio
In this section we look at how to access SQL Server Agent from SSMS which allows you to schedule and automate tasks.
How to create a table using SQL Server Management Studio
In this article we look at how to create a table using the SQL Server Management Studio Table Designer as well as how to create a primary key and foreign key relationships.
SQL Server Management Studio 18 New Features
In this tip we look at two new features of SQL Server Management Studio that are worth getting, high definition interface support and increased query results output size to 2MB.
Prevent SQL Code Running by Accident using SSMS and TSQL
Learn some about options in SQL Server Management Studio to double check your code and avoid running code by accident with a few simple checks.
SQL Server Management Studio 17.x Important Features
In this tip we look at some new features in SQL Server Management Studio 17.x.
Capture SQL Server Management Studio Queries and Telemetry Data
In this tip we look at a new feature in SSMS 17.x that allows us to see what queries SSMS is using to pull data from the database for the GUI. In addition, we look at the data that Microsoft automatically collects when using SSMS.