To Script or Not To Script

When approaching an automation problem the first questions you must answer is whether you should even invest the time to...

Restore and Relocate Database Files Using PowerShell

I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...

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

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