A word on modules and plugins

There are a few that I make heavy use of and are pretty common, but I’ll give a brief on the major ones just for a CYA.

SQLPS

I don’t know what I’d do without it!  The main thing that I love about PowerShell over VBScript is that I don’t have to do a ton of object building, I just jump in and start using them.  SQLPS lets you do that with SQL, where you used to have to run code similar to this:

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SMO”) 
$MyServer = new-object (‘Microsoft.SqlServer.Management.Smo.Server’) ‘HOME’ 
$MyDataBase = new-object (‘Microsoft.SqlServer.Management.Smo.Database’) ($Server, “MyDataBase”)

Now all you need to do is run Import-Module SQLPS and it unleashes the power of all the Cmd-Lets.  To use SQLPS, you’ll need to install these three items from the link above:

  1. Microsoft System CLR Types for Microsoft SQL Server 2012
  2. Microsoft SQL Server 2012 Shared Management Objects
  3. Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2012

 

Quest ActiveRoles Management Shell for Active Directory

Very similar to the plug-in that you can get from Microsoft for AD management, but with a lot of extra switches and parameters to help simplify command syntax.  You can find the complete wiki here.

There are more that I’ve made use of here and there and I’ll add them to this list as I post scripts that use them.

Advertisements
This entry was posted in Announcements, Programming and tagged , , , , . Bookmark the permalink.

One Response to A word on modules and plugins

  1. Pingback: PoSH: Connecting to an Remote Domain | Rich Hopkins

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s