SQLIse v2.2 gets some added flavor – Now with OracleIse, Tab expansion, updated installer and more…

Sev17 (Chad Miller) - 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* [GD: Emphasis added to help my poor old eyes see all the v2.2 coolness]

* = New features for release 2.2

…”

A cool project gets cooler…

 

Related Past Post XRef:
Making your PowerShell ISE cool with SQL Ice – SQLIse now available as part of the SQL Server PowerShell Extensions (SQLPSX) v2.1 release

SQLPSX v2 – PowerShell for SQL Server has been PowerShell 2’ed
PowerShell for SQL Server 2000+ - Chad Miller’s SQL Server PowerShell Extensions v1.5 released, with 104 functions, 2 cmdlets and 12 scripts

PowerShell is all about enabling you. Even the PowerShell Integrated Scripting Environment (ISE) can be extended (via PowerShell of course)
Straight from the Windows 7 Resource Kit, PowerShellPack Released - 1.97 billion… (okay 600+, but that’s still allot) of PowerShell scripts to help you “think PowerShell”