Search Results for dqs

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…


My SQL Server Development Toolbox

Having the right tools for the job makes the work much more efficient. However, for those just starting out in SQL Server land, it may not be clear which tools are useful or appropriate for a given task. I regularly field questions about which tools I use on my development machines, and why. To that end, I’ve compiled a brief…


SQL Server 2016 Service Pack 1 Changes Everything

Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this announcement, because this is not a typical update. Service Pack 1 unlocks most all of the programmability features found in Enterprise Edition, making them available in lower-cost (and even free) editions of SQL Server. Folks, this is a huge change…


SQL PASS 2014 Summit Diary – Day 6

Today is the last official day of the PASS Summit.  The sessions will wrap up at the end of the day, and we’ll all go our separate ways and resume our semi-normal lives.  Having delivered my presentation yesterday, my official PASS duties are over, and I’m planning to spend the day taking in a few sessions and networking. 08:15am: No…


SQL PASS Summit 2012 in Review

I’m back home after a long week attending and presenting at the SQL PASS 2012 Summit in Seattle. This was the best event yet, in my opinion, and for me it was certainly the busiest. For the second year in a row, our SSIS Design Patterns team was invited to deliver a full-day preconference seminar before the Summit. Unlike last…


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…


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…


In 2012, It’s Me and Vanilla Ice

Like many others, I’m planning a few changes for my life for next year.  I’m a believer in finding one’s own way, while still abiding the advice of the wise.  Often called upon for inspirations are the timeless words of Confucius, the inspiring speeches of Martin Luther King, the controversial yet insightful analyses of Sigmund Freud, and the various authors…