Getting Started

• Install SMO. This step is unnecessary if SQL Server Management Studio is installed (SMO is included) otherwise SMO is available as separate download as part of the Microsoft SQL Server 2008 Feature Pack
• Install PowerShell Version 2.0
• Set PowerShell execution policy to remotesigned. Launch PowerShell and type Set-ExecutionPolicy RemoteSigned

Installer Installation

• Download SQLPSX.msi (SQLPSX)
• Install MSI:

Manual Installation

• Download SQLPSX_2.3.2.1 (SQLPSX)
• Unblock and unzip SQLPSX_2.3.2.1 zip file
• Copy the modules to My Documents\WindowsPowerShell\Modules\. For example adoLib should be copied to My Documents\WindowsPowerShell\Modules\adoLib
• Verify modules are available bye typing get-module -listAvailable
• Import modules:

import-module adolib
import-module SQLServer
import-module Agent
import-module Repl
import-module SSIS
import-module SQLParser
import-module Showmbrs
import-module SQLMaint
import-module SQLProfiler
import-module PerfCounters
PBM module should be sourced in sqlps mini-shell:
. ./pbm.psm1

• Add import-module commands to your Profile if desired

SQLIse

SQLIse is meant to be used within the PowerShell Integrated Scripting Editor (ISE). Import the SQLIse module within PowerShell ISE*:
import-module sqlise

• Add import-module sqlise to your PowerShell ISE profile: "Microsoft.PowerShellISE_profile.ps1" if desired.

See the 5 minute video on SQLIse

SQLIse Screenshots

SQLPSX Optional Reporting

See Installing Optional Reporting Components

SQLPSX Online Help

SQLPSX Help