We are a group of professional users of Microsoft SQL Server dedicated to sharing knowledge with each other. We aim to increase the knowledge level of each member of the group and to increase the usefulness of the product for each member. The group usually meets on the 4th Thursday of each month with this months meeting being held at the Microsoft Brisbane Office, Level 28, 400 George Street.
  • The next meeting will be on the 23rd April 2015
Please arrive around 5:30 - 5:45 for a 6pm start. (It is important to note that the building lifts get locked at 6pm). Most meetings will be finished by around 7:30pm. The format of each meeting will normally be an introductory level session for 20 minutes to half an hour, followed by a more advanced level session for around an hour. We hope this will allow both newcomers and old-hands to feel at home and to get something from each meeting.



Last Updated: 15 Apr 2015 12:09:55 PM

Next Meeting - Thursday 23 Apr 2015

April QLD SQL Server User Group - Konstantin Khomyakov
Data Quality Services Deep Dive

Data Quality Services (DQS) is one of the main mechanisms for data normalization, removing duplicate content and filling knowledge base. It allows you to perform various operations to obtain quality data. The main feature is the creation of the knowledge base, in which there are basic configuration, data manipulation rules. DQS Cleansing is the standard SSIS control, which is used for normalization (cleansing) data. In this session two new controls will be introduced: DQS Domain Value Import and DQS Matching Transformation. During the session SSIS package will be created. This package will automate the process of importing domain entities, including synonyms, to the existing kno...wledge base. Also mechanism for removing duplicates will be applied, relying on returned weights coefficients compared between each set of records.

In this session two new controls will be introduced: DQS Domain Value Import and DQS Matching Transformation. During the session SSIS package will be created. This package will automate the process of importing domain entities, including synonyms, to the existing knowledge base. Also mechanism for removing duplicates will be applied, relying on returned weights coefficients compared between each set of records.

About the Speaker


Konstantin Khomyakov specializes in in Microsoft SQL Server Business Intelligence. Key areas of interest are: Integration Services (SSIS), Analysis Services (SSAS), Data Quality Services (DQS) and Master Data Services (MDS). His consulting focuses on all aspects of Microsoft Business Intelligence stack from architecture design and implementation planning to installation and support of the product. Konstantin is an active member in the SQL Server community, presenting technical sessions at SQL Saturday and PASS events both in Australia and Overseas. Konstantin is a SQL Server Microsoft Most Valuable Professional recognised for his technical excellence and his ongoing commitment to the Microsoft SQL Server community.

Venue: Microsoft Brisbane - Level 28, 400 George Street, Brisbane Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 23rd April 2015
RSVP: to contact@wardyit.com to help with catering
To Register. Click here
Edit 23/04/2015 05:30:00 PM (local time)
[ Log On ]

Official PASS Chapter
We are an official chapter of the Professional Association of SQL Server (www.sqlpass.org)



INETA Member
We are a member group of the International .NET Association (www.ineta.org).