EDMPASS is a not-for-profit association that organizes events to promote knowledge sharing, to exchange ideas, and to unite Edmonton's SQL server professionals.

EDMPASS - Professional Association for SQL Server Edmonton Chapter, Edmonton SQL Server User Group



Next Meeting: Thu, Dec 11 2014

EDMPASS Dec-2014 Meeting with Mohit Gupta (Microsoft)

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.ca/e/edmonton-sql-server-user-group-dec-2014-meeting-with-mohit-gupta-microsoft-tickets-13932521547


5:30 pm - Food and socializing

5:45 pm - Group announcement - Harry Zheng

6:00 pm - Feature Presentation -  Mohit Gupta

7:00 pm - Round Table & Networking

8:00 pm - Wrap up  


UTC : Fri, Dec 12 2014 00:30 - 03:00
Event Time : Thu, Dec 11 2014 17:30 - 20:00 (GMT-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Dec 12 2014 00:30 - 03:00


10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room
Edmonton, Alberta
Direction: None

Featured Presentation

SQL Server 2014 In-Memory OLTP

Speaker: Mohit Gupta, SQL Server – Premier Field Engineer Microsoft

Summary: Microsoft SQL Server 2014 introduced new In-Memory OLTP Engine for improving the performance of OLTP workload, code named Hekaton. In this discussion we will look at the overview of what In-Memory OLTP means, how does it impact our current workloads? In addition how can we implement it and what changes you need to think about going forward in order to make effective use of it? In addition to this, we will also look at the configuration and some of the basic troubleshooting techniques you will need to be aware of when implementing In-Memory OLTP.

About Mohit: My background is development, from University, to Graduate Studies, I delved in most major languages and I do truly enjoy development. When I finished my under graduate degree and was hired as Developer for Microsoft Access. I had opportunity to manage and using SQL Server 6.5 as my SQL Server RDBMS. This was back in 2005, I didn’t think must off it. However as time went on, I had further opportunities to get more involved in SQL Server, to becoming Backup DBA. So I had chance to learn SQL Server 6.5 and SQL Server 2000. While working on these I quickly learned there was a lot more to SQL Server then meets the eyes. It is not simple, “install and forget it” application. Around 2006 or so, I was having lots of performance issues with an application in SQL Server 2000, I tried to do all the right things around resource consumption and performance monitoring. However couldn’t resolve the performance issues, so my organization at that time brought a CTS engineer down to help us out. I worked with the CTS engineer for an entire week, that’s when I learned what it was really meant to be SQL Server DBA. Thus started my journey on becoming truly SQL Server DBA. Since 2006 to until now, I have studied SQL Server diligently and absolutely love the product and is my passion. Now working as SQL Server PFE for Microsoft Canada (for almost 4 years), focusing on Database Engine. I have to say has been truly an enlighten experience, I have learned so much more about SQL Server as I traveled across Canada and parts of USA. I think I have visited some 80 different customer sites dealing with different issues and questions. I focus my efforts in HADR (Clustering, AGs, and DB Mirroring) and Performance Tuning for SQL Server.