Shane on January 18th, 2007

Loading your target incrementally offers a huge performance benefit over running full truncate/reloads, but there is a danger of missing inserts or updates in your source system. It can take hours or days to track down the source of these problems (if it can be done at all!) and problems are generally not found until [...]

Continue reading about Audit Your ETL With CHECKSUM

Shane on December 1st, 2006

I don’t burn ISO images onto disk very often, but every time I do it seems like I spend an inordinate amount of time downloading, installing, and trying to use several utilities before I finally find one that works. The search is over. ISO Recorder is free, fast, and easy to use. Dead easy. Thank [...]

Continue reading about How to burn an ISO image?

Shane on June 30th, 2006

Donald Farmer is blogging again! Donald works as Project Manager of the SQL Server Integration Services team at Microsoft. Donald is a very smart guy; gifted at explaining technology in an engaging and enjoyable way. One technique Donald uses is to heavily salt his speeches with good personal anecdotes. This quote aptly demonstrates why I [...]

Continue reading about Donald Farmer is Blogging (Again)!

Shane on May 24th, 2006

I scan a handful of financial blogs pretty regularly. I also scan a handful of technical blogs relating to SQL Server and Oracle. It isn’t very often that a blog from one of these worlds links to a blog in the other. But here’s JLP from AllFinancialMatters linking to Don Burleson of oracle-dba.com fame. I [...]

Continue reading about Two Worlds Collide

Shane on May 12th, 2006

Score another run for Fred Wilson’s VC Cliché of the week. He discusses “betting the company” by taking risks instead of managing risk. I think this is why many (most?) big company managers fail as venture stage CEOs. They are taught to mitigate risks, to plan, to protect. They don’t want to fail and so [...]

Continue reading about Betting the Company

Shane on September 2nd, 2005

I wonder how many blog posts out there today say something about, “It’s been a while since I’ve posted ….” It seems like many of these start with the best of intentions. As you can see, some of the links and stuff from the old posts are missing. I upgraded and decided it wasn’t worth [...]

Continue reading about Hello Old Friend