Archive for the ‘SQL Server’ Category

Page 3 of 612345...Last »

HOWTO: Setup SQL Server Linked Server to MySQL

In: SQL Server

25 Feb 2009

An illustrated, step-by-step guide for connecting MySQL and SQL Server via Linked Servers utilizing the MySQL ODBC Connector driver.

Efficiently query the DATE in DATETIME

In: SQL Server

17 Feb 2009

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

Handling Embedded Text Qualifiers in SSIS 2005

In: SQL Server|SSIS

3 Feb 2009

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

Import Wikipedia articles into SQL Server with SSIS

In: SQL Server|SSIS

26 Jan 2009

Import the XML dump of Wikipedia data into SQL Server through SSIS. Full walkthrough with pictures and pre-configured SSIS package provided.

Connecting to Oracle from SQL Server

In: SQL Server

5 Jan 2009

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.


Page 3 of 612345...Last »

@TaylorGerring


Unless specified otherwise, this website is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.
Stop SOPA
Unless specified otherwise, this website is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.