Douglas Laudenschlager

See all the new SSIS articles, videos, & samples from Microsoft

Have you seen all the recent articles, videos, & samples for Integration Services? In the future, we hope to offer you an RSS feed for this purpose, but we're not there yet. For now, I hope that you find this list useful, especially since it was...

Published Tue, Nov 18 2008 3:16 PM by dougbert

Filed under: sample, videos, article

Your vote on Microsoft Connect influenced SQL Server 2008 Service Pack 1

Your vote counts on Microsoft Connect! The SQL Server product team looked closely at Connect bugs from our customers to plan the fixes that will be included in SQL Server 2008 Service Pack 1. After setting aside feature requests (DCRs), they started at...

Published Fri, Nov 14 2008 4:22 PM by dougbert

Filed under: Connect

Add logging to the Data Profiling Task

Yesterday I was on a call where we looked at a few usability requests for the Data Profiling Task that didn't make it into RTM. One such request was task-specific logging. Surprise! The attentive developer at Microsoft Research had added it at the...

Published Tue, Nov 11 2008 3:27 PM by dougbert

Filed under: data profiling task

Learn more about using Change Data Capture (CDC) in SSIS 2008

SQL Server 2008 Enterprise includes the new Change Data Capture feature, or CDC, largely intended for use by ETL developers performing incremental loads of a data warehouse. With CDC, you can easily identify rows that have been inserted, updated, or deleted...

Published Mon, Nov 10 2008 5:11 PM by dougbert

Filed under: cdc, change data capture

InfoWorld praises Lookup caching, CDC in SSIS 2008

Read what Sean McCown of InfoWord says about the benefits of Lookup caching and Change Data Capture for the enterprise. "Microsoft has taken some big steps to ensure that SSIS (SQL Server Integration Services) can compete directly with competitors...

Published Wed, Nov 05 2008 11:03 by dougbert

Filed under: lookup, cdc

Check out the new Integration Services portal page on MSDN

When you visit the Integration Services page on MSDN or TechNet, you now get fresh and useful links that include community content, rather than a stale set of links to Books Online topics. Here on the Integration Services team, we're happy to be the...

Published Mon, Nov 03 2008 5:31 PM by dougbert

Filed under: portal, msdn

ETL in the cloud, or just for the cloud?

Lots of comments today about PDC and the Microsoft executives discussing Windows Azure, the new platform for cloud computing. "Everyone" - that is, Matthew Roche and Jamie Thomson - noticed (without even being present!) the "ETL" on...

Published Mon, Oct 27 2008 2:48 PM by dougbert

Filed under: sample, cloud

Didn't make it to the recent Microsoft BI Conference?

Well, you saved a ton of money, but missed a lot of fascinating presentations. Each hour brought another panicked decision over which talk to choose, from the several available tracks. (Except when Donald Farmer's title promised to make me "cool...

Published Tue, Oct 21 2008 4:33 PM by dougbert

Filed under: article

MSDN publishes first 2 articles by Integration Services product vendors

MSDN/TechNet has just published 2 new articles by third-party vendors of commercial products that work with, or complement, SQL Server Integration Services. In Extending Integration Services with the Script Task and Script Task Plus , Ivan Peev of CozyRoc...

Published Tue, Oct 21 2008 4:14 PM by dougbert

Filed under: article, vendor

Connectors now available for SAP BI, Oracle, and Teradata

Both of the promised post-RTM packages of connectors for use with SQL Server 2008 Enterprise and Developer are now available for download, since last Friday's release of the October Feature Pack that contains the SAP BI connector. Each set consists...

Published Tue, Oct 21 2008 4:03 PM by dougbert

Filed under: SAP, teradata, connectivity, oracle, download

New 10-minute how-to videos on Integration Services

The Integration Services documentation team at Microsoft recently published its very first batch of 10-minute how-to videos. We hope that beginning to intermediate users will find these useful, and we're pleased to be taking some first steps beyond...

Published Thu, Oct 16 2008 11:30 by dougbert

Filed under: data mining, videos, Analysis Services

Setting an expression dynamically

Former Integration Services developer Michael Entin recently responded to an interesting question on the internal SSIS discussion list at Microsoft. The user was asking: How can I assign the expression [in this case, for the Derived Column transformation...

Published Sat, Oct 11 2008 4:53 PM by dougbert

The first Integration Services 2008 book is now available

http://www.amazon.com/gp/product/0470247959/ Professional Microsoft SQL Server 2008 Integration Services by SQL Server MVPs Brian Knight and Erik Veerman, our own broadly smiling Grant Dickinson, and industry experts Douglas Hinson and Darren Herbold...

Published Thu, Oct 09 2008 3:53 PM by dougbert

Filed under: 2008, books

New "social bookmarking" features on MSDN & TechNet

I thought you might want to take a look at this blog posting - Launched: Social Bookmarking V1 on MSDN and TechNet - although I haven't had the leisure to explore it yet myself. The stated goal is: " These new sites, which have been available...

Published Wed, Sep 10 2008 10:47 by dougbert

New MSDN articles on Integration Services deployment and performance

The Microsoft MVPs and consultants who spend every day implementing real-world solutions with SQL Server Integration Services gain a wealth of practical knowledge that even the development team can't match. So we're very pleased to announce a...

Published Wed, Sep 03 2008 10:41 by dougbert

Filed under: mvp, performance, deployment

Go directly to . . .

Blog Search Form

Syndication

Tags

Archives