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.

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, 291 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, 359 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, 318 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

4 comments, 583 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, 343 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, 337 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, 329 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, 405 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, 766 reads

Posted in Tim Mitchell on 6 March 2013

Using Object Typed Variables in SSIS

Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration Services.

When defining variables in SSIS, the ETL developer has several data type options to choose from depending on the information to be stored in each variable.  Included in the… Read more

0 comments, 885 reads

Posted in Tim Mitchell on 4 March 2013

Dust Off That Resume

Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional development sessions by Andy Warren, Buck Woody, Don Gabor, and others.  Each one offered different bits of advice based on his or her own experience, but there… Read more

0 comments, 1,925 reads

Posted in Tim Mitchell on 28 February 2013

Erin Welker joins Artis Consulting

Earlier this week, my employer, Artis Consulting, welcomed a new addition to our team.  Technical expert Erin Welker (b|t), a very well known and experienced business intelligence professional, has joined the BI practice here at Artis.  Erin brings a great deal to the table –… Read more

1 comments, 324 reads

Posted in Tim Mitchell on 8 February 2013

Fish and Chips, Robin Hood, SSIS, and Me

I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk about SSIS.  How’s that for tying seemingly unrelated topics together?

I’m happy to report that in addition to my full-day preconference seminar at SQLBits, I’ll also be delivering a… Read more

1 comments, 485 reads

Posted in Tim Mitchell on 30 January 2013

Join me at SQLBits for a day of SSIS

I’m happy to announce that I’ve been selected to deliver a full day of training at the upcoming SQLBits conference in Nottingham, England.  This will be my first time taking part in SQLBits (in fact, it will be my first trip to the U.K.) and I’m very much looking forward… Read more

6 comments, 368 reads

Posted in Tim Mitchell on 15 January 2013

Want to see me break SSIS this Thursday?

OK, I’m not really going to break it.  I’m just going to beat it up a little bit.

This Thursday evening, I’ll be working my home turf at the North Texas SQL Server User Group monthly meeting, presenting “When ETL Goes Bad: Handling Errors and Anomalies in SSIS” at 6:15… Read more

0 comments, 376 reads

Posted in Tim Mitchell on 15 January 2013

Ragged Flat File Processing in SSIS

Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of which is shown below.  In this small sample file, you can see that we are dealing with medical data that has an inconsistent format.  As shown, the rows in the… Read more

7 comments, 749 reads

Posted in Tim Mitchell on 15 January 2013

2012 in Review

With the year 2012 now in the rear view mirror, and while I’m still in the midst of my holiday vacation (two whole weeks! Feels very strange…) , I thought I’d take stock of my tasks and accomplishments of the past year.

Sharing knowledge

I must sound like a broken… Read more

0 comments, 420 reads

Posted in Tim Mitchell on 4 January 2013

I Need Your Vote!

Do your civic duty, and vote today! 

Voting is now open for SQLBits, to be held in Nottingham, UK this May.  This event is probably the best-known SQL Server event outside of the US, and unlike most other such events, they use a popular-vote model for general session selection.  I’ve… Read more

0 comments, 709 reads

Posted in Tim Mitchell on 3 January 2013

The Great Blog Move of 2013

For at least a year, I’ve been considering changing blog platforms.  I set up my blog on TimMitchell.net using BlogEngine.NET several years back, a decision I made based primarily on the fact that this tool was built on ASP.NET and SQL Server as opposed to the LAMP platform used by… Read more

2 comments, 478 reads

Posted in Tim Mitchell on 3 January 2013

Re-awarded MVP status for 2013

I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this distinction.

As always, I am grateful to my friends at Microsoft, the MVP program in particular, as well as my many friends and acquaintances in the SQL Server community.  It’s… Read more

4 comments, 249 reads

Posted in Tim Mitchell on 1 January 2013

Newer posts

Older posts