Michael Entin's notebook

Michael Entin's notebook

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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.
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (5 items)