May 2012

No Picture

SQL Rally Slide Deck and Photos

I’m working on a more comprehensive review of last week’s SQL Rally event, but I’d like to go ahead and share my slide deck and photos from the event. For those who attended my Data Quality Services session on Thursday, thanks so much for coming.  I had 100 or so in attendance, and a lot of good questions and discussion…


No Picture

DQS Composite Domains and Value Combinations

As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working with data domains, composite domains, and rules.  In that exploration, I’ve found some behavior that might not be expected when performing cleansing operations against a knowledge base containing a composite domain. In this post, I’ll outline the expected data cleansing…


No Picture

DQS Validation Rules on Composite Domains

In Data Quality Services, composite domains can be created to associate together two or more natural domains within a knowledge base.  Like natural domains, composite domains can also contain one or more validation rules to govern which domain values are valid.  In my last post, I discussed the use of validation rules against natural domains.  In this post, I’ll continue…


No Picture

DQS Domain Validation Rules

A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to fields (domains) to describe what makes up a valid value.  In this brief post, I’d like to walk through the concepts of domain validation and demonstrate how this can be implemented in DQS. Domain validation essentials Let’s ponder domain validation…


No Picture

SQL Saturday Houston Recap

Last month I made the trip with some other Dallas-area speakers down to Houston’s second annual SQL Saturday event.  This was one of the shorter trips for me – we drove down on Friday afternoon/evening, and left out late Saturday.  It was good to be away from home for just one night (rather than the two nights I normally stay…


No Picture

Win a Free SQLRally Admission!

As those of you in our local North Texas SQL Server User Group are aware, we have given away one free 2-day pass to SQL Rally during each of the past two user group meetings.  Unfortunately, a schedule conflict has forced one of the winners to withdraw from the event. However, someone else’s loss can be your gain.  Tomorrow afternoon,…


No Picture

SQL Rally–1 week out

It’s hard to believe that after all the hard work, planning, and prep, that SQL Rally Dallas is just a week away! This time next week the conference will be in full swing for Day 1 of the regular sessions. The preconference seminars actually start on Tuesday, so it’s going to be a full week of learning’, Texas-style! For my…


No Picture

Eight Words

I remember a lot of things about that day.  It was July in Texas, which is to say, it was unbearably hot.  For the work I ended up doing that day, I was way overdressed in my long-sleeved blue button down and khakis.  I was training a new guy – Andy – who had recently been promoted from Service Agent…