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 experience. Tim is the principal of Tyleris Data Solutions and is a Linchpin People teammate. Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. He is a board member at the North Texas SQL Server User Group in the Dallas area. Tim 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 TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

SSIS and PowerPivot training in Baton Rouge

I’m happy to announce that I’ll be teaming up with my Linchpin People colleague Bill Pearson for a day of BI and SSIS training next month.  On Wednesday, February 12th, we’ll each be delivering a full-day presentation in Baton Rouge, after which we’ll be joining the Baton Rouge SQL Server… Read more

0 comments, 230 reads

Posted in Tim Mitchell on 29 January 2014

New Blog Series: Parent-Child Architecture in SSIS

I’m kicking off a new series of blog posts discussing the topic of parent-child architectures in SQL Server Integration Services.  The links to the posts in this series are below.

I still remember the first SSIS package I ever deployed… Read more

8 comments, 322 reads

Posted in Tim Mitchell on 20 January 2014

Goodbye, 2013

For me, 2013 was one of the most interesting and busy years of my life.  It was a good year for me, especially on the career front, and it’s certainly been the busiest year in several years.  Among the highlights of 2013:

Going independent

The most significant event for me… Read more

2 comments, 226 reads

Posted in Tim Mitchell on 1 January 2014

MVP Award for 2014

Earlier this morning I received a notification from the Microsoft MVP program that I’ve been recognized as a SQL Server MVP for 2014.  Even though this is my fifth consecutive award, it’s still a rush to get that email each year.

It’s awesome to be a part of such a… Read more

4 comments, 207 reads

Posted in Tim Mitchell on 1 January 2014

PASS Summit 2013 Keynote, Day 2

Today is the second day of the 2013 SQL PASS Summit, and I’m again live blogging the event. 

8:15: Here we go.  Looks like a thinner crowd today.  Everyone sleeping in from #sqlkaraoke last night?

8:19: The morning is kicked off with a video montage about networking.  It’s good to… Read more

2 comments, 293 reads

Posted in Tim Mitchell on 17 October 2013

PASS Summit 2013 Keynote, Day 1

Today is the first full day of the PASS Summit 2013 conference.  This year I’m again joining the blogger table and will be live blogging throughout the opening ceremonies and the keynote.  This year I’m sitting between Colin Stasiuk and Andy Warren. 

I’ll be updating this post periodically through the… Read more

1 comments, 348 reads

Posted in Tim Mitchell on 16 October 2013

It’s Election Season

It’s that time of the year again – time to make your voice heard as a PASS member.  The PASS board elections are upon us, and if you’ were a PASS member as of June of this year, you should receive your ballot via email tomorrow.  Remember that this year’s… Read more

0 comments, 274 reads

Posted in Tim Mitchell on 25 September 2013

SQL Saturday 223 OKC

This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and speak at the third annual SQL Saturday event there.  I’ve been invited to speak at each of their three events, and I’ve been impressed with each one of them so… Read more

2 comments, 314 reads

Posted in Tim Mitchell on 26 August 2013

My event schedule for Fall 2013

As I was browsing my calendar of upcoming events for the remainder of the summer and the fall, I realized two things:

  1. This will likely be the busiest, most travel-heavy three months I’ve ever had, and
  2. I’m going to have to buy my wife something really nice by the time…

Read more

1 comments, 303 reads

Posted in Tim Mitchell on 16 August 2013

Join me for the 2013 Biml Workshop

Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml.  If you’re not familiar with it, Biml (short for Business Intelligence Markup Language) is a language that allows business intelligence developers to programmatically create and document SSIS packages.  I’ve found this to be incredibly… Read more

0 comments, 767 reads

Posted in Tim Mitchell on 14 August 2013

Continue Package Execution After Error in SSIS

When it comes to ETL, I’m a pessimist.  Until proven otherwise, I assume that all data is bad, all connections are volatile, and all transformation logic is suspect.  As such, I spent a lot of time addressing how to prepare for and handle errors in the ETL pipeline with SSIS.… Read more

10 comments, 892 reads

Posted in Tim Mitchell on 5 August 2013

Are you really an expert?

Through the course of my career, I’ve spent time on both sides of the job interview table, which has given me an empathy for both job interviewees as well as their interviewers.  The former wants to put his best foot forward to demonstrate (or at least talk about) his most… Read more

10 comments, 310 reads

Posted in Tim Mitchell on 2 August 2013

Key Change

I love music.  In fact, I like to think that I’m a student of music – although anyone who has heard me sing karaoke would agree that I’m far from having mastered it.  I’ve got a taste in music that is as diverse as anyone I know.  I enjoy tunes… Read more

10 comments, 385 reads

Posted in Tim Mitchell on 21 June 2013

Upcoming SQL Saturday Precons

I’m happy to announce that I’ll be delivering three, one-day preconference seminars this summer prior to three different SQL Saturday events:

Read more

1 comments, 328 reads

Posted in Tim Mitchell on 7 June 2013

Using the SSIS Object Variable as a Result Set Enumerator

In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services, along with a brief examination of some potential use cases.  In this installment, I’m going to illustrate the most common use of object typed variables in SSIS: using an… Read more

9 comments, 625 reads

Posted in Tim Mitchell on 28 May 2013

Temporary Post Used For Theme Detection (6a375569-f9c1-4835-a7fb-fa1ba0b240e4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Read more

0 comments, 356 reads

Posted in Tim Mitchell on 25 May 2013

Speaking at PASS Summit 2013

I’m happy to announce that I have been selected to present
at the SQL PASS Summit in Charlotte, North Carolina this October.   I’ll be delivering a session entitled “Data Cleansing in SQL Server Integration Services”, in which I’ll cover various ways to detect and cleanse dirty data using tools built… Read more

6 comments, 347 reads

Posted in Tim Mitchell on 22 May 2013

Webinar: Scripting and SSIS

Tomorrow at 10am (11am EDT), I’ll be joining together with my good friend and SSIS Design Patterns coauthor Andy Leonard for a free one hour webinar to discuss scripting in SQL Server Integration Services:

Join SQL Server MVP Tim Mitchell and Andy Leonard as they discuss and demonstrate scripting in…

Read more

0 comments, 344 reads

Posted in Tim Mitchell on 7 May 2013

Colorado speaking tour

I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado next week.  I’ll be speaking at these four user groups:

Monday (3/18): Northern Colorado Database Professionals

Tuesday (3/19): Boulder SQL Server User Group

Wednesday (3/20): Colorado Springs SQL Server User… Read more

0 comments, 415 reads

Posted in Tim Mitchell on 11 March 2013

Business Intelligence Projects now supported in Visual Studio 2012

Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this tool due to the fact that it did not support BI project types (SSIS, SSAS, and SSRS).  Today, that limitation is now gone with the release by Microsoft of SQL… Read more

2 comments, 785 reads

Posted in Tim Mitchell on 6 March 2013

Newer posts

Older posts