links for 2009-10-08
October 8, 2009
Free Book Download – How to Think Like a Computer Scientist, The Little Book of Semaphores, and more.
This post will discuss some of the issues that NULL values cause inside SQL Server Integration Services when you're not proactively handling them. The typical indication of a rampant NULL is the dreaded DTS_E_INDUCEDTRANSFORMFAILUREONERROR message.
In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?
A multi-part series on Developing a Control Flow Task for SQL Server Integration Services