TimMitchell.net is the personal blog of Tim Mitchell. This Privacy Policy outlines the types of personal information that is received and collected and how it is used. This Privacy Policy is reviewed and revised from time to time. You will want to revisit it regularly. Your use of this site, in any and all forms, constitutes an acceptance of this…
In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven to be highly effective. In the interest of comprehensive coverage on the topic, I am adding to the list an introductory prequel to address the fundamental question: What is ETL? What Is ETL? ETL is shorthand for the extraction, transformation,…
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 San Antonio, Texas. This course is designed for the data…
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 any one particular thing that made the experience a positive…
Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address. This post will be updated throughout the keynote. Don’t forget you can watch the live stream on PASS TV. Adam Jorgensen, current EVP of finance (and future president) of PASS shares about the financial status of the organization. Revenue has…
As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the first-ever SQL Rally event. The past few days have been an adventure in many ways, and I’m happy to report that the entire experience was both positive and memorable. Wednesday The trip started out in chaos: an immense line of…
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to major league baseball players, while grouping corporate staffers into the minor leagues. While he does make a few valid points, the theme of the post – as well as many of the assumptions he makes – are out of left…
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to healthcare data integration. In this post I’ll talk about the first part of the problem: a lack of adoption of the required technologies and/or methodologies. I’ll also describe when an electronic health record really isn’t. We’ve all seen it; it…
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…