“It’s Alive” – SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years, SSIS Design Patterns, is complete and has been released for sale as of today. I got the unique privilege to work alongside SSIS rock stars Andy Leonard, Jessica Moss, Matt Masson, and Michelle Ufford to scribe what will hopefully be a must-have book for…


Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting in SQL Server.  It couldn’t possible have been 8 months since we were attending after-party events together, stopping by the Tap House for a beer, or closing down Bush Gardens with some spectacular SQL Karaoke.  Yet here were are, getting…


SQL Saturday Dallas–BI Edition (again!)

I’m happy to announce that the North Texas SQL Server User Group will be hosting our fourth SQL Saturday event this fall.  SQL Saturday #163 will be a BI-focused event similar to the one we hosted in the Fall of 2010.  We invite you to join us at the Microsoft campus on Saturday, October 13th for a full day of…


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, DQS 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…


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…


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…


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…


Coming to Dallas: Something for Everyone

Everybody loves the carnival.  It only comes around every few years, but when it does, it brings in a variety of people from all around.  Young, old, short, tall, skinny, chubby, and even Buck Woody – they stand in line for tickets, mill around for hours, and endure noise, crowds, and temperature extremes for a little dose of fun. What…


Speaking at SQL Saturday Houston

It’s SQL Saturday season again!  I found out this morning that I’ll be speaking at next month’s SQL Saturday event in Houston.  This will be my second consecutive year to speak at this event. The crew in Houston is great to work with.  Nancy Hidy Wilson, Jonathan Gardner, Malik Al-Amin, and the others event planners did a great job last…


Shameless Plug: Vote For My Sessions!

Have you voted yet for my sessions your favorite sessions for SQL Rally?  If not, this is a friendly reminder to hop on over and vote now.  You have to have a PASS login to vote, but don’t worry – it’s free to get one and takes about 2 minutes. Out of the 60 total sessions to be presented at…