Monthly Archives: February 2009

Disk Alignment Partitioning: The Good, the Bad, the OK and the Not So Ugly

Lately I’ve been reading about the disk alignment partitioning and performance degragaton that occurs in Windows 2003 when using the wrong partition NTFS partition offset. There is an I/O performance impact of 30 – 40% when disk partitions are not properly aligned. … Continue reading

Posted in PowerShell | 7 Comments

Automating MOM 2000/2005 Report Generation

Every month I go through a  capacity planning exercise looking at things like processor, memory, storage and backup success rates. As part of the review I’ll run two simple Microsoft Operations Manager 2005 SQL Server Reporting Services reports for the … Continue reading

Posted in PowerShell

Windows PowerShell Virtual User Group Meeting #9

Presentation and code examples from Windows PowerShell Virtual User Group Meeting #9 presentation on the CodePlex project SQL Server Powershell Extensions from Feb 18th, 2009 are available here.   My thanks to Marco Shaw for inviting me to present at the user … Continue reading

Posted in PowerShell | 1 Comment

Check for Windows Server 2003 Scalable Networking Pack

I’ve previously blogged about the issues with Windows Server 2003 Scalable Networking Pack included in Windows 2003 Service Pack 2. I keep finding servers in my environment with the feature enabled, so I created a short Powershell script to check … Continue reading

Posted in SQL Server

South East Michigan SQL Server Users Group Presentation

Presentation and scripts for the SEMSSUG presentation on Using RSS for System Administration are available here. This is a repeat of the session I gave at SQL Saturday Tampa.   **Update, the Live Meeting was recorded and is available for viewing/download here.

Posted in RSS

Using OLEDB with SharePoint Lists

I noticed the folks at provide an example connection string which uses OleDb to connect to a SharePoint list. Being a database person, the idea of querying a SharePoiint list like a table sounded interesting, so I set out … Continue reading

Posted in PowerShell | 8 Comments

Execute SQL Server Integration Services (SSIS) Package from Powershell

***Updated 2/23/2009. After some additional testing I discovered you cannot change the location of SSISConfig without saving and reloading a package or exporting and importing a configuration, so I removed the functionality to reset the config location since there isn’t … Continue reading

Posted in PowerShell | 9 Comments