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.

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

[studymode]

I've been struggling with how to make query with sql in ssms, but it seems clear after watching this video. Thanks a lot

[technewbie]

This video was great! Will definitely watch more of his videos on SQL.

[olumuyiwaagboola]

I wish I could like this video a hundred times. Great great content!

[stalinnrinifati]

Thank you so much. You have been helpful

[tiyanibaloyi]

Great Video I learned a lot. Keep making good videos.

[loco]

what is your SQL version? i downloaded latest version but couldnt find SQL configuration management

[CasuallySerious]

Hi, thank you for this. However, I installed the ssms and after creating a new database, each time I try to import data into the database, the import and export wizard doesn’t pop up. I’ve tried uninstalling and reinstalling to no avail. Can you help out on what could be wrong? Thank you.

[sudhirmore]

Can we create materialized view by using ssms

[reyan_XPhonk]

hey hye hye homiee
let me tell you
ahhh i dont have any words!
you are best!

[leftofright]

Hi, thanks for this video – as i am completely new to working on the server management studio – is there a way to export entire tables to excel at once?

[hasanmougharbel]

Hey there, God bless your efforts.
I a a newbie sql learner with a simple enquiry.
Where can i find a table with its properties that i have already created in sql managment studio?
Thanks for taking care of this.

[arwahsapi]

Can SSMS 2008 be used to manage SQL Server 2019 or newer? Cos I still love the UI of SSMS 2008

[joelikeanumba]

I want to write a new code, How do i open a New tab on SSMS .?

[wordlife_]

Hey, would you be able to assist me on my homework for SSMS? im willing to pay

[VasylHakman]

hello please say best sql server for docker?