Tim Mitchell

Digital Privacy is the Wild West

• by Tim Mitchell

• Tim Mitchell

Who has the legal right to access your personal and private digital assets? The answer can be complex, and will...

2017-02-27 (first published: 2017-02-23)

1,495 reads

Managing Bad Data

• by Tim Mitchell

• Tim Mitchell

In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...

2017-02-21 (first published: 2017-02-16)

2,191 reads

Retrieve a List of Files from FTP using SSIS

• by Tim Mitchell

• Tim Mitchell

The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”...

2017-01-27 (first published: 2017-01-20)

1,498 reads

Upcoming Class: Building Better SSIS Packages in Pensacola

• by Tim Mitchell

• Tim Mitchell

I’ll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class...

2017-01-17

359 reads

Why Data Warehouse Projects Fail

• by Tim Mitchell

• Tim Mitchell

Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...

2017-01-10

1,084 reads

What is ETL?

• by Tim Mitchell

• Tim Mitchell

In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...

2017-01-16 (first published: 2017-01-06)

2,495 reads

The Side Project

• by Tim Mitchell

• Tim Mitchell

When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...

2017-01-11 (first published: 2017-01-04)

1,350 reads

ETL Error Handling

• by Tim Mitchell

• Tim Mitchell

In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...

2016-12-28

759 reads

Survey Results: Skipping the Holidays

• by Tim Mitchell

• Tim Mitchell

Last week I posted a brief survey about working the holiday. To those who normally are not required to work...

2016-12-27

375 reads

Survey: Skipping the Holidays?

• by Tim Mitchell

• Tim Mitchell

For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...

2016-12-23

373 reads