Monthly Archives: June 2009

SQLPSX Release 1.6

I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions, 2 cmdlets and 12 scripts for working with SMO, Agent, RMO, SSIS and SQL script files.   Here’s an example … Continue reading

Posted in PowerShell

Powershell + SMO Error Handling Tips

Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO coded in any other .NET language. SMO uses an error object’s InnerException which can be several layers deep and you … Continue reading

Posted in PowerShell

Adventures in Powershell SSIS Administration Programming

In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with SQL Server Integration Services (SSIS). This post describes the functionality included in the script library including enumerating msdb package stores, … Continue reading

Posted in PowerShell

Creating Red Gate SQL Compare Snapshots with Powershell

Co-worker and fellow DBA,, John O’Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out John’s blog post here.  

Posted in PowerShell

Give Me a Coconut and Six Months

Tim Benninghof tagged me with the question.   "So You’re On A Deserted Island With WiFi and you’re still on the clock at work. Okay, so not a very good situational exercise here, but let’s roll with it; we’ll call … Continue reading

Posted in PowerShell

SQLServerCentral Article on Backup Monitoring and Reporting

The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of the solution:   Powershell is used to collect backup information from a list of SQL Servers which is loaded into a consolidated … Continue reading

Posted in PowerShell

Gettting and Setting SQL Data

Many of the Powershell scripts I write either retrieve data from SQL Server or execute a nonquery i.e. delete, insert, update against SQL Server. I find myself reusing a couple of simple functions often enough that posted Get-SqlData and Set-SqlData functions to poshcode … Continue reading

Posted in PowerShell