Slipstream

Writing the Backwash with R. H. Sheldon

Windows IT Pro

5 Tips for Developing SQL Server Integration Services PackagesSQL Server Pro, February 2012.

Protect Your PowerShell Scripts: Three precautions is all it takesWindows IT Pro, December 2009.

Save Your PowerShell Code in Profile and Script Files: The final lesson in the PowerShell 201 series explores how to make PowerShell code last for more than just one sessionWindows IT Pro, June 2009.

Create Your Own PowerShell Functions Lesson 5 in the PowerShell 201 series explores how to create, call, and use functionsWindows IT Pro, May 2009.

Working with PowerShell’s Data Types: Lesson 4 in the PowerShell 201 series explores how to work with strings, arrays, and other types of dataWindows IT Pro, March 2009.

Accessing SQL Server Data from PowerShell, Part 2: Use ADO.NET to insert, update, and delete data” Windows IT Pro online, December 16, 2008.

Test for Numerous Conditions with PowerShell’s switch Statement: Lesson 3 in the PowerShell 201 series explores how and when to use the switch statement and its componentsWindows IT Pro, December 2008.

Accessing SQL Server Data from PowerShell, Part 1: Leverage the .NET object model” Windows IT Pro online, November 13, 2008.

Integrate MySQL and SQL Server: Use SSIS to retrieve data from a MySQL database and insert it into SQL Server tablesSQL Server Magazine, November 2008.

Controlling Your Code’s Flow with PowerShell’s Conditional Statements: Lesson 2 in the PowerShell 201 series explores how to use the if, for, and while statementsWindows IT Pro, November 2008.

Iterating Through Collections with PowerShell’s foreach Loops: Lesson 1 in the PowerShell 201 series explores how to use the foreach statement and ForEach-Object cmdletWindows IT Pro, October 2008.

Access Security Event Logs with PowerShell: Retrieve, sort, and specify details about events” Windows IT Pro online, September 19, 2008.

Data Manipulation with ADO” Windows IT Pro online, September 5, 2008.

PowerShell 101, Lesson 6: How to work with PowerShell’s built-in drives and create new drivesWindows IT Pro, July 2008.

Accessing Database Data with ADO” Windows IT Pro online, June 6, 2008.

PowerShell 101, Lesson 5: How to access, create, and use variablesWindows IT Pro, June 2008.

Introduction to ADO Use ADO within VBScript to access various data sources” Windows IT Pro online, May 14, 2008.

PowerShell 101, Lesson 4: How to properly use quotes when working with stringsWindows IT Pro, May 2008.

PowerShell Makes Security Log Access Easy: Use the PowerShell command line to retrieve system intrusion, account modification, and policy manipulation information from the Security event log” Windows IT Pro online, April 10, 2008.

PowerShell 101, Lesson 3: How to use PowerShell’s operators and wildcardsWindows IT Pro, April 2008.

PowerShell 101, Lesson 2: How to create pipelines and manage outputWindows IT Pro, March 2008.

PowerShell 101, Lesson 1: How to Get what you need to create basic PowerShell commandsWindows IT Pro, February 2008.

PowerShell One-Liners for Managing Events” Windows IT Pro online, October 2007.

PowerShell One-Liners for Accessing WMI” Windows IT Pro online, August 2007.

PowerShell One-Liners for Managing the File System” Windows IT Pro online, August 2007.

Migrating to PowerShell? Don’t Scrap Your Existing Code Just Yet” Windows IT Pro online, July 2007.

Dig Out By Digging Into PowerShellWindows IT Pro, July 2007.

Scripting Data Flow in SQL Server Integration Services” February 2007.

Scripting Control Flow in SQL Server Integration Services” January 2007.