www.sqlpass.org    Professional Association for SQL Server
 What's Happening?

Next Meeting: Fri, Jul 12 2013

ABQSQL July Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

July meeting of ABQ SQL

When

iCal
UTC : Fri, Jul 12 2013 17:30 - 19:00
Event Time : Fri, Jul 12 2013 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Jul 12 2013 17:30 - 19:00

Where

6700 Jefferson Street
Albuquerque , New Mexico

Direction: None

Featured Presentation

Getting Solid Results Using The Fuzzy Data Controls in SSIS

Speaker: Gene Hill, DBA

Summary: You'll feel warm and fuzzy after learning how controls in SQL Server Integration Services (SSIS) can play a major role in improving the quality of your data. Using a list of medical providers as our example, we will walk through the full cycle of a process that performs historical list cleanup and detects new list members via fuzzy matching. This entails identifying string patterns in data fields, parsing them accordingly, then feeding the results through an SSIS process that employs the Fuzzy Lookup and Fuzzy Grouping controls. Subject to additional user-designed filters, a resulting similarity score is then compared to a threshold to either match new members to an existing member or create a new list entry. We will conclude the session touching on the new Data Cleansing Services (DQS) transformation bundled in SQL Server 2012.

About Gene: Gene Hill serves as data manager at LCF Research, an Albuquerque-based health services research organization whose activities include management of the New Mexico Health Information Exchange. Prior to LCF, Gene worked as a systems analyst and database consultant in financial services, merchandising and municipal government in New York City, New Mexico and Madrid. Gene holds an MA in Economics and a BBA in General Management from University of New Mexico

Attachments

Supplementary Materials

The following event attachments are available to you:

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif