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

Chad Miller’s Blog - SQLIse A Powershell Based SQL Server Query Tool

“SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of a Powershell Integrated Scripting Editor (ISE) module called SQLIse (pronounced “SQL Ice”). The module provides a basic IDE for T-SQL that includes the ability to edit, execute, parse and format SQL code from within Powershell ISE.

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

…”

Sounds like a cool way to extend the PowerShell ISE.

[Deleted “You’ll have to take my SQL Query Analyzer from my cold dead fingers”]

LOL  ;)

 

Related Past Post XRef:
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”