Once you have this module downloaded and installed, it's time to get started. To test a SQL database connection, you'll need at least four pieces of information: the user name password, database name ...

Use SqlServerCmdletSnapin100 (installed when you install the SQL Server client tools, 2008 or newer (maybe 2005)) and it gets a lot easier.

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.