Find a computer in the Sieg building which has SQL Server installed, and make sure you have received an account name and password for ISQL01. This is a distinct account from any others you may have at cse. (If you have a windows machine, but SQL Server is not installed, it is available over the network on rfilesrv. For various reasons, you won't find SQL Server installed on Hydra, so if you are running Linux, find a Windows friend, or a lab.)
In Windows, goto Start, Programs, Microsoft SQL Server, Query
Analyzer.
A box labelled Connect to SQL Server should show up.
In the input box labelled SQL Server, type ISQL01
Select the Use SQL Server authentication option.
As Login Name type your-ISQL01-login
As Password type your-ISQL01-password
Press OK
By doing the last step, you connected to the SQL Server machine called
ISQL01, using your personal account.
If it is not already shown, use the Tools menu to show the Object Browser. In the Object Browser, under ISQL01, you should see your login name, and if you expand it you will find a folder entitled User Tables. This folder will be empty.
You will create the database by executing this file as an sql script. Paste the file into the blank query window on the right. Then execute the script using the green triangle button or Ctrl-E. It may take a few moments... Next, right click on your login name in the Object Browser and choose Refresh. You should now see the five tables of your database listed under the User Tables folder. Right click on any table and choose Open to view the data.
Try to write a simple query. Open a new query window from the File menu, and type:
select * from MOVIES
Execute the query and verify the results.
Congratulations - you just ran your first query. You may want to write the required queries here in the Query Analyzer to check the results before integrating them into your Perl script.