HowTo

1. How to communicate with an SQLServer from Unix:
   • pymssql

1. Cluster
   • You can set the priority of jobs in the wait queue so that you can control which order they are submitted to the cluster.
     • use 'qsub -p <priority>' command when submitting the job
       • qsub -p -1 <command>
     • priority can also be changed after a job has been submitted using the 'qalter -p <priority> command, for example
       • qalter 8852 -p -1
       • setting a job to -1 makes it lower than the default priority of '0', so this job will be queued after default priority jobs.
     • priority is an integer in the range -1023 to 1024. The default priority value for jobs is 0.
   • you can only decrease the priority of your jobs unless you are the queue administrator

1. Adding a printer from a laptop (added by DStoms, 3/10/09, thanks to Maki)

• From your laptop, go to printer setting, and start "add printer".
• Choose "add local printer", and choose "create new port".
• Then you can choose "Standard TCP/IP Port" from the list. And click Next.
• In the next window, you can put host name or IP address, and click Next.
  • The IP address for biogeog (Xerox 4400) is 128.111.110.8 (as of 3/12/09).
  • If this has changed, you can find the IP address as follows:
    • First, go to the printer, and choose "menus", push OK.
    • Then choose "Connection Set Up" push OK.
    • Then choose "TCP/IP setup menu", push OK.
• You can choose a right driver from the list, or your PC may specify which one is it, and the driver will be installed.