Starting with SQL Server

We will be using Microsoft SQL Server 2005 running on Accounts on it will be set up for each of you using your regular CSE userid. For the first homework, you need to set up an interactive query session with the server. For this, you will need access to SQL Server Management Studio, which is installed on the machines in the undergrad labs. You will it for both administrative tasks and interactive querying. The first thing you need to do is register the server, and change your password.

If you are at home or not in the lab, you can use Remote Desktop Connection from any windows machine to connect to (use your regular cse login credentials). Once you are logged in to this machine, you can use SQL Server the same as you would use it in the lab.

For the first homework, you will use Management Studio to connect to the server, and run SQL queries. This will involve the following steps:

The variant of SQL supported by SQL Server is called Transact-SQL. In addition to executing all Transact-SQL statements, management Studio can also be used to view query execution plans, statistics, and more.

You are welcome to create and play with your own databases. You can either use SQL statements for this, or you can use Management Studio.

Management Studio Manual