≡ Menu

SQLPSX 2.3.1 Release

We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an excerpt from the release notes:

Added PerfCounters Module

The PerfCounters module contributed by Laerte Junior (blog|twitter), is used for working with Windows Performance Counters, collecting and importing into a SQL Server table. Checkout Laerte’s Simple-Talk article, Gathering Perfmon Data with Powershell for good overview of how you can use these functions.

Added SQLProfiler Module

Another contribution by Laerte Junior (blog|twitter), this module is used for reading and writing SQL trace files. Checkout Laerte’s article Fun with SQL Server Profiler trace files and PowerShell for more information.

Modified SQLIse Module

Fixed issues with output formatting of multi-queries and added SQL password encryption for saved connections using SQL authentication.

Modified adolib Module

Fixed issues with SQL authentication on some functions and added enhanced output types.

Credits

My thanks to

  • Bernd Kriszio (blog|twitter) for his continual support and enhancements to SQLIse.
  • Mike Shepard for adding functionality and maintaining his adolib.
  • Laerte Junior (blog|twitter) for contributing two new modules SQLProfiler, PerfCounters as well as his previous work in creating a SQLMaint module (complete PowerShell-based SQL maintenance).

Comments on this entry are closed.

  • Bernd Kriszio December 12, 2010, 12:17 pm

    At daytime I work in a SCRUM team where we deal a lot with text and varchar(max) fields.
    We need to be able to extract the complete unmodified content in a painless way.
    Many of the modifications and enhancements I did to sqlise where influenced by work requirements.
    Now this release of sqlise is matured enough to be used as tool by its own in parallel with SSMS and sqlcmd.
    It fills some gaps where we have no influence on the other tools.

    My special thanks to Chad to let me add this stuff to the project and enhance sqlise this way.

    PS.: Some ORACLE improvements are planned for the next 3 month, but when I get no feedback, the progress is determined by my jobs needs.

%d bloggers like this: