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

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

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

Comments

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.