OSQL Utility - or scripting for SQL Server

Database Journal has an article on SQL Server's OSQL Utility which allows you to connect and interact with SQL Server from the command line. Batch scripts for administrative tasks are something admins in a Unix environment take for granted and can't imagine being without, and with good reason... so if you're stuck in the GUI of Enterprise Manager and Query Analyzer break out of it for a bit and get a feel for running some jobs through OSQL.

Good applications for it are running jobs on multiple servers, installing new servers, and storing schema snapshots. In truth, just about any repetitive task is possible.