Sign up
Sign in
Sign up
Sign in
Member-only story
Maxime Godfroid
Follow
Towards Data Science
--
Share
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.
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 by new data types, operators, and functionalities.
Microsoft SQL Server Management Studio mostly referred to as SSMS is a tool used for configuring, managing, and administering data. The tool allows you to connect to SQL Server instances on-premises (the cool kids say ‘on-prem’ ) and in the cloud.
In short: a lot of things. A more verbose answer would be that within SSMS you can:
--
--
Towards Data Science
Data Scientist Lead | Runner by day | Podcaster by night | Also a tech & sports enthusiast | Subscribe to get all my stories | Twitter @max_godfroid
Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams

source