THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

Is DQS-in-the-cloud on its way?

LinkedIn profiles are always a useful place to find out what's really going on in Microsoft. Today I stumbled upon this little nugget from former SSIS product team member Matt Carroll:

March 2012 – December 2012 (10 months)Redmond, WA

Took ownership of the SQL 2012 Data Quality Services box product and re-architected and extended it to become a cloud service. Led team and managed product to add dynamic scale, security, multi-tenancy, deployment, logging, monitoring, and telemetry as well as creating new Excel add-in and new ecosystem experience around easily sharing and finding cleansing agents. Personally designed, coded, and unit tested in-memory trigram matching algorithm core to better performance, scale and maintainability. Delivered and supported successful private preview of the new service prior to SQL wide reorganization.

 Sounds as though a Data-Quality-Services-in-the-cloud (which I spoke of as being a useful addition to Microsoft's BI portfolio in my previous blog post Thoughts on Power BI for Office 365 ) might be on its way some time in the future. And what's this SQL wide reorganization? Interesting stuff.



Published Friday, July 19, 2013 12:37 PM by jamiet
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



jbooker said:

Cloud DQS is already here in Windows Azure Marketplace:

July 19, 2013 10:51 AM

jamiet said:

Thanks. Those are data sources that can be used by DQS, not DQS itself.

July 19, 2013 12:19 PM

jbooker said:

Not being very familiar with DQS box product, I'm sure you're right, but I'm unclear about your distinction.  To my knowledge, they are services entirely in the cloud installed as Azure Add-Ons which expose the DQS REST API rather than exposing any data sets.  I've tried the Melissa Data Address Check DQS service. By sending a 'SuggestAddress' request I get a standardized address in the response.  This enables web apps to improve data quality instantly before the data enters the database.  How is that not DQS in the cloud?  Is it some DQS design time tooling that you refer to as 'DQS itself'?



July 19, 2013 1:28 PM

jamiet said:

To me, DQS-in-the-cloud would mean having the ability to maintain my own DQS knowledge base. If you read here: it states "specifically designed to be integrated with the Data Quality Service available in Microsoft SQL Server", implying you still have to be running DQS somewhere. Today, the only place you can do that is on your own infrastructure.



July 20, 2013 2:38 AM

Leave a Comment


This Blog


Privacy Statement