Member-only story
Learn SQL Server Management Studio — Part 1 Step by Step Setup
A free and powerful tool to leverage data, skill-up, and stand out during interviews
What to Expect?
In this series of articles, I will do a walkthrough of the Microsoft SQL Server Management Studio (SSMS). Today we’ll start with a setup of the environment. In the next articles, we’ll create our own databases and tables. Create, read, update, delete records. We’ll write, save and alter our own stored procedures. We’ll also schedule jobs, create SSIS packages… If you’re not familiar with some of those terms, you’ll soon get more than a grasp, and create and manage them yourself.
SSMS is a powerful tool, and an interesting skill to have on your belt if you’re looking to skill-up or interview for another job. It is also a chance to put into practice what you learned during your SQL 101 on a browser window, but never got a chance to experience the feel of database management software.
What is SQL?
SQL stands for Structured Query Language. It is designed to manage data from relational databases. And spoiler alert: it does it really well. The language was born in the 1970s¹ and has since evolved quite a bit. Over the 40+ years of its existence, the language was enriched…
