DQS – Data Quality Services in SQL Server 2012

TRINUG – Data SIG, July 2013

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data.

Understanding and Using System.Transactions

These are some resources to help grasp System.Transactions functionality and use it effectively in your projects:

Features Provided by System.Transactions
Implementing an Implicit Transaction using Transaction Scope
MSDN Articles by John Papa
ADO.NET and System.Transactions
Revisiting System.Transactions
These are specific to TransactionScope (the way to go in most cases)
Here is a practical example of Using TransactionScope :
This one gets in depth with the way a TransactionScope like functionality can be implemented. Gives you a good understanding of what is happening under the hood when using TransactionScope in some Repository implementations in multi-threaded scenarios.
Here is another example of implementing a transactional repository :
There are excellent tips here about configuring TransactionScope when used with SQL Server:
This is a good resource for CommitableTransaction usage – http://www.codeproject.com/Articles/55472/Committable-Transactions-in-C-SQL
And this one has brilliant under-the-hood coverage – http://www.codeproject.com/Articles/35087/Truly-Understanding-NET-Transactions-and-WCF-Impl