Archive for the ‘SQL Server’ Category

Unfortunately, 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.

SQL 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.

I’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 [...]

SSIS 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.

SSIS breaks when processing embedded text qualifiers in flat file sources. Tutorial on how to configure a script component to manually split on delimiters.


  • shiva ramani: good instruction. How to push data to MySQL from SQL 2005 [...]
  • Winkey: I've created a linked server for mysql successfully, and also can do Insert, Select. But when I try [...]
  • RaghuRam: Thanks a lot buddy it helped me to change the root password when I got the error trying to c [...]
  • Taylor Gerring: If you're on a 64-bit OS, did you run the 32-bit version of ODBC applet? Run: odbcad32 [...]
  • Taylor Gerring: If the issue is the guest sync'ing to the host, can't you just force time sync the host if you can't [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.