Technology Musings
In: SQL Server|SSIS
12 Nov 2008SSIS breaks when processing embedded text qualifiers in flat file sources. Tutorial on how to configure a script component to manually split on delimiters.
In: SQL Server
4 Nov 2008Unlike my last post on the issue, instead of simply pointing to another blog for instructions on how to query Active Directory from SQL Server, I’ll provide some useful tips on getting things all working.
In: Windows
31 Oct 2008Explanation on how to use PowerShell to automate generating a build file. Code and walkthrough included.
In: SQL Server
28 Oct 2008Tutorial on how to test and verify account permissions with impersonation in SQL Server.
In: SQL Server
23 Oct 2008T-SQL functions for converting between Gregorian and Julian dates.