Tuesday, May 30, 2017

SQL SG UG Meetup - May 2017

Dear All,

Singapore SQL PASS Chapter meet up for May is scheduled on May 24th ( Wednesday) at 7 PM as usual. Speaker and topic details provided below

Agenda:

May 24th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8:15 PM - Topic 1 - Presentation by Khilitchandra Prajapati

8:15 PM to 8:30 - Break

8:30 PM to 9:15 - Topic 2 - Presentation by Dharmendra Keshari

Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15 (24) AV

Topic 1: Deep dive into Configuring SSIS Packages


Abstract: Configuring SSIS Packages can be a tricky problem to encounter more often than not. This session on SSIS Packages will run thro various methods in configuring SSIS packages, their pros and cons and the scenarios at which they can be applied. The Session will also cover the end to end deployment cycle of a SSIS Package and discuss package and project deployment models. The session would explain the various best practices to be followed while configuring and deploying SSIS Packages.

Speaker Profile:

Khilitchandra V. Prajapati, an Enterprise Architect (Data Warehouse & Business Intelligence) at Marina Bay Sands, Singapore. He has implemented various BI solutions in last couple of years for industries like Oil & Gas, Banking, Telecom, Insurance, Casino & Gaming, Hospitality and IT. His prime focus is on Microsoft BI Stack (SQL Server, SSAS, SSIS, SSRS) with MOSS, C#.Net. He is a MSBI enthusiast and shares his knowledge, experience & expertise via his blog (www.bigator.com)

Topic 2: TSQL Fun & Explore few real life development problem

Synopsis: In this session we will discuss real life development problem, how aggregation, grouping, and distinct functionality can influence execution plans, why multi-statement table valued function can give very degraded performance, how TOP function helps not to put extra memory pressure... there are many more things to learn.

Speaker Profile:


Dharmendra Keshari, Microsoft Data Platform MVP, has strong and in-depth experience in Database Management and its internals. Currently, working as Senior Database Administrator in one of the best organization in Singapore. He is an avid, regular mentor on social media, helping several enthusiast in solving problems related to Database management. He has completed certification for “Microsoft SQL Server® 2008, Implementation” and “Maintenance & Administering Microsoft SQL Server 2012 Database”. You can follow his blog at http://www.dharmendrakeshari.com

Meetup link: https://www.meetup.com/mssgug/events/240039288/