powershell connects to sqlserver

How to issue sql query to sql server database by using powershell ?

Here is the Link : http://sev17.com/2010/07/making-a-sqlps-module/

Steps:

1) Make a module 

    1.1) Copy file/folder under 100/Binn to powershell/vx.0/modules/sqlps

• en
• Microsoft.SqlServer.Management.PSProvider.dll
• Microsoft.SqlServer.Management.PSSnapins.dll
• SQLProvider.Format.ps1xml
• SQLProvider.Types.ps1xml

    1.2) create a file named "sqlps.psd1"

@{

ModuleVersion="0.0.0.1"
Description="A Wrapper for Microsoft's SQL Server PowerShell Extensions Snapins"
Author="Chad Miller"
Copyright="© 2010, Chad Miller, released under the Ms-PL"
CompanyName="http://sev17.com"
CLRVersion="2.0"
FormatsToProcess="SQLProvider.Format.ps1xml"
NestedModules="Microsoft.SqlServer.Management.PSSnapins.dll","Microsoft.SqlServer.Management.PSProvider.dll"
RequiredAssemblies="Microsoft.SqlServer.Smo","Microsoft.SqlServer.Dmf","Microsoft.SqlServer.SqlWmiManagement","Microsoft.SqlServer.ConnectionInfo","Microsoft.SqlServer.SmoExtended","Microsoft.SqlServer.Management.RegisteredServers","Microsoft.SqlServer.Management.Sdk.Sfc","Microsoft.SqlServer.SqlEnum","Microsoft.SqlServer.RegSvrEnum","Microsoft.SqlServer.WmiEnum","Microsoft.SqlServer.ServiceBrokerEnum","Microsoft.SqlServer.ConnectionInfoExtended","Microsoft.SqlServer.Management.Collector","Microsoft.SqlServer.Management.CollectorEnum"
TypesToProcess="SQLProvider.Types.ps1xml"
ScriptsToProcess="Sqlps.ps1"
}

    1.3) craete a file named "sqlps.ps1"

Set-Variable -scope Global -name SqlServerMaximumChildItems -Value 0
Set-Variable -scope Global -name SqlServerConnectionTimeout -Value 30
Set-Variable -scope Global -name SqlServerIncludeSystemObjects -Value $false
Set-Variable -scope Global -name SqlServerMaximumTabCompletion -Value 1000

2) import-module SQLPS 

Now you can issues query to sql server by using invoke-sqlcmd -query xxxx -database xxxx -serverinstance xxxx