SSRS Web Presentation – Followup (Part 1)
Hi all! Yes, it’s been a while since I’ve blogged, but I have a great new subject to talk about. Last week, I struggled through a cold to deliver a […]
Adventures in Oracle SSMA!
Last week I had a very interesting engagement where I had to come up with a high level estimate for an Oracle migration to SQL Server using the SQL Server […]
It’s a New Year!
It’s a New Year, and time for some new actions. I don’t do resolutions, but I’m all about starting new things, and January is a great time for that. So, […]
What I learn from teaching
I just wrapped up another teaching engagement, teaching BI tools to a group of analyst and administrators. I really enjoy the opportunity to teach. What I realized is that I […]
The value of doing it right the first time
Something I hear a lot as a consultant is “Let’s just get it done and we can go back and fine tune it later”. When I hear that, what *I* […]
DQS – Real World Complex Domains made… well… complex ;-)
One of the nice features in DQS is the ability to manage “complex” domains, i.e. groups of fields that must be validated on their own. An Address is a type […]
My take on DQS so far – The Good, Bad, and Ugly
I’ve just spent two weeks learning how to cleanse data using the DQS tool that is a part of SQL 2012. Here’s my take so far. The Good The engine does […]
MDS, DQS, SSIS – a whole lot of letters without a lot to read!
I blogged last week that the way to solve my current customer’s problem (aggregating data from lots of sources) was to use the MDS and DQS tools from Microsoft SQL […]
SSIS Challenge Accepted!
Earlier this week I posted about having a new challenge – how to use SSIS to dynamically define and generate rules for data cleansing. This week I discovered that the way […]
SSIS challenge
This week my challenge is to come up with a way to make SSIS a dynamic rules-driven engine. This is a concept that is fairly easy to do in a […]
