Singapore SQL Server User Group - July meetup

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

Speaker: Mr. 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 (http://strictlysql.blogspot.com/) and a regular contributor/ visitor at sqlservercentral.com (http://sqlservercentral.com/). Besides these, I hold a Masters Degree in Computing from National University of Singapore

Topic: "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 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.

-----------------------------------------------------------------------------------

Venue: As shown below.
Level : 22
Room : Conf Room 22CF-12