Tim_Mitchell.jpg

Tim Mitchell

Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer.  He has been working with SQL Server for over 10 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting.  He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP.  Tim is an independent business intelligence consultant and a group principal with Linchpin People.

As an active member of the community, Tim has spoken at national, regional, and local venues including the SQL PASS summit, SQL Connections, numerous SQL Saturday events, and various user groups and PASS virtual chapters.  He is active in the North Texas SQL Server User Group in Dallas, and is a volunteer for PASS.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com.

Tim is a contributing author on the charity book project MVP Deep Dives 2, and is coauthor of SSIS Design Patterns.

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

New Course: Building Better SSIS Packages–Denver and Boston 05 Jun 2015
Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQL Saturday events this fall. I’ve got a brand new course entitled “Building Better SSIS Packages” which I’ll be delivering in Denver and Boston. Here’s a brief into to this course: SQL Server Integration ...

The Key to Successful Analysis 03 Jun 2015
The key to successful analysis is to ask enough good questions. How do you know that you’ve asked enough questions? When you think you have all the information you need to get started, ask 10 more good questions. Those ten questions will lead to five more, which will lead to 3 more, and so on. ...

A Tool for Every Job 01 Jun 2015
I’m a fixer. A tinkerer. As a kid, I would take my toys apart just to see how they worked, and to prove that I could put them back together again (and these experiments often had mixed results). Even today, I’m still kind of a shade tree handyman. In fact, earlier this week I had to fix a broken ...

Row Numbers and Running Totals in SSIS 26 May 2015
During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL process itself, as well as for use in the destination database. Having an arbitrary, incrementing row number assigned to each row can help to determine the order in which ...

Advanced SSIS Training Classes This Fall 21 May 2015
Now that the details have been finalized, I can announce that two new SSIS classes are coming up this fall. My Linchpin People cohort Andy Leonard and I will be delivering our Advanced SSIS training class in two new locations later this year: in the Atlanta area in September, and in the Washington, ...