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