This is a truly unique conference (see this video), comprised with multiple tracks on Database Management,Database Development, Business Intelligence, Advanced Analytics, Cloud, and Big Data. The summit attracts data platform experts from around the globe. DPS 2017 is the only Data/Analytics event in  Asia where product teams from Microsoft’s Data Group fly down from Redmond to deliver advanced sessions on the latest technologies. 

Day

Start Time

End Time

Room

Speaker

Session Title

Abstract

Day 1 - 17th

10:45

12:00

SHILOH

Nikhil Patel / Sudhakar Sannakkayala

DBA_B60 - Intermediate - Unleash Your Data From Oracle With A Move To SQL Server And Azure Sql Database

Abstract: Customers want to move their data from Oracle and other non-Microsoft databases to SQL Server and Azure SQL Database, but they don't have details about the right methods, best practices, and tools, which creates a barrier to pursuing such migrations. In this session, we will review the migration life cycle in detail and provide prescriptive information about how to migrate your Oracle databases to Azure by using Azure Database Migration Service and related tools. We will cover some common migration scenarios and customer case studies that we have assembled based on learnings from our preview and other field engagements with large enterprises. We will also share our roadmap, which will help you plan your enterprise database migrations.
Key Learning: After completing this session, you will know just how easy it is to migrate from Oracle to SQL Server and Azure SQL Database when you are empowered with right tools and services, and best practices to use during the process.

Day 1 - 17th

11:30

12:00

KILIMANJARO

Amit Banerjee

CLOUD/IoT/NoSQL_C13 - Running Applications On Azure Using Postgres/MySQL

Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!

Day 1 - 17th

12:15

13:30

YUKON

Parikshit Savjani

DBA_B61 - Advanced - Upgrade To SQL Server 2017: Intelligent Diagnostics Just Built-In

Abstract: SQL Server 2016 and SQL Server 2017 Just Works! But if you are a IT Professional you want to be armed with all the right diagnostics to react to a mission critical problem or tune the engine to the needs for your business. Dev-Ops also requires the right tools to build and tune queries for maximum performance. SQL Server 2016 and 2017 have all the diagnostics you need just built-in to the product. These are the foundation for great tools from vendors such as SentryOne, RedGate, SolarWinds, and Idera. We also have intelligence built-into the engine based on these diagnostics to automate, learn, and adapt. In this session we will show you the wide variety of these diagnostics with testimonies from vendors and SQL MVPs. You will learn why SQL Server diagnostics are the best in the industry, built-in, and spans all platforms across SQL Server, Azure, and Linux
Key Learning: 1. Understand the breadth and depth of built-in diagnostic choices that exist for SQL Server, Azure SQL Database, and SQL Server on Linux. 2. Hear customer case testimonies and evidence from ISV tool vendors, SQL MVPs, and Microsoft Premier Field Engineering and Support Engineering on how these diagnostics make them successful. 3. Learn new capabilities in SQL Server 2016 and 2017 that provide intelligence based on built-in diagnostics to automate and adapt reducing total cost of ownership and increasing dev-ops and IT efficiency.
Demos: Demos on Smart diagnostics introduced in SQL Server 20162017

Day 1 - 17th

13:45

15:00

HYDRA

Amit Banerjee

BIA_B02 - Advanced - Building 1 Million Predictions Per Second Using SQL-R

Abstract: Using the power of OLTP and data transformation in SQL 2016 and advanced analytics in Microsoft R Server, various industries that really push the boundary of processing higher number of transaction per second (tps) for different use cases. In this talk, we will walk through the use case of predicting loan charge off (loan default) rate, architecture configuration that enable this use case, and rich visual dashboard that allow customer to do what-if analysis. Attend this session to find out how SQL + R allows you to build an "intelligent datawarehouse".
Key Learning: Deploying solutions using R with SQL Server
Demos: Demo of 1 million transactions/sec

Day 1 - 17th

15:30

16:45

HYDRA

Ajay Jagannathan / Sudhakar Sannakkayala

DBA_B44 - Intermediate - Digitally Transform Your Business Through Migration And Modernization Of Your Data To SQL Platform Of Your Choice

Abstract: Today’s organizations must adapt quickly to change, using new technologies to fuel competitive advantage, or risk getting left behind. Organizations understand that data is a key strategic asset which, when combined with the scale and intelligence of cloud, can provide the opportunity to automate, innovate, and increase the speed of business.
Be it SQL Server, Azure SQL Database or Azure SQL Database Managed instance, learn how to migrate to any of these platforms easily using the Azure Database Migration Service and related tools. We'll cover various aspects of the migration lifecycle from assessment, remediation, data movement to validation and you will learn how easy it is to migrate and modernize your data platform when you are empowered with the right tools.
Key Learning: Learn various aspects of migration lifecycle.
Understand common issues encountered during a migration or modernization project.
Learn and use all the tools to make the migration experience smoother.
Demos: End to End migration

Day 1 - 17th

17:15

17:45

HEKATON

Ajay Jagannathan / Sudhakar Sannakkayala

DBA_O35 - How Do You Successfully Execute A Data Migration Project?

Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A

Day 2 - 18th

09:15

09:45

HEKATON

Tejas Shah

DBA_O48 - Non-Yielding Scheduler And Deadlocked Schedulers

Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A

Day 2 - 18th

10:15

11:30

SPHINX

