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.

Archives: September 2009

Eliminating Empty Output Files in SSIS

So you’ve got some packages that regularly extract data to one or more text files, but you know that from time to time some of the queries will not return any data.  However, you find in SSIS that, in a flat file export package, the output file is created regardless… Read more

18 comments, 6,176 reads

Posted in Tim Mitchell on 30 September 2009

Space Sensitivity in SSIS Lookups

It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup transformation (a good review can be found here). In a nutshell, a comparison using the lookup transformation is case sensitive when using the default setting of Full Cache, even… Read more

2 comments, 1,278 reads

Posted in Tim Mitchell on 29 September 2009

[Off Topic] Workstation Upgrade

It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest starting school this year, it was time to add another computer to our inventory.  Since my son’s computer needs are relatively minimal at this point, I decided to buy a… Read more

3 comments, 167 reads

Posted in Tim Mitchell on 26 September 2009

More Free Training Resources

A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit the nail on the head with respect to taking charge of one’s own career.  I won’t belabor the point by repeating their words here, but the message… Read more

5 comments, 466 reads

Posted in Tim Mitchell on 21 September 2009

The Netbook: Upgrade to Windows 7

I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment.  Last weekend, I made the leap to Windows 7 RTM.  So far so good!

I was more than a little surprised to find out that there was no upgrade… Read more

1 comments, 205 reads

Posted in Tim Mitchell on 19 September 2009

Upcoming Speaking Engagements for Q4

In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence.  For October, I have the pleasure of presenting for SQL Lunch, a new online learning series pioneered by Patrick LeBlanc.  On October 12th, I’ll be discussing ways to leverage SQL Server… Read more

0 comments, 178 reads

Posted in Tim Mitchell on 18 September 2009

Skipping Items in a Foreach Loop

Recently, my friend Jack Corbett asked a question on Twitter:

In a nutshell, the SSIS foreach loop will enumerate a given list of items (files in a directory, nodes in an XML file, static list of values, etc.) and will perform some operation for each of the items in the… Read more

7 comments, 1,805 reads

Posted in Tim Mitchell on 16 September 2009

North Texas SQL Server User Group Meeting on Thursday

The monthly North Texas SQL Server User Group (NTSSUG) meeting will be held this Thursday, September 17, at 7:00pm at the Microsoft campus in Irving, Texas.  Our guest will be SQL Server MVP and consultant Geoff Hiten, who will be presenting “Bad SQL - Why Does This "Perfectly Good" T-SQL… Read more

0 comments, 252 reads

Posted in Tim Mitchell on 14 September 2009

Getting Into the Biz, Part 3

In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path as a database professional, including some notes from my own journey.  In this final segment, I’ll share a few discrete tips that will hopefully be useful to those… Read more

2 comments, 438 reads

Posted in Tim Mitchell on 14 September 2009

SQL Saturday Dallas Update

Just a quick update on the SQL Saturday event we are planning for the Dallas area next year.  Late last week our local event planning committee met to discuss the big stuff (venue, date, and advertising) and came away with a short but critical action list. 

We’ve got a venue… Read more

4 comments, 222 reads

Posted in Tim Mitchell on 13 September 2009

Updating Existing Data with SSIS

I see a lot of questions on the forums about updating existing data in SSIS.  When the update is dynamic and is based on elements within your data flow, a common mistake is to use the Ole DB Command within the data flow pane:

 

The above poorly designed update… Read more

2 comments, 3,958 reads

Posted in Tim Mitchell on 10 September 2009

SpeakerRate – Need Your Feedback

Everybody loves a compliment.  Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that it’s difficult to get better at what you do without periodic evaluations of your performances.

It’s only been a few years since I committed to start speaking publicly to share… Read more

6 comments, 239 reads

Posted in Tim Mitchell on 8 September 2009

24 Hours of PASS - Recap

At times it felt like a party, it had enough content to be a mini-conference, and we learned that some people get a little punchy after 24 straight hours of SQL Server.  Regardless if you were a presenter, a casual observer, or stayed engaged for the whole event, the 24… Read more

1 comments, 285 reads

Posted in Tim Mitchell on 3 September 2009

Keeping a Low Profile

I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly staying away from the Twitter/LinkedIn/Facebook circles.  We’ve had 3 of 4 family members who have fallen ill in the last week (myself included), and we’ve been prepping for the baby… Read more

3 comments, 185 reads

Posted in Tim Mitchell on 1 September 2009