Setting Up MSSQL

For the labs assignments in this course, we will be using Microsoft's SQL Server. You will thus need access to that system. There are several ways you can do that as I describe below.

You will also want Microsoft’s SQL Server Management Studio (SSMS). You can download that (for free) here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017. This tool, based on Visual Studio, allows you to create “database projects” that contain the scripts you need to set up a database as well as query it. The tool is nice (although somewhat complex). We will definitely be using it. Note that SSMS allows you to interact with multiple instances of SQL Server, including Azure instances.


Last Revised: 2019-01-21
© Copyright 2019 by Peter C. Chapin <pchapin@vtc.edu>