Sunday, March 18, 2018

SQL UG Meetup - Mar 2018

Dear All,

Singapore SQL PASS Chapter meet up for March is scheduled on March 21st ( Wednesday) at 7 PM as usual. This time around, we are lucky to have Kevin Boles aka SQLGuru, 5 time MVP award winner and world renowned expert on T SQL and performance tuning. Session details provided below

Agenda:

March 21st - 6:45 PM to 7 PM - Registration

7 PM to 8:30 PM - Session titled "Query Plan Deep Dive" by Kevin Boles

Location: Microsoft Office, One Marina Boulevard, Level 22 - CF 12

Abstract: Query Plan Deep Dive

Another in TheSQLGuru's Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the astute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.

Speaker Profile:

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.


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