GETTING STARTED WITH SQL SERVER

We will be using Microsoft SQL Server running on iisqlsrv.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 client tools, which are installed on the machines in the undergrad labs. You will use "Enterprise Manager" for administrative tasks, and "Query Analyzer" for interactive querying. The first thing you need to do is register the server, and change your password, which is described here.

For the first homework, you will use Query Analyzer 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, Query Analyzer can also be used to view query execution plans, statistics, and more.

Query Analyzer Manual

You are welcome to create and play with your own databases. Besides using SQL statements for this, you can also use Enterprise Manager, which is a convenient graphical tool for database design, modification and administrative tasks. To access the server using Enterprise Manager, on the Console Root, expand Microsoft SQL Servers, then expand SQL Server Group, and finally expand IISQLSRV.

Enterprise Manager Manual