Ajay Jagannathan

DBA_B43 - Advanced - Life In The Fast Lane With SQL Server In-Memory OLTP

Abstract: Learn how the "Hekaton" engine works behind the scenes to deliver the amazing 30x performance improvements seen for customers moving to In-Memory OLTP. This session will include a look behind the scenes at threads, data and index design, transactions and concurrency, logging, storage, and natively compiled procedures. We will go into detail with scenarios, architectures, and actual customer case studies.
Key Learning: Explain how in-memory OLTP works to deliver upto 30x performance gains.
Articulate the difference between SQL Server transactions and In-Memory OLTP transactions
Understand the value and key scenarios where in-memory OLTP can be leveraged for customer applications.
Demos: How to use in-memory OLTP
Debugging natively compiled stored procs
Inside in-memory checkpoint
Customer case studies

Day 2 - 18th

11:00

11:30

KILIMANJARO

Parikshit Savjani

DBA_C40 - Indirect Checkpointing – The Good, The Bad And The Non-Yielding

Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!

Day 2 - 18th

11:45

13:00

SPHINX

Amit Banerjee

CLOUD/IoT/NoSQL_B40 - Basic - Azure Database for MySQL and PostgreSQL

Abstract: Azure Database for MySQL and Azure Database for PostgreSQL are managed database services built for developers using the community edition of MySQL PostgreSQL. Learn how you can leverage these new choices of managed database services to build scalable, secure and intelligent apps. Using insights from current customer scenarios and through live demos, we walk through the service management capabilities, best practices to move your databases to the service, and also focus on how the Microsoft Azure ecosystem of app and data services is unlocking the potential of MySQL and PostgreSQL in the Azure cloud platform.

Day 2 - 18th

14:00

14:30

KILIMANJARO

Ajay Jagannathan

DBA_C28 - Understanding And Troubleshooting Latches And Spinlocks

Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!

Day 2 - 18th

15:30

16:00

KILIMANJARO

Tejas Shah

DBA_C55 - SQL OS Scheduling

Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!

Day 2 - 18th

16:30

17:00

HELSINKI

Parikshit Savjani

DEV_O54 - Data Loading Best Practices

Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A

Day 3 - 19th

08:45

10:00

HYDRA

Parikshit Savjani / Tejas Shah

DEV_B71 - Advanced - Gems To Turbocharge Your SQL Server Query Performance

Abstract: As DBAs and developers, you are often tasked to tune and optimize your queries for performance, better resource utilization and improve overall scalability of your workloads running on SQL Server.
In this session you will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance. Ranging from new xEvents to Showplan improvements, from LQS (and underlying infrastructure) to the revised Plan Comparison tool, learn how these can help you streamline the process of troubleshooting query performance and gain faster insights.
The target audience for the session could be any roles that want to learn what’s available to aid in SQL Server query troubleshooting space. That can be the developer that needs to squeeze every ounce of performance from his queries, to the DBA that has to understand the problem space of an ongoing performance issue.
Key Learning: The key takeaways from the session would be tips and tricks to tune your query performance to make it run faster on SQL Server
Demos: Demos of poorly written or performing queries and showcasing how to troubleshoot and tune query performance leveraging the improvements in recent version of SQL Server.

Day 3 - 19th

10:30

11:45

SHILOH

Tejas Shah

DEV_B79 - Intermediate - Improve Data Load Speed And Query Performance With Columnstore Indexes

Abstract: Is data load performance into columnstore slowing you down? Should you drop nonclustered indexes before loading data? What batchsize should you choose? How should you handle large number of Updates/Deletes? Columnstore index can speed up the performance of analytics queries significantly but are you getting the best performance possible? Come to this session to learn the best practices and the techniques customers have used to load data in parallel with minimal or reduced logging into columnstore index. Specifically, we will cover data load using BCP, Bulk Insert, SSIS or MERGE command, concurrent trickle insert in IOT scenario as well as moving data from staging table. We will also talk about how to diagnose performance issues in queries accessing columnstore index and the steps you can take to troubleshoot. Some of the techniques we discuss here are rowgroup elimination, statistics, partitioning, improving the query plan quality, tweaking the schema, and creating one or more nonclustered btree indexes.
Key Learning: Improving performance of analytics workload with columnstore indexes.
Demos: NA

Day 3 - 19th

10:30

11:00

DENALI

Akbar Farishta

DBA_C47 - Change Tracking and Enhancements in SQL Replication

Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!

Day 3 - 19th

12:00

13:15

SHILOH

Akbar Farishta

DBA_B45 - Intermediate - Real-time business insights using SQL Server 2016 distributed availability groups

Abstract: Real-Time Business Intelligence and analytics has today become to backbone for any business. The ability to analyze, report, take actions or make decisions on data as it gets generated is of significant importance. As more and more companies look to benefit from this, the traditional data warehousing approaches are no longer valid. There is an increasing need to report and analyze data right at its origin in the OLTP Systems. In this session we talk about how our customers used new SQL Server features to move from an inherently delayed classical data warehousing infrastructure to a near real time analytics solution. The session will focus on the following
1. Read Scale your SQL Server Deployments 2. Modernize your traditional data warehouse with distributed availability groups feature of SQL Server 2016 3. Scale deployments across different platforms
Key Learning: Usage of distributed availability groups to drive Real-Time Business Intelligence
Demos: Setting up distributed availability groups