Some of these modules use what is called the SQL Management Object (SMO) which allows you to load some assemblies to be able to connect to a SQL server and then explore the server and its database and ...

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.

The SMO is a collection of .NET objects that are designed for programming against SQL Server. In the early days of the SQLPS module, using PowerShell against SQL Server required development skills ...

Third parties can create providers: For example, there is a SQL Server provider that ... More power to you! The modules feature is where PowerShell gets its ability to address a ton of different ...

part of the SQL Server PowerShell Extensions CodePlex project (SQLPSX). So I checked it out and learned that "SQLPSX consists of 13 modules with 163 advanced functions, 2 cmdlets and 7 scripts for ...