Technology Musings
In: SQL Server
5 Jan 2009Unfortunately, setting up a linked server to Oracle is not as easy as it should be. In fact, you’ll have to install some software on your server to make things work. I’ve put together a short guide on connecting to Oracle from SQL Server.
In: SQL Server
5 Jan 2009SQL Server provides a great notification system for alerts and jobs. There are many options to be set and multiple dialog boxes to step through, but once finished, you’ll always be the first to know when a problem is immanent. Below is a detailed reference to get this running on a new server.
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.