SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

To execute SQL commands and queries, add a semicolon (;) when the query is complete and then press . Here we create a new database, connect to it, connect back to our default database, and finally ...

I used Microsoft's sqlcmd tool on Mac and Linux boxes to connect to the running database instance. Once connected with sqlcmd, you can start running all your familiar SQL commands. I created a ...

Figure 1. A SQL Server query against the Northwind database executed in PowerShell. (Click image to view larger version.) Fig. 2 is that same query as executed in SSMS (yes, I finally did get it to ...