Tim_Mitchell.jpg

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, and trainer.  He has worked with SQL Server for over a decade, specializing in business intelligence, ETL/SSIS, data quality, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as aMicrosoft Data Platform MVP.  Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal at Tyleris Data Solutions.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBitsSQL ConnectionsSQL Saturday events, and various user groups and webcasts.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

http://www.timmitchell.net http://feeds.feedburner.com/TimMitchell

In this session, we'll review methods for cleaning up dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native components, T-SQL, SSIS scripting, and DQS.

Blog posts RSS

Speaking at DevConnections 2016 22 Jul 2016
I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year I will present one ...

Get Your Email Out of my ETL 14 Jul 2016
Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My response: “I don’t.” The tl;dr version of this post is I let my extract-transform-load processes do just ETL, and leave notifications to the scheduling system where they belong. Get Your ...

ETL Modularity 11 Jul 2016
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot of work into Thing, and it does exactly what you wanted it to. You put Thing into play as part of a larger solution and, after a couple of revisions, its behavior is verified and it is blessed as ...

Podcast Interview: Is the On-Premises Data Warehouse Dead? 27 Jun 2016
Recently I’ve been talking a lot with clients and others about the involvement of cloud architecture in a data warehouse design. In fact, this topic was the focus of my most recent Data Geek newsletter publication. A few weeks ago, I had the pleasure of being interviewed by my friend Carlos Chacon ...

What if Your Employer Won’t Support Your Career? 23 Jun 2016
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t say every technical job I’ve had was all unicorns and bacon, I’ve been very fortunate to have been treated fairly and professionally through most of my employment history. Not only was I treated ...