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.

Why I Want to Have Coffee With You

Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes that he doesn’t have the time or the desire to simply “have coffee”. While I empathize with some of the author’s justifications for his position, I was disappointed… Read more

1 comments, 50 reads

Posted in Tim Mitchell on 31 March 2015

The Idea Book

How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be easy to add automation to [y]”, or “It would be a lot of fun to work on a project to build [z]”? For me, this has happened a lot, and… Read more

1 comments, 106 reads

Posted in Tim Mitchell on 25 March 2015

Fix Inconsistent Line Terminators in SSIS

There is a flat file processing issue I’ve run into a number of times over the years, and it’s come up again several times recently. The issue relates to the line terminators used in data files. Occasionally, changes to the systems generating these data files, or perhaps even manual edits,… Read more

3 comments, 118 reads

Posted in Tim Mitchell on 23 March 2015

Iterating Through Excel Worksheets with Biml

Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in this post by Koen Verbeeck) to addressing multiple worksheets in a single document, configuring SSIS to properly read from or write to Excel documents is tedious at best. While there… Read more

7 comments, 5,166 reads

Posted in Tim Mitchell on 16 March 2015

On Failure: Getting Up

In my continuing series entitled “On Failure”, I want to talk about skiing.

I’m not a great skier. It would probably be a stretch to say that I’m a good skier. Still, I enjoy doing it, and I want to (and can) get better at it. Since I live in… Read more

1 comments, 5,440 reads

Posted in Tim Mitchell on 6 February 2015

Advanced SSIS Training in Dallas

I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and colleague Andy Leonard and I will be delivering this new 3-day course March 9-11, 2015 at the Microsoft offices in Irving, Texas. This course is intended for… Read more

0 comments, 142 reads

Posted in Tim Mitchell on 21 January 2015

On Failure

The first rule of blogging is that you should write about topics you know a lot about. And I know a lot about failure. This post will be the first in a series on the topic, through which I’ll share a few of my own failures and how I’ve done… Read more

8 comments, 133 reads

Posted in Tim Mitchell on 9 January 2015

Six practical tips for social media success in 2015

Social media is the new résumé.  In many ways, it’s even better than a résumé – a person’s social media stream can reveal attitudes, biases, and deficiencies that wouldn’t dare appear on a résumé.  Your online thoughts – blogs, Instagram pictures, tweets on Twitter, posts on Facebook, among others –… Read more

3 comments, 5,113 reads

Posted in Tim Mitchell on 2 January 2015

[OT] Blog is in maintenance mode

I’m spending part of this holiday break repaying some technical debt on my website.  Among other things, I am importing some old content that I never brought over when I did my migration to WordPress a few years ago.  Most of the content I’m bringing over is old (most of… Read more

0 comments, 153 reads

Posted in Tim Mitchell on 21 December 2014

On Perspective

Perspective can make or break a career.  Maintaining a proper perspective is very often the differentiating factor between a good technologist and an incredible one.

In my 15-ish years in IT, I’ve said a lot of dumb things.  Many of them I’ve forgotten, but I can’t shake the memory of… Read more

12 comments, 5,027 reads

Posted in Tim Mitchell on 3 December 2014

SSIS Parent-Child Architecture in Catalog Deployment Mode

This is the third in a series of posts about SSIS parent-child architecture.  You can find the index page here.

In my previous posts on SSIS parent-child package architecture, I described the benefits of the parent-child package design pattern and demonstrated the implementation of such a pattern in package… Read more

0 comments, 5,770 reads

Posted in Tim Mitchell on 1 December 2014

How to burn down your house while frying a turkey

It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my browser.  No, I’m certainly not looking to burn down my house.  In fact, wait here while I clear my search history, just in case.

For the sake of argument, let’s… Read more

4 comments, 184 reads

Posted in Tim Mitchell on 26 November 2014

Join me in DC for a full day of Biml

I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml preconference seminar the day before the upcoming SQL Saturday in Washington, DC.  This seminar, entitled “Getting Started with Biml”, will introduce attendees to the awesomeness of Business… Read more

0 comments, 246 reads

Posted in Tim Mitchell on 11 November 2014

SQL PASS 2014 Summit Diary – Day 6

Today is the last official day of the PASS Summit.  The sessions will wrap up at the end of the day, and we’ll all go our separate ways and resume our semi-normal lives.  Having delivered my presentation yesterday, my official PASS duties are over, and I’m planning to spend the… Read more

1 comments, 272 reads

Posted in Tim Mitchell on 8 November 2014

SQL PASS Summit 2014 Diary – Days 3-5

The last two days have been an absolute blur.  As I first posted this week, I had planned to blog daily about my goings-on, but I’ve been running nonstop – all good things, fortunately – but it interrupted my plans to blog every day.

Day 3: Tuesday

08:00am: Headed back… Read more

1 comments, 283 reads

Posted in Tim Mitchell on 7 November 2014

PASS Summit 2014 Diary – Day 2

It’s another beautiful day in Seattle. And by beautiful, I mean overcast and threatening rain.  Today will be mostly consumed by the MVP Summit, with some fun stuff scheduled for later in the day.  At 6pm today, I’m headed back to the Tap House for BI Over Beers, a… Read more

1 comments, 249 reads

Posted in Tim Mitchell on 4 November 2014

PASS Summit 2014 Diary – Day 1

Today is the first day of official activities for the week.  The PASS Summit hasn’t yet started, but I’ll be spending the day at the MVP Summit, surrounded by a few hundred people much smarter than I am.  The details of the MVP Summit are all covered under NDA, so… Read more

1 comments, 205 reads

Posted in Tim Mitchell on 3 November 2014

PASS Summit 2014 Diary – Day 0

This week, I’m attending two different summit events in the Seattle area.  On Sunday through Tuesday, I’ll be participating in the Microsoft MVP Summit in Bellevue, Washington.  For the remainder of the week, I’ll be attending and presenting at the PASS Summit in Seattle.  Although there is much I won’t… Read more

1 comments, 157 reads

Posted in Tim Mitchell on 2 November 2014

Five people you should meet at the PASS Summit

As I write this, I’m airborne and on my way to Seattle for the summit week (the Microsoft MVP Summit, followed by the PASS Summit).  I was struck with the notion – and not for the first time – that I’m not really looking forward to these events for… Read more

3 comments, 251 reads

Posted in Tim Mitchell on 1 November 2014

It’s That Time Again

“It’s the most wonderful time of the year…”

No, not the end-of-year festival of repetitive music, overeating, and trampling on other people to find that perfect gift.  No, it’s time again for the PASS Summit, the annual gathering of SQL Server and data professionals from around the world.  The… Read more

1 comments, 189 reads

Posted in Tim Mitchell on 31 October 2014

Older posts