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.

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

Posted by Jeffrey Yao on 12 December 2010

Thanks Chad and all contributors for this great SQLPSX project, and I am learning Powershell and SMO, and find this SQLPSX is of tremendous value and help to me. I hope I can post my learning experience using SQLPSX in near future(all for my real world problems). Thanks again !

Posted by cmille19 on 12 December 2010

@Jeffrey -- Thanks for the feedback and your kind remarks. I look forward to reading your blog posts.

Leave a Comment

Please register or log in to leave a comment.