ETL (Extract Transform and Load)

How to get ETL Horribly Wrong

  • Article

ETL ( Extract, transform, load) doesn't have to be like a spell on hell. To make a success of ETL systems, you need the freedom and ability to make graceful U-turns when you detect a mistake in architecture or configuration: to fix the root problem rather than to merely tackle the symptoms. Feodor lists the eight most common root causes of failure in ETL systems, and how to fix them.

2015-01-30

13,243 reads

The ETL from Hell - Diagnosing Batch System Performance Issues

  • Article

Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start to extend beyond their allotted time, and tuning no longer solves the problem, it is often discovered that batches are run in series, with draconian error handling. It is time to impose some rational design, and Nigel is a seasoned healer of batch processes.

2013-10-30

3,753 reads

Blogs

Azure Database for PostgreSQL

By

Having worked with Azure SQL Database and its many flavours for couple of years...

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

Read the latest Blogs

Forums

Error on executing rename statement

By VSSGeorge

Error on executing rename statement in a table. Not able to debug this. Please...

In-memory database

By LLSQL42

Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database,...

Replication CDC -- Cannot Truncate Table

By GonnaCatchIT

Dear All, We just enabled Replication services (CDC) on few of the databases. Now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers