Actions Panel

Data Platform Day, Gurgaon – March 5, 2016, Saturday at Microsoft (Full Day)

When and where

Date and time


Microsoft Corporation (India) Pvt Ltd Level 10, Tower C, DLF Epitome – Building No. 5 DLF Cyber City, Phase III Gurgaon, 122002 India

Map and directions

How to get there


[Note: Please make sure you provide correct email id. In case, the event is modified/cancelled, we will notify by email]

Data Platform Day, Gurgaon – March 5, 2016, Saturday at Microsoft (Full Day)

Lunch: Lunch will be available for attendees

Dear SQL Geek, cordially invites you to next dose of Data Platform Day (Full Day) on 5 March 2016 (Saturday) at Microsoft Gurgaon from 10.00 am to 6.00 pm. This is a free community event.

Session details are as follows:


Session 1: Leveraging Microsoft BI Solution for Data Insights

Abstract: This session will cover integrated view of redefined Microsoft BI platform Strategy to cover integrated view of entire suite of capabilities. This will cover how Microsoft solution can help you deliver superior capabilities while leveraging both on-premise and cloud offerings.

Speaker: Aneek Arora (Microsoft)

Session 2: SQL Server Cardinality Estimation

Abstract: In this level 400 session, you will understand how the SQL Query Optimizer produces those awesome execution plans. The demo packed session will show the you the magic and complexity behind cardinality estimator of SQL Server.

Speaker: Amit R S Bansal (SQLMaestros)

Session 3: Multidimensional Modelling - I'm Not Dead Yet!

Abstract: MOLAP is in the market since SQL Server 2000 and is by far the most use OLAP product to date. With the introduction of Tabular model, people believed this myth that MOLAP is history. In this one hour demo heavy session, we'll learn to model data with MOLAP. We'll learn to define data sources, dimensions, attributes, relationships, hierarchies and cubes with SQL Server Data tools. MOLAP is very much alive!!!.

Speaker: Ahmad Osama (SQLMaestros)

Lunch Break: Lunch Break

Session 4: In-Memory Database Technologies

Abstract: Apart from the SQL Server In-Memory capability and when and why we should migrate will also share the competitive landscape.

Speaker: Rahul Dutta (Microsoft)

Session 5: SQLServer Wait Stats – A Magical Wand to Solve Performance Issues

Abstract: Are you facing performance issues? Struggling to find the root cause of the delay? Don’t know where to start diagnosing? If yes, then SQL Wait Statistics is the answer to most of your problems; this works like magic and tells you what’s going wrong. The best part is SQL Server knows about the performance issue and the underlying cause, it’s just that we need to ask SQL and understand its language. Come and join this session where Sarabpreet Singh will help you learn this trick.

Speaker: Sarabpreet Singh Anand (SQLServerGeeks)

Session 6: Things That You Don’t Know About SQL Server

Abstract: An un-miss-able session, Prince Rastogi will show you a few very interesting aspects of SQL Server database engine that Google cannot find for you :)

Speaker: Prince Rastogi (SQLServerGeeks)

Session 7: Resource Governor for IO

Abstract: Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. In prior releases, there have been incremental enhancements to this feature. SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, Microsoft Certified Master Amit Bansal will demonstrate how to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQLServer:Resource Pool Stats.

Speaker: Amit R S Bansal (SQLMaestros)


City: Gurgaon

Date & Time: Saturday, 5 March 2016 10.00 am to 6.00 pm

Venue: Microsoft Corporation (India) Pvt Ltd, Level 10, Tower C, DLF Epitome – Building No. 5, DLF Cyber City, Phase III Gurgaon 122002

Parking: Microsoft Office is next to Metro station. There is parking facility available around the metro station

Note: Come by 9.30 am for registration and security formalities. Please be seated by 10.00 am.

We look forward to your participation. Please forward this email to your friends & colleagues to make them aware of the event. Your efforts in spreading the word will be highly appreciated.

Join the fastest growing SQL Server facebook group :

Thanks & Regards

Follow us on facebook at

Follow us on twitter at

Note: By registering at the event, you agree to hear from our sponsors and supporters.

Note: By registering for this free event, you automatically subscribe to our Newsletter. You are free to unsubscribe in case you do not find our newsletters valuable.

Advertisement: Do you know about SQLMaestros Master Classes & Master Symposiums?