Author Archive
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 various methods to import the modules and couldn’t get them to import
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 some serious backing from Microsoft. I remember VBScript, CScript, Batch files, and
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 has tried to tie multiple co-dependent databases together within DB Pro has
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 another “opportunity” from Microsoft to work out a way to export XML
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 to look up values along the way. However, there are times that
Getting Started
Posted by paschott in SQL Server On September 16, 2009
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 and experiences. I’ll be writing semi-regularly on SQL Server T-SQL, SSIS, Reports,