SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2008, Extract, Transform, Load (ETL) Rss

   Items 1 to 4 of 4   

We Loaded 1 Terabyte in 30 Minutes with SSIS, and So Can You

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.  Read more...
Rating:  Rate this |   Briefcase | 7,037 reads

The Data Loading Performance Guide

This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.  Read more...
By Additional Articles 2009/02/24 | Source: MSDN Communities | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,765 reads

CDC and Data Warehouse

The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process  Read more...
By Additional Articles 2008/11/10 | Source: SQL Server Performance | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,670 reads

Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services

SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.  Read more...
Rating:  Rate this |   Briefcase | 3,672 reads
   Items 1 to 4 of 4