Friday, July 29, 2016

SG SQL UG Meetup - July 2016

Date: July 28th 2016
Agenda:
July 28th - 6:45 PM to 7 PM - Registration and Snacks
7 PM to 8 PM - Topic 1 - Presentation by Dharmendra Keshari
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: SQL Server - Extended Events – Part2
Synopsis: Extended events aids in performance tuning and in day to day administration especially when you don't have any benchmarking data for troubleshooting issues. In this session, we will see extended event architecture, an event life cycle, how we can use default extended events session to analyze the health of SQL Server on periodically. Besides these, the presentation would also cover advance level troubleshooting like query compilation, Tempdb contention issue are many more…
Speaker Profile: Dharmendra Keshari
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 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:  Cardinality Estimator - Before 2014 and After
Synopsis: Cardinality estimator providing row estimates, plays a pivotal role in obtaining efficient query plans. Cardinality Estimator algorithm which remained unchanged since SQL 7.0, was revamped in SQL Server 2014. The presentation will take a ride through the new cardinality estimator, showcase the need for the significant redesign and demonstrate the new cardinality estimator's efficiency at different scenarios. Presentation will also cover how one can perform regressive testing, checking for any performance degradation on new cardinality estimator and how they can be handled gracefully.
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 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

Wednesday, July 13, 2016

SQL Saturday Pre conference 2016 by Andreas Wolter !!!


Dear All,

We are very happy to announce the first ever SQL Server Pre conference in Singapore scheduled on 19th August 2016.Pre conference seminars one day deep dive technical training provided by World Class Master for a small audience. It is 8 hours of learning, deep dive technical stuff delivered by the best of the best in the business, coming to you at a very nominal price. For the first ever SQL Server Pre Conference in Singapore, we are honored to have "Andreas Wolter" from Germany. Andreas Wolter is a Microsoft Certified Master (SQL 2008) and Microsoft Certified Solution Master (SQL 2012) making him one of the just two in the globe to have a "Master" certification on both SQL Server 2012, SQL Server 2008. Andreas is also a Data Platform MVP and a Microsoft Certified Trainer. Details provided below.

Topic: SQL Server Performance Monitoring & Troubleshooting with a Master
Date: August 19th 2016
Time: 8:30 AM to 6 PM
Early bird pricing : 308.75 s$
Regular pricing: 349.75 s$
Early bird pricing is for first 5 registrants only.


Registration URL: https://www.eventbrite.com/e/sql-server-precon-performance-monitoring-troubleshooting-with-a-master-tickets-26542439150



Regards,
SG SQL PASS Chapter Team