SG SQL UG Meetup - Nov 2016

Dear All,

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

Agenda:

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

7 PM to 8 PM - Topic 1 - Presentation by Andreas Wolter

8:00 PM to 8:15 - Break

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

Location: Microsoft Office, One Marina Boulevard, Level 21 Auditorium

Topic 1: “SQL Server Attacked” – excerpts from “Hacking SQL Server from inside & outside”

Synopsis:

Join us in this November’s special: Andreas Wolter will give a “best of” of his various “Hacking SQL Server” sessions, covering attacks from inside as well as from outside. While a part will be demonstrated using SQL Injection, other small demos will demonstrate security traps and holes that can occur when mixing Development & Production and granting external personnel too many permissions.

Speaker Profile: Andreas Wolter

Andreas Wolter(Facebook | LinkedIn) has over 16 years of experience with SQL Server and earned the Master-Certification both on SQL Server 2008 (MCM) and SQL Server 2012 (MCSM)– as one of only 2 experts worldwide. Besides that he has also been awarded with the MVP for SQL Server since 2014.
He is the founder of Sarpedon Quality Lab, originally from Germany, specializing in Development and Optimization of SQL Server Database- and Datawarehouse-architectures with focus on performance, scalability and security.

Topic 2: SQL Server 2016 SP 1 - a Rocking Release!!!

Synopsis: SQL Server 2016 Service Pack 1 was announced on Nov 17th and unlike any other usual service pack release, it had several path breaking changes announced. The big one of them being a major list of Enterprise features being made available on Standard edition. This session will discuss the features that moved to standard and how the applications can benifit using the same. The session will also cover few other useful enhancments that were released in SP1

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

Meetup link: https://www.meetup.com/mssgug/events/235571906/

SG SQL UG Meetup - Oct 2016

Details

Dear All,

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

Agenda:

November 2nd - 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:00 - Topic 2 - Presentation by Vikas Rai

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

Topic 1: The Secret of the SQL Server Database Boot Page

Synopsis:

We will be exploring some secretive information about SQL Server Brain page also known as boot page. What is pseudo-simple recovery model? How will you come to know your SQL server was upgraded from which version to which version? How does the SQL Server make sure, a full backup has happened before the log backup?

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: Introduction to R and Data Science

Synopsis: The session will be focused towards providing the basic understanding of R Programming language. To provide fundamental knowledge on Analytics and how it assists in decision making. How to work on statistical concepts like linear & logistic regression, cluster analysis and the approach to use statistical techniques and R language.

Speaker Profile: Vikas Rai

Vikas Rai, a technocrat with over 14 years of rich experience in various aspects of Enterprise Architecture, Data Science, Security (Infra & Apps) and Quality Management, is currently working as APAC BI Senior Solution Architect at L'Oréal. Vikas is also Skilled trainer for Microsoft technologies and Project Management Courses.

Meetup link: https://www.meetup.com/mssgug/events/235105818/

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

Facebook Link: https://www.facebook.com/events/1585962848376239/

Meetup Link: https://www.meetup.com/mssgug/events/234339437/

Download Link for the Slides: here

 

SQL Saturday Singapore 2016 - A Grand Success

Dear All,

Can't believe it’s over!!!! It was an awesome awesome SQL Saturday Singapore...There were so many people to thank for the great success of this event.

* Let me start off with YOU - Singapore SQL Community. Without your interest, passion and the enthusiasm we wouldn't have thought of doing a SQL Saturday in first place. Thanks for giving us a good attendance in all our meetups and encouraging us to do this event.

* PASS - Thanks to PASS for giving us a platform to arrange for an event of this scale. Without PASS support, we wouldn't have had the access to so many world class speakers for sure and event wouldn't have been such a success

* Microsoft, our Gold sponsor for the event - Thanks for the tremendous support for the event. Be it providing a venue, arranging food and taking in all our last minute requests. Don't recall how many times I would have disturbed Koh Ming Hao with countless emails and phone calls at odd hours for the event. Thanks to Vivek Ravindran, Tamarai, Harminder Sethi, Prakash Sawant for their priceless support without which this event would not have been possible

