Tim Mitchell
Follow Tim Mitchell on Twitter  Like Tim Mitchell on Facebook  Subscribe on YouTube  Connect on LinkedIn  Subscribe to the Data Geek Newsletter
No Picture

SMO Videos on JumpstartTV.com

Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the guys at End to End Training.  They have relaunched JumpStartTV.com and I was out there to record some brief training videos on SQL Server SMO programming.  Check out the SMO channel here.  Also, Brian Knight and Grant Fritchey have both posted recent content on the same site, and I encourage…


No Picture

Data Quality: The Discovery

I wrote a post a few months back about a healthcare data conversion project that I’ve been working on for the better part of 2 years.  My task on this project is to convert data from an old UNIX-based Universe database to a SQL Server-based application; the database we are extracting from is quite old, both in terms of technology…


Defining Value

I’ve been thinking a lot lately about the concept of value.  Recently, a colleague of mine tendered his resignation quite unexpectedly and at a very inconvenient time, just before the consummation of a 2-year software implementation and data conversion project.  Citing health and family concerns, he decided that the value he received from his work was disproportionately low compared to…


No Picture

Slacking and data quality (in that order)

Well, I almost missed blogging for the entire month of June.  I’m sure that this fact didn’t go unnoticed by both of the people who read my blog…  I’m working on a major data conversion and am in a mad dash to finish converting and validating years of healthcare and financial data, and unfortunately my free time (including the time allocated…


No Picture

T-SQL Quirk: Using NOT IN With NULL Values

There is a little quirk in T-SQL with NULLs when using the NOT IN qualifier.  I use the term “quirk” loosely here because the behavior is exactly as intended, though it may not be obvious.  The following query shows a trivial example: At first glance, one might think that we’ll see returned the row for the Chevy MINIVAN.  However, when…


No Picture

A little fun with SSIS expression language

The SSIS expression language is a powerful yet enigmatic entity.  Once you get used to its syntax – which is part C#, part T-SQL and part *WTH?!?* – it’s actually somewhat fun to use.  However, one thing it is lacking (as far as I can tell – correct me if I’ve missed something) is the ability to use an IF…ELSE…


No Picture

SQL Saturday Jacksonville

I just wrapped up a high-octane day of SQL Server community education at SQL Saturday in Jacksonville, Florida. This event, the third thus far in a series of training opportunities for SQL Server professionals, is loosely based on the Code Camp model and is billed as a community event. I enjoy these kind of events, having attended several Code Camps…


No Picture

Gotta love the Information Age

First it was CNN 24×7.  Next the Internet brought us live information from around the globe. Now this…  real-time pizza tracking…


No Picture

SQL Saturday

I’ve just received notice that I will be a presenter at the upcoming SQL Saturday event in Jacksonville, Florida. I’ll be speaking about the SQL SMO object namespace and how this powerful set of classes can be used to administer SQL Server instances programmatically. I’m looking forward to this opportunity. I’ve not had much experience delivering presentations to those outside…


No Picture

We Are Microsoft Charity Challenge Weekend

This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of the Dallas-area .NET user group community (and specifically, Toi Wright), Microsoft, BravoTech and a number of other vendors, the first annual We Are Microsoft Charity Challenge was born in a flurry of activity over the last three days. This event…