This project is read-only.

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


Last edited Sep 25, 2013 at 1:41 PM by cmille19, version 24


MikeShepard Jul 6, 2016 at 3:32 AM 
I've added a zip of the online help files. I've also updated the site at

luisjmlky Feb 3, 2016 at 10:33 AM 
Hi when I click in SQLPSX Help (SQLPSX Online Help) the page shows this error:
This page can’t be displayed

•Make sure the web address is correct.
•Look for the page with your search engine.
•Refresh the page in a few minutes.

I would like read a detailed information about these commands and his parameters

cmille19 Sep 25, 2013 at 1:42 PM 
Thanks -- Updated online link to new URL.

Chromebuster Sep 16, 2013 at 4:39 PM 
just to let you know, your domain for the online help for this project seems to be possibly for sale. Is this the way it's supposed to be? are these wonderful PowerrShell extensions being discontinued? I'd hate it if that were the case.