Search SSWUG.ORG:

WHITEPAPERS

Whitepapers You Have Activated
No Whitepapers found.


Other Available Whitepapers
White PaperDate
SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

Among the features available in SQL Server 2012 Data Quality Services is the ability for data stewards to profile, match and cleanse data. In addition to the homegrown rules that can be designed and implemented, there are also connectors to third party providers that are hosted in the Azure Datamarket. In this application note, you will learn how to subscribe to a third party data cleansing product through the Datamarket to showcase this unique capability.

1/15/2014
Six Steps to Managing Data Quality with SQL Server Integration Services

Overcoming the challenges of data quality doesn’t have to be costly or difficult to do. Organizations can take advantage of the integration capabilities inherent in Microsoft’s SQL Server Integration Services (SSIS) to implement a Total Data Quality strategy needed for successful MDM, data warehousing and data quality projects. This white paper describes a six-step plan to managing data quality using SSIS. In this new white paper learn:
  • How to deliver clean, consistent data that can be distributed and confidently used across the enterprise, regardless of business application and system.
  • How to resolve incomplete or missing customer profile information, such as blank phone numbers or addresses.


1/15/2014
Encryption & Key Management for Microsoft SQL Server 2008/2012

Written by Townsend Security

Simplify encryption and key management on your SQL Server. Data thieves are targeting SMB companies because of their inadequate security practices. The estimate of these financial losses range into the billions of dollars every year. The most critical barrier SMB companies face is access to compliance solutions that are affordable. This paper discusses compliance regulations, standards for protecting data with encryption, and how Microsoft provides for the encryption of sensitive data in its flagship SQL Server database system. It also introduces Townsend Security’s Alliance Key Manager HSM which provides a cost effective, easy-to-deploy, and compliant solution for Microsoft customers.


1/1/2014