Category Archives: Uncategorized

It’s Alive!

You may have noticed a real dearth of posts over the last couple of months. That’s been a function of two things: I’ve been very busy at work with the release of Vivid, our Excel OLAP client, and working on … Continue reading

Posted in Uncategorized | Comments Off

Moving SSIS Packages with ADO.NET Destinations Between 2008 R2 and 2008

As noted by Matt Masson from the Integration Services team, not much has changed in SSIS 2008 R2. In fact, R2 is pretty much identical, with the exception of the ADO.NET Destination. So if you are developing packages, you can … Continue reading

Posted in Uncategorized | Comments Off

How to Save Yourself From Yourself

Have you ever wished there was some sort of magic “undo” button for something that you just did? Maybe you didn’t really mean to delete all 10 million records out of your table. You just forgot a little thing called … Continue reading

Posted in Uncategorized | Tagged | Comments Off

Inconsistent Column Width in SSRS

The issue I ran into was this: I was in Design mode of a report that I was developing. No matter what I did to change the column width on my columns, in both Preview as well as when I … Continue reading

Posted in Uncategorized | Comments Off

Speaking at the Carolina Code Camp

I’ll be presenting a couple of sessions at the Carolina Code Camp on Saturday, May 15th. This will be my second time presenting at the Carolina Code Camp, and I’m looking forward to it. Last time, I had great audience … Continue reading

Posted in Uncategorized | Comments Off

T-SQL Tuesday #006 – LOBs in the SSIS Dataflow

The topic for T-SQL Tuesday #006 is LOB data, selected by this month’s host, Michael Coles. If you aren’t familiar with T-SQL Tuesdays, Michael has a nice summary in his post. In database terms, LOBs are Large OBjects, also referred … Continue reading

Posted in Uncategorized | Comments Off

Delete Multiple Connection Managers SSIS

Have you ever wanted to save yourself some time by copying a package, renaming it, and then modifying its contents to suit your needs? What if the package that you are copying from has 60 connection managers, and your new … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

Inconsistent Background Colors in SSRS 2008

I ran across this issue a while back and figured I’d blog about my findings. After running my issue through Google, it turns out that I wasn’t the only one with this same problem. In SSRS, you can use the … Continue reading

Posted in Uncategorized | Comments Off

Presenting at the Triad Developers Guild

I’ll be presenting at the Triad Developers Guild on Tuesday. The presentation will be on Developing Custom Components for SSIS, a topic I’ve spoken on a few times before. Here’s the abstract: “SSIS data flows are great tools for moving … Continue reading

Posted in Uncategorized | Comments Off

Developer Gaps

I’ve been meaning to post about this ever since I saw Jamie’s post on “The SQL Developer Gap”. I couldn’t agree more with what Jamie expressed. Prior to getting into serious BI development, I was primarily an application developer. This … Continue reading

Posted in Uncategorized | Comments Off