Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of data management experience. He is a partner with Linchpin People and is the principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2.

You can visit his website and blog at or follow him on Twitter at

PASS Summit 2015 Keynote – Day 2

Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address. This post will be updated throughout the keynote. Don’t forget you can watch the live stream on PASS TV.

Adam Jorgensen, current EVP of finance (and future president) of… Read more

1 comments, 124 reads

Posted in Tim Mitchell on 29 October 2015

PASS Summit 2015 Keynote – Day 1

Today, I’ll be live blogging the SQL PASS 2015 keynote. Today is the third day of the PASS Summit, and the first day with regular sessions. Everything shown in the keynote will also be streamed on PASS TV.

As a logistical note, I’ll be updating this post throughout the… Read more

1 comments, 149 reads

Posted in Tim Mitchell on 28 October 2015

Kicking the Tires on SSIS 2016

Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services in SQL Server 2016. The current beta of SSIS 2016 has some exciting new features that I think you’ll like. The recording of that webinar is below. Enjoy!

The post… Read more

2 comments, 2,267 reads

Posted in Tim Mitchell on 7 October 2015

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and me in the Washington, DC area for our 4-day Advanced SSIS classroom training course. This course will be held December 7-10 in Reston, VA (just outside of DC). I’ve… Read more

0 comments, 1,553 reads

Posted in Tim Mitchell on 28 September 2015

Webinar: Kicking the Tires on SSIS 2016

The next version of SSIS is on the horizon. Are you ready?

In next Tuesday’s webinar, I’ll be reviewing and demonstrating the new features of SQL Server Integration Services. Microsoft recently released the CTP bits for SQL Server and SQL Server Data Tools, both of which show several useful… Read more

0 comments, 195 reads

Posted in Tim Mitchell on 23 September 2015

Ryan Adams for SQL PASS Board

It’s election season! No, I’m not talking about The Donald, The Clinton, The Neurosurgeon, The Veep, or any of those folks. It’s time for the annual SQL PASS board elections.

If you’re not familiar with the SQL PASS organization, I encourage you to check out what all they have… Read more

4 comments, 170 reads

Posted in Tim Mitchell on 15 September 2015

Webinar: Change Tracking for Data Warehouse Loads

For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing an expensive truncate-and-reload operation versus a smaller, faster incremental load. This is especially important as the volume of information stored in data warehouses continues to grow. SQL Server change tracking,… Read more

0 comments, 168 reads

Posted in Tim Mitchell on 14 September 2015

Building Better SSIS Packages Class in Dallas

I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better SSIS Packages course on Friday, October 2nd at the Microsoft campus in Irving, Texas. This course is a preconference seminar for SQL Saturday Dallas, which will be held in… Read more

0 comments, 1,171 reads

Posted in Tim Mitchell on 8 September 2015

Sixty Days to Summit–Are You Ready?

In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a couple of months away, this is a great time to start making preparations to ensure that you get the most out of your Summit experience.

Download and install… Read more

1 comments, 170 reads

Posted in Tim Mitchell on 28 August 2015

Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero

Rules. Best practices. Guidelines. Design patterns. Policies. All are good and necessary, and you’ll rarely find anyone who will argue against the need to establish boundaries and set expectations. But can adherence to rules and design patterns be taken… Read more

0 comments, 165 reads

Posted in Tim Mitchell on 24 August 2015

We Don’t Trust This Data

“Learning to trust is one of life’s most difficult tasks.” –  Isaac Watts

As data professionals, there are times when our jobs are relatively easy. Back up the databases. Create the dashboard report. Move the data from flat files to the database. Create documentation. There are lots of cogs… Read more

10 comments, 2,437 reads

Posted in Tim Mitchell on 14 August 2015

Downloading SFTP Files with SSIS

If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to download a file stored on an SFTP (secure FTP) server, but SSIS does not natively support this operation. There is a built-in FTP task in SSIS, but it is very… Read more

3 comments, 626 reads

Posted in Tim Mitchell on 3 August 2015

Synchronous Processing in the SSIS Script Component

Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants ETL developers complete control over the flow of data, leverages the full power of the .NET Framework namespaces, and can be used as a source, destination, or transformation in data… Read more

0 comments, 1,632 reads

Posted in Tim Mitchell on 29 July 2015

New Course: Building Better SSIS Packages–Denver and Boston

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 Services… Read more

0 comments, 309 reads

Posted in Tim Mitchell on 5 June 2015

The Key to Successful Analysis

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… Read more

0 comments, 1,766 reads

Posted in Tim Mitchell on 3 June 2015

A Tool for Every Job

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,… Read more

4 comments, 567 reads

Posted in Tim Mitchell on 1 June 2015

Row Numbers and Running Totals in SSIS

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 the… Read more

0 comments, 664 reads

Posted in Tim Mitchell on 26 May 2015

Advanced SSIS Training Class This Fall

Now that the details have been finalized, I can announce that a new SSIS class coming up this fall. My Linchpin People cohort Andy Leonard and I will be delivering our Advanced SSIS training class in the Washington, DC area in December. This class is four days in length, ideally… Read more

0 comments, 233 reads

Posted in Tim Mitchell on 21 May 2015

Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (af8cc091-a628-437f-8918-348486ad1d80 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

The post Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7) appeared first on Tim Mitchell.

Read more

0 comments, 187 reads

Posted in Tim Mitchell on 20 May 2015

How To Get Fired from an ETL Developer Job

Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a lot of ETL code. Some of that code was really good, well-thought-out and carefully executed. Other load processes were – well, let’s just say that they provide plenty of consulting… Read more

6 comments, 1,435 reads

Posted in Tim Mitchell on 15 May 2015

Older posts