Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a Microsoft SQL Server consultant, speaker, and trainer, and is a Microsoft SQL Server MVP. He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, reporting, and database development. You can find his complete profile at TimMitchell.net.

Archives: May 2012

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… Read more

8 comments, 180 reads

Posted in Tim Mitchell on 15 May 2012

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… Read more

0 comments, 19 reads

Posted in Tim Mitchell on 15 May 2012

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… Read more

0 comments, 17 reads

Posted in Tim Mitchell on 10 May 2012

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… Read more

4 comments, 306 reads

Posted in Tim Mitchell on 10 May 2012

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… Read more

4 comments, 253 reads

Posted in Tim Mitchell on 7 May 2012

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… Read more

1 comments, 22 reads

Posted in Tim Mitchell on 7 May 2012

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… Read more

0 comments, 8 reads

Posted in Tim Mitchell on 4 May 2012

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… Read more

8 comments, 1,171 reads

Posted in Tim Mitchell on 4 May 2012

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… Read more

4 comments, 154 reads

Posted in Tim Mitchell on 4 May 2012

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. Read more

4 comments, 273 reads

Posted in Tim Mitchell on 3 May 2012

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… Read more

1 comments, 324 reads

Posted in Tim Mitchell on 3 May 2012

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 –… Read more

7 comments, 1,893 reads

Posted in Tim Mitchell on 2 May 2012