* Volunteers - Thanks to the gentle men with the "Red Tee" during the event. We formed a team just few days ago and how well we worked...Thanks for the selfless service rendered in the last 2 days. Thanks to Rehan Rocker, Manjuke Fernando, Vikash Rai, Mohit Niranwal, Abhishek Patel, Anand Raj, Alvin Lau and Sakthish Kumar for your help

* Speakers - Thanks to the overwhelming response for our event. We still wonder how lucky we are to have speakers from United States to Australia travelling 1000s of miles, speakers from the product team and industry experts. Joe young , Pinal Dave, Vinod Kumar M, Denny Cherry, Joey D'Antoni, Glenn Morris, Harminder sethi, James Beresford, Andreas Wolter, Stefan Riedel, Kevin Boles, Krishna Deepak, Subramani- Can't thank you all enough for the wonderful technical sessions

Special Thanks to Andreas Wolter for making a successful pre conference event too.
Special Thanks to Kevin Boles for covering an additional session in the last minute
Special Thanks to Harminder Sethi for taking a 90 minute session when one of the previously announced speakers couldn't make it

* Sponsors - Thanks to all our Sponsors - Gill Technologies, Red Gate, Devart, Sarpedon Quality labs for the raffle gifts and all the support for the event.

* Last but not least - Our Team, Singapore SQL Saturday Team -Dharmendra Keshari, Khilitchandra Prajapati, Sarbjit Singh Gill. Yes, little weird to thank ourselves but still thanks for surviving the grueling last few weeks and for all the efforts :)

Once again, Thank you every one and we promise to be back stronger, bigger and better next year!!! #sqlsat549

More photos of the event can be found here.  

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

Facebook Link: https://www.facebook.com/events/1748209662110411/

Meetup Link: https://www.meetup.com/mssgug/events/232752753/

Download Link for the Slides: here

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
 

SG SQL UG Meetup - June 2016

Date: June 23rd 2016

Agenda:

June 23rd - 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:15 - Topic 2 - Presentation by Sarbjit Singh Gill

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

Topic 1: SQL Server - Extended Events – Part1

Synopsis: Extended Event is a new method of collecting diagnostic data from SQL Server in a way that you could never get detailed information before using the previous features available. The presentation will talk about; how easily you can replace your existing SQL Trace file with extended events, why SQL Trace need be replaced. It will include in-depth two detailed demos

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:  Integrating SQL data into web platform such as SharePoint.

Synopsis: The topic will discuss on what are the possibilities of making your data available to users via a platform such as SharePoint (both SharePoint Online and on-premises). The idea behind this is to be able to take data out, run thru a business process system and integrate with other data.
It is useful for a SQL DBA to understand how his/her data will be used. This is just one of the methods of this data is used.

Speaker Profile: Sarbjit Singh Gill

I bring 24 years of IT experience spanning consulting, architecture and training for Microsoft technologies such as Lync, Exchange, SQL Server, SharePoint, Windows Server, Active Directory, System Center range of products. I am also experienced in carrying out a Microsoft IO (Infrastructure Optimization) and Implementation of the MS MOF (Microsoft Operations Framework).

Since 2005, I have been a Microsoft Most Valuable Professional (MVP) with Technical Expertise in Lync, SCOM and SharePoint.

I have participated as a speaker and proctor in numerous conference and forums and co-authored a book on MS Exchange monitoring using SCOM. As a MVP, I am founder of Singapore Lync User Group and an active member of other MS Technologies User Group communities. 

I hold a FIA International "C" racing license and I race actively in Japan and Malaysia in touring cars endurance and club races.

I am an active Scuba Diver with interest in underwater videography.

Facebook Link: https://www.facebook.com/events/512319095634632/

Meetup Link: http://www.meetup.com/mssgug/events/231960728/

Download Link for the Slides: here