SQLPSX 2.3.2.1 Release

We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s...

T-SQL Tuesday #15 Automation and the SSIS Dumper

This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter).

In my previous post...

Importing and Exporting SSIS Packages Using PowerShell

SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...

Tampa IT Camp Saturday

The first annual Tampa IT Camp will be held on Saturday, March 19th 2011.

What’s an IT Camp?
In the...

SQL Saturday #62

I presented a one hour session at SQL Saturday #62 in Tampa on SQL Server PowerShell Extensions (SQLPSX): “In this...

Making an Operations Manager Module

Operations Manager 2007 R2 ships with Operations Manager Shell which is simply a provider with associated cmdlets for working with...

Windows Cluster Scripting with WMI and PowerShell

Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:
Only works on...

PBM and PowerShell

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...

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...

What’s Going on with SQL Server Service Account Changes?

For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...