About this lesson
We will install and setup SQL Server Management Studio.
Download this lesson’s exercise file.Setting Up Microsoft SQL Server Management Studio.docx
Setting Up Microsoft SQL Server Management Studio
SSMS provides the interface that allows us to work with our databases.
When to use
Anytime you want to use SQL Server 2016, you'll use SSMS.
Download the free SSMS from the link that appears on the pop up box after you installed SQL Server 2016. Or Google it and download it from the official Microsoft website.
SSMS is what we will be using to work with our databases and write our SQL.
Hints & tips
- SSMS is the main tool we'll use throughout the course.
- It interfaces with our Database and allows us to do everything we need to do to work with our database.
- You'll need to restart your computer after you install SSMS.
Lesson notes are only available for subscribers.