Author: paschott
Powershell – Quite note on Objects
I’m sure this comes as no surprise to anyone who’s dabbled in Powershell, but just about everything in Powershell has an Object underneath. The results…
Powershell – Piping
One of the most often-used features I’ve seen so far in Powershell has been the concept of piping the results of commands into other commands…
Powershell – Arrays & Hash Tables
I don’t have too much to say about Arrays at this point, but as I’m partly blogging this for my own education, I’ll put down…
Powershell – Variables
I’ve just started to play around with variables in Powershell. I used them a little bit before this, but am in the process of figuring…
Powershell – Modules and Profiles
Probably not technically correct, but pretty close. I’ve been trying to use SQLPSX for Powershell, recently updated to v2.0. For the longest time, I’ve tried…
Getting Started with Powershell
I’m in the process of learning PowerShell. This seems to be the first scripting language that we can use at the server/desktop level that has…
Learning to work around DB Pro
I’ve been trying to get a multi-database solution working correctly with MS Visual Studio Team System for Database Professionals (aka DBPro or DataDude). Anyone who…
SSIS and XML Output
I was pretty surprised by this and am in pretty good company. SSIS 2005 and 2008 do not have an XML Destination adapter. We have…
Data Loads
One of the things I really like about SQL Server Integration Services is that it can load large data sets quickly, especially if you need…
Getting Started
Well, I was inspired by Steve Jones (of SQL Server Central fame) to start a professional blog, if only to record some of my thoughts…