Fundamentals of SQL Server Contact Data Cleansing

Melissa sponsored on-demand webinar

Webcast Abstract

SQL Server Data Standardization, Formatting and Parsing should not have to come at a cost. However, the roadblocks involved in implementing a solid and routine for normalizing data can be extensive and can prove to be time consuming, especially when dealing with specific types of domains.

  • Email addresses for example, will have several restrictions defined by Internet Standards (eg. RFC 822).
  • Names are difficult, due to the nature of its vagueness and flexibility.
  • Phone numbers are presented differently every time.
  • Addresses rarely follow the USPS US Address Standard for formatting.

In this webcast, we will help you come to an understanding of the major roadblocks in normalizing contact data (Address, Name, Phone and Email). In addition, experience a new no cost approach from Melissa Data using plugins for Microsoft SQL Server Integration Services 2012 to effectively normalize contact data.

Speaker - Joseph Vertido

Joseph Vertido is a Data Quality Analyst at Melissa Data, Joseph Vertido is an expert in the field of data quality. He has worked with numerous clients in understanding their business needs for data quality, analyzing their architecture and environment, and recommending strategic solutions for how to successfully integrate data quality within their infrastructure. He has also written several articles for implementing data quality solutions and techniques. Joseph holds a degree in Computer Science from the University of California, Irvine.

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

get free sql tips
agree to terms