Data Platform Day, Hyderabad – February 20, 2016, Saturday at Microsoft

Sponsored By:
SQLM_MC_add_on_SSG_event_page (1)
Event Details:
Event Type Free In-Person Event (Full Day)
Lunch Lunch will be available for attendees
Session 1 Tips and Tricks to Fix SQL Connectivity Issues

In the session, we are focusing on troubleshooting connectivity issues with SQL Server. We will cover the basics of connectivity troubleshooting and use the Netmon tool to debug the troubleshooting issues.

  • Network protocols
  • Few Common scenarios: Case Studies
  • Analyzing connectivity issues with Netmon tool

Speaker: Don Rohan Castelino (Microsoft)

Session 2 Multidimensional Modelling – I’m Not Dead Yet!

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 3 SQL Server Cardinality Estimation

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 4 A Glance at R’s Integration in SQL Server 2016
  • Brief Introduction – What’s so exciting about this integration?
  • Approaches of calling R in SQL Server
  • Some of the common R functions illustrated with SQL Server integration
  • Demo of a Scenario using R’s integration in SQL Server

Speaker: Muthukumaran Arumugam (Microsoft)

Session 5 Resource Governor for IO

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/Location Hyderabad
Date & Time Saturday, 20 February 2016
10.00 am to 6.00 pm
Note: Come by 9.30 am for registration and security formalities. Please be seated by 10.00 am.
Venue Microsoft India PVT LTD,
AG-MPR-001 (96) VTC, Building – 3,
Survey No 210, Microsoft Campus,
Manikonda Jagir, Gachibowli
Hyderabad – 500032
Parking Parking is available inside the campus.
Registration Click here to register

 
 
Register Now  
 

Do you want to be notified of future events? Click here

 

Advertisement

MC_add_on_SSG_event_page