Technology Musings
In: SQL Server
25 Feb 2009An illustrated, step-by-step guide for connecting MySQL and SQL Server via Linked Servers utilizing the MySQL ODBC Connector driver.
In: SQL Server
17 Feb 2009The DATETIME data type is often misunderstood and used inefficiently, forcing table scans with YEAR or MONTH functions. With the proper knowledge and tools, developers can more efficiently leverage the DATETIME data type and speed up slow-running queries.
In: SQL Server|SSIS
3 Feb 2009Just a quick note advising that I’ve updated my Handling Embedded Text Qualifiers post to also include a Visual Basic example, making the information also relevant to SQL Server 2005.
In: SQL Server|SSIS
26 Jan 2009Import the XML dump of Wikipedia data into SQL Server through SSIS. Full walkthrough with pictures and pre-configured SSIS package provided.
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.