SSMS Tutorial (SQL Server Management Studio) – Feature Demonstration

SSMS (SQL Server Management Studio) is a popular SQL editor that comes with SQL Server.

It has a range of features that let you work with SQL and databases more effectively. Yes, it can run SQL and show the tables in your database, but you can do much more with it.

In this video, you’ll see a range of features of SSMS, starting with connecting to the database, and including running queries, scripting objects to SQL, and more.

See the timestamps below for the full list of features included in the video.

Timestamps:
00:00 Start
00:40 Connect
01:14 Main window
01:40 Object explorer
01:57 New query editor
02:58 Execute query
03:33 Object explorer refresh
04:51 Run multiple queries
05:18 Select query
05:37 Intellisense
07:38 New tab
08:56 Script new tab
09:58 Save script
10:28 Open script
10:50 Dock windows (tab groups)
11:40 Results to text, grid, or file
12:43 Copy to Excel

/// RESOURCES
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here: https://www.databasestar.com/get-sql-cheat-sheets/
SQL Roadmap: an overview of SQL topics, which is a great place to start: https://www.databasestar.com/sql-roadmap/
Contact me here for questions, sponsorship requests, and more: https://www.databasestar.com/contact/
Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here: https://www.databasestar.com/dsa/