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.

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 ...

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...