Welcome to MSDN Blogs Sign in | Join | Help

January 2008 - Posts

Tuesday, January 22, 2008 5:44 PM

Memory Dump - Sample

In my last post I mentioned the enhanced memory dumping we've added to SQL Server 2008. Along with the dump file, we create a text file that has additional information that will help in debugging the issue. I thought I'd include a sample of it, here.
Posted by mmasson | 1 Comments
Filed under:
Tuesday, January 22, 2008 5:03 PM

What's new in SQL Server 2008 for SSIS - Part two

Change Data Capture (CDC) While not a direct SSIS feature, the new Change Data Capture functionality in 2008 can be taken advantage of in SSIS to do incremental loads. CDC captures changes to SQL Server tables (inserts, updates, deletes), and makes them
Posted by mmasson | 4 Comments
Filed under: ,
Monday, January 21, 2008 4:56 PM

What content do you want to see here?

There are a lot of SSIS blogs out there, and I don't like being redundant. I'm hoping to find more time to blog, which got me thinking about what I should be writing about. What type of information would you most like to see posted here? Details about
Posted by mmasson | 8 Comments
Thursday, January 10, 2008 5:04 PM

What's new in SQL Server 2008 for SSIS - Part one

Improved Scripting SQL Server 2008 (Katmai) introduces VSTA as our new scripting engine, which replaces the old VSA engine used in SQL Server 2005 (Yukon). There are a number of advantages to the new engine, but I think the feature users are most excited
Posted by mmasson | 12 Comments
Filed under: ,
Tuesday, January 08, 2008 9:01 AM

No more implicit lookup cache sharing in Katmai

The November CTP for SQL Server 2008 introduced our new Lookup Transform. 2005 packages with lookup components will upgrade automatically when opened/run in 2008, and should function the same as they did in 2005 with one minor caveat. In certain scenarios,
Posted by mmasson | 4 Comments
 
Page view tracker