Last week I presented a session at SQLlunch entitled "Restartability in SSIS" (thank you for those of you that attended... I hope you weren't disappointed). For the most part I focused on the feature that is already provided to us by Microsoft; and that feature is Checkpoints. I did a quick search on "checkpoints" here on BIDN before I started writing this, and I noticed that there is already a wealth of great content pertaining to this topic (Devin's blog or Shawn's article , for example). Howe...
Read More
Hey everybody! I just wanted to send out a last minute reminder of my SQLlunch session tomorrow at 11:30 AM CST (that's 12:30 for the east coasters). If you can forfeit some of your lunch break, I'll be talking about some features within SSIS that can save a ton of time. By implementing checkpoints inside your package you are able to restart a package at the point of failure. You can follow this link to SQLlunch.com for some more information and a link to the meeting. And while you're there, che...
When I'm at work, at least a couple times a week, I find myself needing to dive into some of the tiny little details of the environment that I'm working in. Whether I've been working on a database for a year, or it was a table that I just created a day ago, I tend to forget some of the smaller details that are important to know when developing ETL or reports. As a result, I have become very well acquainted with a few helpful system views that, 9 times out of 10, give me exactly what I'm looking ...