Monday, July 27, 2015

Singapore SQL Server User Group - July 2015 meetup

Dear All,

Singapore SQL Server User Group came back to life after few years of no activity, in July 2015.  The event details and slide decks attached for your reference.

Date : Jul 24, 2015 · 6:30 PM
Venue : Microsoft Singapore, One Marina Boulevard

Topics for 24th July: Hekaton - in memory tables and SQL AlwaysOn.

Speaker: Nagaraj Venkatesan

About speaker: I am Nagaraj, a SQL Server enthusiast exploring SQL Server for the last 10 years. Working for NCS Pte Ltd as SQL Server DBA, I maintain databases used by one of the busiest public facing applications in the city. I blog at strictlysql.blogspot.com and a regular contributor/ visitor at sqlservercentral.com. Besides these, I hold a Masters Degree in Computing from National University of Singapore

Topic: Hekaton - "In memory tables"
Abstract:  "Hekaton - In memory tables" introduced in SQL Server 2014 is a game changer in database performance especially in OLTP systems. The presentation would cover the major architectural changes on "In memory tables", compared to traditional disk based tables, on concepts like transaction processing, indexing and storage structures and how "In memory tables" can help one achieve performance gain in OLTP systems. Besides these, the presentation would also discuss pros and cons of "In memory tables", for whom it suits and whom it doesn't , key prerequisites and things to consider before migrating to "In memory tables".

Speaker: Pio Riva Balistoy
About Speaker: 
Pio has more than a decade of DBA experience. He was a Team lead for Accenture CIO Global DBA Team before moving to Singapore to work for Dupont and Resorts World Sentosa. He is currently a Lead Database consultant for Pythian, a global IT Services company that specializes in database technology.  


Topic: AlwaysOn Availability Group

Abstract: AlwaysOn Availability Group were introduced in SQL Server 2012. The session aims to give an quick guide on Availability Groups, what it is, its usage, its components and how to configure it. It will also give an update on the changes/improvements in the succeeding versions.

Meetup URL : http://www.meetup.com/mssgug/events/223886483/
Facebook Event Page: https://www.facebook.com/events/881981941836824/

Slides: Download the Slide Decks here