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

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Reversing a String in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reversing a String in Python

Group By and JOIN within SQL Server (when dealing with multiple columns)

By lynhudson1

I have 2 tables, df1, and df2. I would like to join the two...

Select "New Customer"

By gjoelson 29755

Hi , Has anyone tried to do this...I'm trying to select only "new customers"...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers