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
2008-11-10
3,814 reads
Extract, Transform, Load (ETL)
SSIS and Excel 2007
Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.
2008-10-24
15,578 reads
Implementing Change Data Capture in Microsoft® SQL Server 2008
Change Data Capture is a new feature of SQL Server 2008 that can help you better handle your ETL systems. New author Suresh Yaram brings us an introduction to CDC and how it can be setup in your environment.
2008-10-23
9,639 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.
2008-09-19
3,818 reads
Kimball ETL Part 1 – Data Profiling via SSIS Data Flow
A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process.
2008-07-23
9,471 reads
How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005
This article provides a step by step guide on how to export data to Microsoft Office Excel 2007
2008-07-04
8,937 reads
ETL for Free-Form Data
This article demonstrates how to extract, transform and load free-form data into a structured form like a staging table by way of XML conversions.
2008-03-20
5,391 reads
Simple Method for Importing Ragged files
This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.
2008-03-05
8,465 reads
Anatomy of an Incremental Load
Microsoft MVP Andy Leonard brings us a great introduction to a common task for all DBAs: importing data. (from Feb 2008)
2009-08-14 (first published: 2008-02-11)
34,266 reads
Identify Unique Columns
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
2,496 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers