It can be run from the command line or in the ISE, which I prefer. To get started running scripts, you have to change the default execution policy, as explained here. Then, to work with SQL Server, ...