Mike Diehl Fixes Us Up with Data Quality Services in SQL Server 2012
Carl and Richard talk to Mike Diehl about Data Quality Services (DQS) in SQL Server 2012. DQS is a new tool for SQL Server, as Mike points out, Microsoft acquired it. It adds into the suite of tools in SQL Server including Integration Services (SSIS), and Master Data Services. Mike talks about how DQS improves the quality of data by cleansing and de-duplication. Not a typical developer tool, but something any developer working with data needs to know about!
Guests:
Mike Diehl
Mike Diehl is the Practice Lead for Database and Business Intelligence at Imaginet Resources. He has been building relational databases since Access 2.0 and SQL Server 6.0, and has been working with OLAP databases for five years. He is an active member of the Winnipeg SQL Server User Group and has spoken at a number of conferences on database development and architecture.
Links:
- ClientFormsIdentity Class http://msdn.microsoft.com/en-us/library/system.web.clientservices.clientformsidentity.aspx
- Lynn Langit's Blog Post and Video on DQS and Azure http://lynnlangit.wordpress.com/2012/03/11/sql-sever-2012-data-quality-services-using-external-reference-data/