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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
“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
Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server 2012, and SSDT-BI. The installation of these pieces went as expected, and everything appeared to work well – until I attempted to execute an SSIS package on this new… Read more
I think back to 15 years ago, when I was working retail and… Read more