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

SQL Saturday Singapore 2016 - Speaker List

Dear All,

We are extremely happy to announce our list of speakers for the first ever SQL Saturday Event in Singapore!!!

Topic	Speaker
SQL Server 2016 Stretch Database: top to bottom	Joe Young
SQL Server 2016 – The Evolution of In-Memory Technologies	Andreas Wolter
Secrets of SQL Server - Database Worst Practices	Pinal Dave
Security with SQL Server - Things you never knew	Vinod Kumar
Know What Your Code is Doing to SQL Server!	Kevin Boles
Data Warehouse load performance with SSIS and SQL Server	David Peter Hansen
Data Storage and Analytics with Azure Data Lake	Glenn Morris
Creating High Performance Tabular Models	James Beresford
Bleed Blue for the clouds – SQL Azure	Krishna Deepak
Think & work like a Data Scientist with SQL 2016 R	Subramani Paramasivam
Automated and Repeatable Test Cases for SQL Server Development.	Stefan Riedel
Index Internals	Denny Cherry & Joey D'Antoni
To Be Announced	Dharmendra Keshari
To Be Announced	Khilitchandra Prajapati
To Be Announced	Sarbjit Singh Gill

A terrific line up of world class speakers and interesting topics indeed!!! Great opportunity for the Singapore SQL Community to learn, network and interact with the stalwarts of SQL World. Go ahead and register for the event at https://www.sqlsaturday.com/549/registernow.aspx
 

SQL Saturday Singapore 2016 - Speaker Announcement - Vinod Kumar

Dear All,
 Here we go for the second speaker announcement for SQL Saturday Singapore.

 We are very proud to announce, Vinod Kumar from Microsoft, India as the second speaker of the first ever "SQL Saturday” event @ Singapore. Vinod Kumar has worked with SQL Server extensively since joining the industry over more than 17 years back. Working on various versions from SQL Server 7.0, Oracle 7.3 and other database technologies - he now works with Microsoft Technology Center (MTC) as Technology Architect. With extensive database, BI and application background, he currently helps customers maximize on the investments on technologies to solve real world business and technology integration problems. Speaker in major conferences like TechEd India (12 yrs.), TechNet, MSDN, Azure Conference etc.

Vinod will be delivering a session on the topic “Security with SQL Server - Things you never knew” for our event.
On behalf of Singapore SQL Server Pass chapter, we extend a very warm welcome to Vinod Kumar.

 It is golden opportunity for Singapore SQL Community to gain in depth technical knowledge directly from an expert from Microsoft. A chance surely not to be missed. Go ahead and register ASAP at https://www.sqlsaturday.com/549/registernow.aspx. Do signup for lunch and snacks which comes at a nominal fee of S$ 12. Attendees signing up for lunch, get a complementary T shirt and are also eligible for other freebies too. Please support our event by signing
up for lunch. Thanks!!!

 Regards,
 Singapore SQL Pass Chapter – Singapore SQL Saturday organizing committee.

SQL Saturday Singapore 2016 - Speaker Announcement - Joe Yong

Dear All,

Here we go for the first big announcement of SQL Saturday Singapore 2016.

We are very proud to announce, Joe Yong as the first speaker of our first ever "SQL Saturday Singapore" . Joe Yong is a Senior Program Manager from Microsoft Corporation, Redmond managing Stretch SQL feature of SQL Server 2016.Joe Yong will be delivering a deep dive 90 minute session on the topic "SQL Server 2016 Stretch Database: top to bottom".
On behalf of Singapore SQL Server Pass chapter, we extend a very warm welcome to Joe Yong.

It is golden opportunity for Singapore SQL Community to gain in depth technical knowledge directly from Microsoft Product Team experts. A chance ought not to be missed!!!!. Go ahead and register ASAP at https://www.sqlsaturday.com/549/registernow.aspx. Do signup for lunch and snacks which comes at a nominal fee of 12$. Attendees signing up for lunch, get a complementary T shirt and are eligible for other freebies too. Please support our event by signing up for lunch. Thanks!!!
Regards,
Singapore SQL Pass Chapter – Singapore SQL Saturday organizing committee

SG SQL UG Meetup - May 2016

Date: May 19th

Agenda:

May 19th - 6:45 PM to 7 PM - Registration and Snacks

7 PM to 8 PM - Topic 1 - Presentation by Senthamil Selvan

8:00 PM to 8:15 - Break

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

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

Topic 1: Data Access & Storage Options in Universal Apps

Synopsis: Managing data is a critical part of app development. Whether it’s a game, news, travel or fashion app, it’s always all about the data. I’ll discuss the various data storage options and data access APIs available for building Universal apps, as well as data management strategies for both content and configuration.

Speaker Profile: Senthamil Selvan

Senthamil Selvan is awarded as Microsoft MVP in Windows Development. He has 11+ years of experience in Microsoft Platform including Windows Forms, SharePoint and Universal Apps development. He has published several Windows Apps in the Store - 8 Windows Phone and 5 Windows Store Apps.

Topic 2:  SQL Server 2016 - Real Time Operational Analytics - "Real" Game changer

Synopsis: Performing analytics on operational data has all along being a huge challenge for applications, due to its impact on regular operations and day to day transactions. SQL Server 2016 has extended its analytic capabilities by its enhancements on "In memory tables" and Columnstore indexes.SQL Server 2016 columnstore index enhancements is a boon for performing analytics on operational data with no impact to regular workload, with no delayed data, no complex ETL tasks and without a need to maintain separate data warehouse.

The presentation would cover how "In Memory" Columnstore indexes help to perform real time operational analytics and would involve interesting demos show casing the gains using SQL Server 2016 "In Memory" and Disk Column Store Index enhancements.

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/1760829100816315/

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

Download link for the slides: here