SQL 2008 & VS 2008

Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and RS) live in Visual Studio 2005. So don’t try to open a solution that contains IS project in VS 2008 yet. What about final SQL 2008 – now that Visual Studio 2008 is released – what are the plans for BIDS…


SQL 2008 November CTP is available

Get it from https://connect.microsoft.com/SQLServer One of the improvements in this build is the ability to persist Lookup reference data and use non-OLEDB sources for Lookup.


Custom transforms: determining end of rowset

With SQL 2008 CTPs starting to get into the hands of customers and ISVs, we’ve found that some custom transforms and script transforms use incorrect code to check for the end of rowset (incoming data), which could cause problems when you move the code to SQL 2008. Unfortunately, some Microsoft docs helped to spead this…


SSIS Backpressure Mechanism

One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back pressure”. Let’s consider a simple package with a source and destination. What happens if the source is fast and destination is slow? Say source is huge local raw file and destination is a remote relational database. If we read…


Katmai SSIS data flow task improvements

With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and scalability improvements in this release. I’ll assume readers are familiar with SSIS data flow performance concepts, if not make sure you’ve read these two articles:http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspxhttp://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/ The most important concepts for today are:Asynchronous components – components that…