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
 

Tuesday, September 13, 2016

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 SethiPrakash 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 RockerManjuke FernandoVikash RaiMohit Niranwal, Abhishek Patel, Anand RajAlvin 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 DaveVinod Kumar MDenny CherryJoey 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 KeshariKhilitchandra PrajapatiSarbjit 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.  

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

 

Saturday, June 25, 2016

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.
Download Link for the Slides: here

Monday, June 20, 2016

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
SQL Server 2016 – The Evolution of In-Memory Technologies
Secrets of SQL Server - Database Worst Practices
Security with SQL Server - Things you never knew
Know What Your Code is Doing to SQL Server!
Data Warehouse load performance with SSIS and SQL Server
Data Storage and Analytics with Azure Data Lake
Creating High Performance Tabular Models
Bleed Blue for the clouds – SQL Azure
Think & work like a Data Scientist with SQL 2016 R
Automated and Repeatable Test Cases for SQL Server Development.
Index Internals
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
 

Sunday, June 5, 2016

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.

Saturday, June 4, 2016

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

Wednesday, May 25, 2016

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
Download link for the slides: here

Thursday, April 28, 2016

SG SQL UG Meetup - Apr 2016

Date: April 28th
Agenda:
April 28th - 6:45 PM to 7 PM - Registration and Snacks
7 PM to 8 PM - Topic 1 - Presentation by Matt Hitchcock
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, Conf Room SINOMB 22CF-12
Topic 1: Deploying SQL Clusters in Azure: Tales from the field
Synopsis: As more workloads move to the cloud, some workloads still have a requirement to run their databases on non-PaaS SQL servers. Cloud does not automatically mean Always On and Highly Available, so the requirement for Clusters is alive and well! In this Tales from the Field, Matt talks about implementing SQL Clusters in Azure as part of a production project for a high profile customer. We will cover why Clusters were required in the first place, how we approached the planning (networks, backup, VM Sizes, HA, etc.), what implementation steps were involved, where we got help, lessons we learned and most importantly; how we would do it differently if we had to do it today! This is what we learned along the road of a project that Satya himself has been tracking ... Don't screw up!!

Speaker Profile: Matthew Hitchcock
Matthew, a Microsoft MVP, has deep experience of Identity & Directory Services including Hybrid Identity for Cloud. He now specializes in Microsoft Azure and currently works at Microsoft Services, helping customers to automate their operations, start dealing with Infrastructure-as-Code and to adopt Cloud solutions.

Topic 2:  Optimizer's choice of Indexes
Synopsis: Indexes are perhaps the key parameter in deciding the performance of a query. Hence, understanding how an index is picked by query optimizer becomes extremely vital performance tuning. The presentation would explain how optimizer choses an index at diferent scenarios discussing the reasons for optimizer's choices. Session would be a Demo driven one, driving home the importance of designing optimizer friendly indexes. 
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, April 20, 2016

Singapore SQL Saturday 2016 - Tracks and Schedule !!!

Dear All,

We are very happy to announce that we will be organizing 1st ever SQL Saturday event in Singapore on August 20th 2016. SQL Saturday events are a day long technical seminar / conference with top class speakers from across the globe will be providing technical content of excellent quality. For registering for the event, go to http://www.sqlsaturday.com/549/eventhome.aspx


Tracks and the tentative schedule have been announced below. 

Tracks and Schedule




We have 2 types of sessions. They are

1) 60 minute regular sessions
2) 90 minute deep dive session

90 Minute sessions are the in depth technical sessions at level 400 / Advanced levels. We plan to have atleast one deep dive advanced session per track, while the rest of the sessions would be on intermediate level. If you are interested in submitting a abstract, please click here

If you have any feedback / questions, please email to sqlsaturday549"at"sqlsaturday.com

Tuesday, March 22, 2016

SG SQL UG Meetup - Mar 2016

Date: Mar 17th
Agenda:
Mar 17th - 6:45 PM to 7 PM - Registration and Snacks
7 PM to 8:15 PM - Topic 1 - Presentation by Edwin Sarimento
8:15 PM to 8:30 - Break
8:30 PM to 9:30 - Topic 2 - Presentation by Martin Catherall
Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15 (24) AV

Topic 1: 5 Things To Consider: Stretching SQL Server Failover Clustered Instances and Availability Groups to Microsoft Azure
Abstract : Dealing with SQL Server Failover Clustered Instances and Availability Group for local high availability is already complicated with a lot of the external dependencies such as the network and the Windows Server Failover Cluster (WSFC.) But it becomes even more complicated when you stretch it out for disaster recovery to Microsoft Azure. In this session, learn the five (5) things that you need to consider when you implement SQL Server Failover Clustered Instances and Availability Group for disaster recovery into Microsoft Azure. We will cover how Active Directory, DNS, WSFC heartbeat and quorum configuration affects deployments of SQL Server Failover Clustered Instances and Availability Group in a disaster recovery site and how to properly configure a client application for connectivity.
Speaker Profile: Edwin Sarimento
Edwin M. Sarmiento is the Managing Director of 15C, a consulting and training company that specializes on designing, implementing and supporting SQL Server infrastructures. He is a  Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology but has interests in music, professional and organizational development, and leadership and management matters when not working with databases. Edwin lives up to his primary mission statement: "To help people and organizations grow and develop their full potential."

Topic 2:  A Lap around Columnstore
Abstract : Columnstore indexing was first introduced in SQL Server 2012, however it was not widely adopted.SQL Server 2014 added additional functionality to columnstore which resulted in a marginally higher uptake. The initial versions required some creative thinking to get all of the promised performance gains out of the technology. Now, SQL Server 2016 enhances this functionality greatly and it’s all set to become mainstream. Columnstore promises significant performance gains for datawarehouses along with operational analytics. This presentation will look at many of the new features in columnstore as well as briefly look at some of the internals and give the audience some insight into how they can leverage its potential.

Speaker Profile: Martin Catherall
Martin is a RockSolid SQL consultant, a SQL Server MVP, PASS Regional Mentor for the Asia Pacific (APAC) region and until recently leader of the Christchurch, New Zealand SQL Server User Group. Now based in Melbourne, he’s getting to know the Australian SQL community. He has been using SQL Server in various roles since 2000. In addition to anything data related be enjoys playing the guitar and having fun with his family.
Download link for the slides: here