Tuesday, October 4, 2016

SG SQL UG Meetup - Sept 2016

Dear All,

Its meetup time again at Singapore SQL PASS Chapter.  Please refer below for the details.

Agenda:

September 29th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Mohit Nirawal

8:00 PM to 8:15 - Break

8:15 PM to 9:30 - Topic 2 - Presentation by Nagaraj Venkatesan

Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15

Topic 1: DMV:Sql Server DBA best friend

Synopsis: With SQL Server  Dynamic Management Views (DMVs) You can find server top wait types,memory pressure, most CPU intensive stored procedures,database missing indexes, and identify unused indexes. This session , presents and explains over twenty DMV queries that we can quickly run to detect and diagnose performance issues in our environment.

Speaker Profile: Mohit Niranwal

Mohit Niranwal,works as a DBA  at InternationalSoS based in Singapore.He holds MCSE Sql Server 2012 data platform certification, with over 10 years experience in IT.He has worked with all versions of SQL Server starting  from 7 in various dev/admin roles, with an emphasis in performance tuning.


Topic 2:  SQL Server Query Store - The Real "Deal"

Synopsis:

"Why my database performance has been suddenly slow?
 Have my query plans changed?
 Which plans have regressed and since when?
 Is there any way I can control the plan change without changing the source code?"
If you have encountered any of the above situations, then query store is your remedy. SQL Server Query store is one of the path breaking features released in SQL Server 2016. The presentation will showcase how query store is a boon in handling sudden performance degradations, plan changes and analyzing query performance patterns over a period of time. Presentation will also demonstrate the power of query store in forcing query plans and compare it against options available in earlier versions of SQL Server. Presentation will have interesting demos on tracking plan regressions and on scenarios the use force plans feature. At the end of the session, audience will have a clear understanding on how query store becomes their new important weapon in their arsenal, for performance


Speaker Profile: Nagaraj Venkatesan
Nagaraj Venkatesan, a SQL Server enthusiast exploring SQL Server for the last 10 years. Working for NCS Pte Ltd as SQL Server DBA, Nagaraj maintains databases used by one of the busiest public facing applications in the city. He frequently blogs at http://strictlysql.blogspot.com and is a regular contributor sqlservercentral.com. Besides these, he also holds a Masters Degree in Computing from National University of Singapore

Download Link for the Slides: here