Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.

SQLIse A PowerShell SQL Server Query Tools Gets an Update

After the first release of SQLIse (“SQL Ice”)--a basic IDE for T-SQL that includes ability to edit, execute, parse, format SQL code from within PowerShell ISE, several people contacted me to help add new features. The result is SQL Server PowerShell Extensions (SQLPSX) 2.2 with many enhancements to SQLIse…

SQLIse Features

  • Offline parsing of T-SQL code
  • Formatting (prettifying) of T-SQL with an extensive customization abilities
  • Comment/Uncomment T-SQL code
  • Uppercase/Lowercase T-SQL code
  • Execute T-SQL code and output to grid, text, text file or CSV file
  • Apply any of the above actions to selections of code by highlighting
  • Table and object browsers*
  • PoshMode (like sqlcmdmode)*
  • Save output to variable*
  • Save and manage connections*
  • Tab Expansion of schemas, tables, views, functions, procedures, columns and parameters.*
  • OracleIse module*
  • OracleClient module used by OracleIse*
  • Redistributed WPK and ISECreamBasic modules from PowerShellPack and ISECream projects*
  • Created an SQLPSX installer*

* = New features for release 2.2

Credits

My thanks to

  • Steve Murawski for his work creating most of the new GUIs (table/object browsers, saved connections, and output to variable).
  • Bernd Kriszio for his work in adding a slimmed down ISE menu module, IceCreamBasic, all of the Oracle components and his willingness to test and provide feedback to the rest us
  • Max Trinidad put a lot of work into creating an installer for SQLPSX built entirely in PowerShell. Max was very patient in our requests to build several interactions of the installer as we worked through various scenarios.

Next Steps

SQLIse" /> SQLIse" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344">

www.youtube.com/watch?v=8WoZ5aUsNwM

2.2

Comments

Posted by Dukagjin Maloku on 4 June 2010

Thanks for the notice!

Leave a Comment

Please register or log in to leave a comment.