Data

March 20, 2022

What Stephen King Taught Me About Data Storytelling

I’ve been a fan of macabre fiction writer Stephen King since I first picked up The Dark Half sometime in the early 1990s. Since then I’ve read dozens of his books, and I’ve never been disappointed by a single one. However, when I finally got around to reading the two-decades-old book On Writing, I found not only some incredibly helpful…

Let’s Talk About Your Development Environment

My New Favorite Demo Dataset: Dunder Mifflin Data

Where Are Your Data Leaks?

Do You Really Need Real-Time?

The Trails We Leave

Bad Data Can Kill

We Don’t Trust This Data

Dear Vendor: Keep My Information Secure

March 23, 2015

Fix Inconsistent Line Terminators in SSIS

When processing data files using SQL Server Integration Services, it is not uncommon to find files with different end-of-line markers for each line in the file. In this post, I will demonstrate how to fix inconsistent line terminators in SSIS to avoid ETL errors. Fix Inconsistent Line Terminators in SSIS In every text file, there are unprintable characters called line…

1 2 »