Michael DeYoung

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.58 (12)

You rated this post out of 5. Change rating

2008-03-20

5,458 reads

Recently a customer asked how they could get index changes to be captured in...

giltwrights – n. the imaginary committee of elders that keeps a running log of...

Hey folks, fun personal post today. A few weeks ago, I got married! My...

USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...

Comments posted to this topic are about the item Backing Up Master

Comments posted to this topic are about the item Window Function Basics - PARTITION...