Technology Musings
Using the MySQL ADO.NET provider, SQL Server Integration Services can natively query MySQL databases, providing an easy method to transfer data between systems.
Use a CTE to recursively roll up all descendant records into separate groups, regardless of level. Example data and Common Table Expression code included.
In: Windows
14 Apr 2009A highly flexible way to ensure programs are started under the correct conditions, in the proper sequence, with timed delay.
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.