Saturday, January 27, 2018

SQL SG UG Meetup - Jan 2018

Dear All,

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

Agenda:

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

7 PM to 8:15 PM - Topic 1 - Presentation by Nagaraj Venkatesan

8:15 PM to 8:30 - Break

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

Location: Microsoft Office, One Marina Boulevard, Conf Room 21-MRP02

Topic1: SQL Server 2017 - Product Update

SQL Server 2017 has quite a few new features for developers and database administrators. This session will cover the following SQL Server 2017 enhancements;

* Automatic Tuning
* T SQL Enhancements of SQL Server 2017

Speaker Profile:


Nagaraj Venkatesan is a Data Platform MVP from Singapore and the leader of Singapore SQL PASS Chapter. As a SQL Server enthusiast, Nagaraj is a regular speaker in Asia Pacific region at Data Platform events like SQL Saturdays, SQL Server Geeks Summit, User group meetups etc.  Nagaraj shares his technical expertise at strictlysql.blogspot.com. Nagaraj also runs a YouTube channel called "DataChannel", which contains technical interviews with top Microsoft Data Platform experts in the world

Topic2: Query Store

The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. It provides the ability to natively capture baseline data within SQL Server. Using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query.
During this session we will take a thorough look at the Query Store, its architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you

Speaker Profile:

Dharmendra Keshari has strong and in-depth experience in Database Management. Currently, working as Senior Database Administrator at Micron Technology in Singapore, and in past he had handled one of the most critical databases which are being used by Singapore Public Hospitals, national specialty centres and polyclinics.
Dharmendra is an avid, regular mentor on social media, helping several enthusiast in solving their problems related to Database management. he is co-leader and regular speaker at Singapore SQL Server Pass Chapter (User Group). He has done certification for “Microsoft SQL Server® 2008, Implementation” and “Maintenance & Administering Microsoft SQL Server 2012 Database”. | www.dharmendrakeshari.com