Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

Speaking at DevConnections 2016

I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year… Read more

0 comments, 139 reads

Posted in Tim Mitchell on 22 July 2016

Get Your Email Out of my ETL

Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My response: “I don’t.” The tl;dr version of this post is I let my extract-transform-load processes do just ETL, and leave notifications to the scheduling system where they belong. Get Your… Read more

0 comments, 391 reads

Posted in Tim Mitchell on 14 July 2016

ETL Modularity

Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot of work into Thing, and it does exactly what you wanted it to. You put Thing into play as part of a larger solution and, after a couple of revisions,… Read more

1 comments, 1,649 reads

Posted in Tim Mitchell on 11 July 2016

Podcast Interview: Is the On-Premises Data Warehouse Dead?

Recently I’ve been talking a lot with clients and others about the involvement of cloud architecture in a data warehouse design. In fact, this topic was the focus of my most recent Data Geek newsletter publication. A few weeks ago, I had the pleasure of being interviewed by my friend… Read more

5 comments, 818 reads

Posted in Tim Mitchell on 27 June 2016

What if Your Employer Won’t Support Your Career?

I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t say every technical job I’ve had was all unicorns and bacon, I’ve been very fortunate to have been treated fairly and professionally through most of my employment history. Not only… Read more

2 comments, 1,693 reads

Posted in Tim Mitchell on 23 June 2016

Join Me at PASS Summit 2016

It seems like it was just yesterday that we all said goodbye in Seattle at last year’s PASS Summit, but the calendar on the wall says that the next event is a mere four months away. This means that it’s that time of year again: the schedule of sessions has… Read more

0 comments, 113 reads

Posted in Tim Mitchell on 22 June 2016

Bad Data Can Kill

Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business, where estimates of total losses are usually gauged in the hundreds of billions of dollars per year. Nor am I talking about the inconvenience we all face when presented with… Read more

2 comments, 1,651 reads

Posted in Tim Mitchell on 20 May 2016

ETL Data Lineage

Before I began my technical career over a decade and a half ago, I spent several years working in law enforcement. In that field, one of the things one must learn quickly is the concept of the chain of custody of evidence. There were numerous procedures we had to follow… Read more

6 comments, 866 reads

Posted in Tim Mitchell on 6 May 2016

SSIS Training Classes for Summer 2016

If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of the two full-day workshops I have scheduled for August of this year. I’ll be taking my popular course Building Better SSIS Packages on the road to Baton Rouge, Louisiana and… Read more

2 comments, 244 reads

Posted in Tim Mitchell on 5 May 2016

Refocus

Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I partnered with Linchpin People, a guild of independent consultants made up of some of the very best practitioners in the database and business intelligence space. Working with Linchpin helped to… Read more

3 comments, 200 reads

Posted in Tim Mitchell on 4 May 2016

ETL Auditing

It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks to ensure that the operation actually did what it was supposed to do. Sometimes it takes a day, other times it takes a year, but eventually that call comes from… Read more

5 comments, 1,968 reads

Posted in Tim Mitchell on 22 March 2016

ETL Logging

If you were to poll data professionals on which tasks they enjoy working on the most, ETL logging would probably not make the list. However, it is essential to the success of any ETL architecture to establish an appropriate logging strategy. I like to compare a good logging infrastructure to… Read more

4 comments, 1,999 reads

Posted in Tim Mitchell on 14 March 2016

Polishing The Silverware

A few weeks ago I met a couple of my business partners in a moderately upscale restaurant in the Washington, DC area. It was not my typical kind of place – I’m more of a casual dining guy – but I did enjoy the experience and the atmosphere. There wasn’t… Read more

2 comments, 193 reads

Posted in Tim Mitchell on 8 March 2016

Change Tracking for Data Warehouse Loads (Webinar)

For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed, and deleted records means the difference between doing an expensive truncate-and-reload operation versus a smaller, faster incremental load. SQL Server change tracking, a feature first introduced in SQL Server 2008,… Read more

2 comments, 304 reads

Posted in Tim Mitchell on 1 March 2016

Using Custom File Delimiters in SSIS

File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field separator such as comma, tab, or pipe. However, occasionally you’ll get an oddly formatted file with an unusual delimiter. Although it’s not obvious in the Visual Studio designer, SSIS is… Read more

5 comments, 2,314 reads

Posted in Tim Mitchell on 5 February 2016

Using Change Tracking in SSIS

Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I use with change tracking in incremental load scenarios. In this post, I’ll round out the topic by showing how using change tracking in SSIS packages can add more flexibility to… Read more

0 comments, 432 reads

Posted in Tim Mitchell on 22 January 2016

Using SQL Server Change Tracking for Incremental Loads

Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started using this technology for change detection. In this post, I’ll continue what I started by demonstrating how change tracking fits into a larger design pattern for end-to-end incremental load ETL… Read more

3 comments, 1,597 reads

Posted in Tim Mitchell on 20 January 2016

Getting Started with Change Tracking in SQL Server

Change tracking for SQL Server is a flexible and easy-to-use technology for monitoring tables for inserts, updates, and deletes. In this post, I’ll discuss getting started with change tracking in SQL Server, and will show an example of how to get started with it. Change Tracking Overview Change tracking is… Read more

5 comments, 620 reads

Posted in Tim Mitchell on 18 January 2016

New Gear: Lenovo Yoga 900

For several months I’ve been eyeing a replacement for my aging Surface Pro 2. Although I’ve been pretty happy with this tablet PC, it’s got a few limitations – most notably, it doesn’t have enough horsepower to run most of my demos. Because I do a lot of travel and… Read more

4 comments, 2,128 reads

Posted in Tim Mitchell on 6 January 2016

Technical Dogma

Humans are creatures of habit, and I suspect that engineering/technical types are even more so. We find something that works and tend to stick with it, sometimes neglecting to occasionally experiment with new tools or methods. The mantra of “If it ain’t broke, don’t fix it” becomes the defense for… Read more

0 comments, 205 reads

Posted in Tim Mitchell on 4 January 2016

Older posts