SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Powershell Extensions PowerGUI PowerPack

If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is a free utility provided by Quest. It's both a script editor with PowerShell syntax highlighting and GUI builder for PowerShell scripts. The editor is a very usable standalone component which I recommend to folks looking for a good PowerShell script editor. The other standalone GUI component returns the results of PowerShell commands and scripts in a grid format,  additional actions and links can be created on the objects displayed. PowerGUI  provides a quick method  to create simple GUIs in PowerShell which kind of have the look and feel of MMCs. PowerGUI has a bunch of management packs they call PowerPacks that address various technologies including AD, Exchange and SQL Server. All of this is usable out of the box without writing any code.
Should you want to build your own GUIs, there are a couple of ways you can approach PowerGUI development. You could create PowerShell scripts and functions directly in PowerGUI. Alternatively, simply call your functions which have been sourced in your profile. I've choosen to do the later and created a PowerPack for SQL Server PowerShell Extensions. Here's a few screenshots:
Integration Services
As a DBA, I can see the potential for using PowerGUI to create administration views for areas outside of Database Administration. For many years I've thought it would be nice to have a scaled down Enterprise Manager or SQL Server Managment Studio tailed for particular job functions such as junior DBAs, computer operators, or login provisioning. With PowerGUI it would trivial for a DBA to create such a view. So, try out PowerGUI yourself, customize it for your needs and leave some feedback.

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.


No comments.

Leave a Comment

Please register or log in to leave a comment.