“Pattern Matching” in Data Quality Services –Domain Rules

Guess what guys?  I’m speaking at PASS Summit this year!  My session titled Data Quality Services—Finally!    was selected and I get to go to the premier SQL Server conference and present on a topic which I find truly exciting.  Data Quality Services (DQS) is new with SQL Server 2012.  Along with Master Data Services (MDS), it represents Microsoft’s entry into Master Data Management (MDM).

The ideal use of MDS and DQS represent to me a paradigm shift in the way I.T. folks and business folks interact.  These tools are not just another way for I.T. to develop solutions for “the business” based on requirements (whether those requirements are thoroughly documented via a watershed lifecycle or verbally shared with agile).  DQS and MDS were explicitly designed for continued and iterative use by business users with expert Knowledge about their data.  In MDM speak, these experts are called Data Stewards.  I recommend that anyone in Data continue getting familiar with these concepts.  Data Governance and Master Data Management are terms you are likely to see from now on.  For more information I recommend David Loshin (http://mdmbook.com/) .  His book,  Master Data Management is a comprehensive guide to this topic.  I’ve also found useful articles here , including articles on ways for I.T. to get “buy in “ from C-levels.

So, back to today’s post.  As I was prepping my session for PASS Summit on Data Quality Services, I was extremely fortunate to be in communication with Matthew Roche and Matt Masson of Microsoft, who are also presenting on DQS  (and MDS– actually all of EIM) at Summit.  These two are both uber “ersum”, always willing to help me, answering emails at all hours of day and night.

Let’s dive in:  Keeping data clean with DQS starts with creating a Knowledge Base.  This is done in the Data Quality Client.  Inside a Knowledge Base you create and maintain Domains.  Single domains are the equivalent to a column or attribute in a database.

The Data Quality Client.

Continue reading “Pattern Matching” in Data Quality Services –Domain Rules

Mulligan–Don’t Forget to Vote for PASS Summit’s Lightning Talks–Again!

A glitch somewhere caused PASS to redo the Community Vote for Lightning Talks–Another Chance to make your choice known for your favorite sessions.  And if you need help with the menu, may I suggest the ham?

Also, if you are in the area, I hope you are considering Columbus, Georgia’s first SQL Saturday (#167) !  I am delighted to be speaking at this event!

SQL Saturday 126: I presented DQS Finally! in Indianapolis

Thanks to the folks who came out to see my DQS presentation in Indy this past weekend.  Thanks to Caroline Bailey, Hope Foley, Kyle Neier , Eddie Weurch, and the rest of the Indy crew who put on an excellent event.  Here is my slide deck as promised.  I met many fantastic folks and had a paleolithic good time.

VMWare Player Version Issues

A Non SQL Server Blog post

I was working on a presentation last night and I tried to open a virual machine on vmware player, and I got this error:  Invalid configuration file. File “filename.vmx” was created by a VMware product with more features than this version of VMware Player and cannot be used with this version of VMware Player.  Cannot open configuration file filename.vmx. Continue reading VMWare Player Version Issues

We don’t write, we don’t call…it’s like we’re a couple of jerks.

I check our blog every now and then and hang my head in shame.  We don’t write, we don’t call.  What happened?  Well actually a lot of good things.  We failed to announce on our site when Audrey became an MVP!  

Audrey’s an MVP!!!! Continue reading We don’t write, we don’t call…it’s like we’re a couple of jerks.

The SQL Saturday #111 PreCon Scholarship Winners are….

Thanks so so so so much to Idera!  For sponsoring these lucky winners!

To all who submitted!  You showed initiative in taking charge of your career!  Kudos!

To our speakers!  Thanks for putting on these training events and enriching the lives of other professionals.

To Midlands PASS (Bobby Dimmick (web | twitter) and Brian Kelley (web | twitter)) for picking the winners–tough choices I know!

The winners are:

Scott Murray for No More Guessing with Adam Machanic

Alex Salyer for A Day of SSIS with Andy Leonard and Matt Masson

Vanessa Miller for Learn Reporting Services in a Day with Jessica Moss

Congratulations!