Technology Musings
In: SQL Server
4 Dec 2008I’m sure there are more posts like these to come, but I just wanted to get this out there. It’s been a small annoyance of mine that carried over from my MySQL days, but why aren’t there unsigned numerics in SQL Server? Why do I have to waste a whole bit on the sign in [...]
In: SQL Server|SSIS
24 Nov 2008SSIS does not allow an FTP password to be set through Expressions. Fortunately, we can manually set the value stored in a variable through a Script Component.
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.