Date: Feb 25th
Feb 25th - 6:45 PM to 7 PM - Registration and Snacks
7 PM to 8:15 PM - Topic 1 - Presentation by Dharmendra Keshari
8:15 PM to 8:30 - Break
8:30 PM to 9:15 - Topic 2 - Presentation by Khilitchandra Prajapati
Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15 (24) AV
Topic 1: Performance monitoring and Tuning Series: - Waits and Queues
Abstract : Wait Stats play a crucial role in identifying the correct root cause of a performance problem and also zeroing in on the actual query causing the slowness. This month's session will cover wait states, queuing process and the life cycle of a thread. Session will also explain the common wait types observed and their implications. Session would share a few useful DMVs and scripts for monitoring wait statistics.
Speaker Profile: Dharmendra Keshari has strong and in-depth experience in Database Management and its internals. Currently, working as Senior Database Administrator in one of the best Semi-Government 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”
Topic 2: Deep dive into Configuring SSIS Packages
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.
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)