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, […]
Category Archives: SQL Server
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 […]
Taught my first SQL/BI Class!
I’m in Miami this week, and I’m wrapping up my last day of a 5 day class on the Microsoft BI Stack, including PowerPivot, Power View, and PerformancePoint. This was […]
Ms Kathy V 