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.
Open source applications have a natural inclination to be compiled for multiple operating systems. Although many OS‘s and tools are converging in functionality, it’s nice to have a homogeneous environment of favorite programs to make the transition from machine to machine more seamless. I use Windows and work and Linux at home, but that doesn’t mean I have to give up anything in the process. Below are – in no particular order – some of my favorite cross-platform open source applications.
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.