We will be using Microsoft SQL Server 2005 running on iprojsrv.cs.washington.edu. Accounts on it have been set up for each of you, and you have been given your user names and passwords. 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 aria.cs.washington.edu (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