March 2011 UG Meet Scheduled

Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30 AM to 02:00 PM
Date: 05th March 2011

Session Details

Data cleansing with SSIS

Attendees will gain an understanding of how to use Data profiles task to understand the data quality and evaluate.
Attendees will gain an understanding of powerful data cleansing capability with Fuzzy Lookups and Groupings.
Demo will be shown to understand how to use Profiler, Fuzzy lookup, Fuzzy grouping tasks

Speaker : Ayyappan Thangaraj

Ayyappan Thangaraj is a business intelligence consultant, database developer and speaker. He has been working with SQL Server for over half decade, working primarily in business intelligence, ETL/SSIS, database development and reporting. He holds Masters Degree in Computer Science from Pondicherry University. Ayyappan is a Senior Consultant for Solid Quality Mentors. He is a board member and speaker at the Chennai SQL Server User Group in Chennai, India. Ayyappan is an author and forum contributor on various SQL Server Blogs and MSDN, and also you can read his blog at http://sqlserverrider.blogspot.com.

T-SQL Enhancements in SQL 2005 & SQL 2008

T-SQL 2008 Enhancements

1. VALUES Clause
2. HIERARCHYID datatype
3. Table Valued Parameters
4. MERGE Statement
5. Grouping Sets
6. Sparse Columns

T-SQL 2005 Enhancements

1. Ranking Functions
2. Pivot and Unpivot
3. Common Table Expressions
4. CROSS APPLY and OUTER APPLY

Speaker : RamiReddy

RamiReddy is a .NET Developer, who has passion towards t-sql. He has been working with .net/sql server for the Last 5 years. He spends his spare time contributing in the ASP.NET and SQL Server Forums.

Questions?? Contact cssug@sql-articles.com

CLICK HERE to get registered for this event. It’s free!! Why are you still waiting?

PS: We will be freezing registration by 04th March 2011 EOD