Azure SQL Database team at Data Platform Summit 2018

clip_image002[4]Azure SQL Database Engineering Team (@azuresqldb) represented by (Ajay Jagannathan, and Sunil Agarwal) will be speaking at Data Platform Summit 2018 (#DPS10), Asia’s Premier Data & Analytics Conference taking place on August 9-11 in Bangalore, India. Data Platform Summit 2018 is a full 3-day conference with more than 100 breakout sessions, open talks, chalk talks and deep dive pre-con sessions.

Additionally, our colleagues from Data Migration team represented by (Sudhakar Sannakkayala, Raj Pochiraju and Nikhil Patel) will showcase new migration tools and services to help you get to Azure faster and without friction.

This is a truly unique conference (see video below), comprising multiple tracks on topics covering Data Science, Database Administration, Database Development, Business Intelligence & Analytics, Cloud, IoT & NoSQL, Big Data & Open Source, and related technologies. The summit attracts data platform experts from around the globe. DPS 2018 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.

Through several breakout sessions, chalk talks and open talks (see schedule below) we will talk about new features and enhancements in Azure SQL Database (including Managed Instance), Azure Database for MySQL and PostgreSQL, and provide deep-dive into internals of these features to help you build your business applications. Additionally, if you are looking to upgrade, migrate or modernize your data platform (no matter what your source platform is), we will showcase several new Data Migration tools and services that will make these efforts seamless.

Are you looking to modernize your business on Azure data platform? Then this is a conference you must attend and hear from the experts. You will also have several opportunities to meet and interact with our team at the conference.

Date Time Speaker Session Title Abstract
9-Aug 11:00 – 12:15 Ajay Jagannathan / Sudhakar Sannakkayala Modernize your data estate on Microsoft’s Azure Relational Database Platform (Azure SQL Database, PostgreSQL, MySQL Azure Relational Database Platform- Microsoft’s fully managed, database-as-a-service offering solves the demands of today’s data estate involving omnipresence, heterogeneous and explosion. Built on world’s top relational database management system, SQL Server, as well as popular Community Editions of OSS databases PostgreSQL and MySQL, the platform offers multiple choices to our customers to meet their data needs – it consists of three options of Azure SQL Database (singleton, elastic pools and managed instances) as well as Azure Database for PostgreSQL and MySQL. In this session, you will learn about the latest innovations in Microsoft’s Azure relational database family and how customers are using this to modernize their applications in a number of ways, from simply re-hosting applications and corresponding databases to Azure to refactoring or in some cases re-architecting the application stack in order to take full advantage of the benefits of our managed services in the long run. Our most recent version of Azure SQL Database, PostgreSQL and MySQL combines advanced intelligence, enterprise-grade performance, high-availability, and industry-leading security in one easy-to-use database. Thanks to innovations such as In-Memory OLTP, Columnstore indexes, and our Intelligent Query Processing feature family, customers can rely on Azure Relational Database for their relational data management needs, from managing just a few megabytes of transactional data to driving the most data-intensive, mission-critical applications requiring advanced data processing at global scale. You will also learn how to quickly and seamlessly migrate and modernize your datacenter to the cloud with Azure Database Migration Service.   With Microsoft’s Azure Relational Database Platform, you can focus on your business and leave the rest to us. Key Learning: 1. New offerings in Azure Relational Database Platform such as Managed Instance, PostgreSQL and MySQL 2. Capabilities provided by the new services 3. Simplified migration of database and applications from on-premise datacenter to Azure Demos: Migration of databases from on-prem to Azure SQL Database Managed Instance, PostgreSQL and MySQL
9-Aug 13:50 – 14:20 Raj Pochiraju / Mukesh Kumar Deep dive to Azure Database Migrations (DMS) service architecture Chalk-Talks are 30 minutes’ sessions focusing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!
9-Aug 15:15 – 16:30 Raj Pochiraju / Nikhil Patel Migrating to Azure: Moving from on-premises SQL Server and Oracle databases to Azure Azure SQL Database and Managed Instances allows you build globally scalable applications with extremely low latency.  Azure SQL Database is the best cloud database offering in market. In this session, we will take a detailed look at the migration life cycle and show you how we have made it easy to migrate SQL Server and Oracle instances to Azure by using the Azure Database Migration Service and related tools. We will also cover most commonly seen migration blocking scenarios and demonstrate how our service can unblock your migration to Azure SQL Databases. We will give you a deep dive how to perform scale migrations using our CLI components. After completing the session, you will understand how easy it is to migrate from SQL Server and Oracle to Azure database platforms when empowered with the right tools, services, and best practices. We will also showcase lift and shift migrations from open source databases MySQL and PostgreSQL to our Azure Database platform. Key Learning: 1. You get proficient with our new DMS service, use in your upcoming upgrade/migration projects. 2. You will be able to pinpoint breaking and behavior changes and deprecated features upgrading to Azure SQL Database. 3. Execute the end-to-end database migration seamlessly, includes schema and data Demos: 1.  Migrating databases from SQL Server and Oracle to Azure SQL Databases and Managed Instances using our DMS service 2. Migrating databases from Oracle to Azure SQL Databases. 3. Perform  minimal downtime migrations to Azure using DMS service. 4. Perform minimal downtime migrations from MySQL to Azure Database for MySQL using DMS 5. Perform scale migrations using our DMS CLIs.
9-Aug 12:25 – 13:40 Sunil Agarwal Strategies to certify your SQL Server application in the Cloud era Application certification requires extensive testing for functional correctness, performance and scale that can take few weeks to months. Many IT organizations are struggling in managing legacy applications certified on older versions of SQL Server. Now, with the frequent releases of SQL Server and the advent of Azure SQL Database, many application vendors (ISV) and even custom developed application owners are challenged to minimize the effort required for application certification but still enabling customers to run the application on the latest SQL Server version or in SQL Azure Database. Come to this session to learn a new way to certify your application on SQL Server in a version agnostic way. Key Learning: Database compatibility level has been supported in SQL Server for a long time  as a way to simplify database upgrade to new version of SQL Server.  We will show how you can leverage DBCompat and the DMA tool to certify your application in SQL Server version agnostic way. Demos: Demo show casing (a)  DMA tool on assessing the source database that can be upgraded to SQL Server 2017  (b) a source  database that can’t be upgraded to SQL 2017 due to functional incompatibilities
10-Aug 10:30 – 11:45 Ajay Jagannathan Deep Dive into Azure SQL Database Managed Instance Azure SQL Database Managed Instance is a new capability of Azure SQL Database, providing near 100% compatibility with SQL Server on-premises (Enterprise Edition). Managed Instance allows you to fast track your existing SQL Server workloads to the cloud through lift and shift of on-premises applications with minimal application and database changes. In this session, we will deep dive into various capabilities of Managed Instance through demos covering how to provision, scale-up/down, point-in-time restore, linked servers, SQL Server Agent and SSIS ETL using ADF which are otherwise not possible in single/pools deployment options of Azure SQL Database.
11-Aug 11:30 – 12:45 Ajay Jagannathan Azure SQL Database – the intelligent cloud database on autopilot that lets you focus on your business Azure SQL Database is Microsoft’s fully managed, database-as-a-service offering based on the world’s best relational database management system, SQL Server. It consists of three deployment options – managed singleton database, managed elastic pools and managed instances that will help you with your data estate modernization. In this session you will see how Azure SQL Database, uses machine learning and best practices to ensure your database is always performing at its best. In this session you will learn about features like Adaptive Query Processing, Auto-tuning and Performance Recommendations, to see how Azure SQL Database can help you spend more time developing applications and less time managing your databases. You will also learn about new security features like Vulnerability Assessment, Information Protection, Thread Detection and Always Encrypted to see how Azure SQL Database is securing your data in the most secure database on the planet. With Azure SQL Database, you can focus on your business and leave the rest to us. Key Learning: 1. Learn how performance capabilities such as Adaptive query processing, auto tuning and performance recommendations help alleviate common database administration headaches 2. Learn how to easily secure your database using features like Vulnerability Assessment, Information Protection, Threat detection and Always Encrypted. Demos: 1. Auto tuning 2. Performance recommendations 3. Vulnerability Assessment 4. Information Protection 5. Always Encrypted
11-Aug 12:15 – 12:45 Sunil Agarwal Clustered Columnstore Index: How did I scale dataload for IOT scenario Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A
11-Aug 14:30 – 15:45 Sunil Agarwal Maximizing the Query Performance with Columnstore Indexes in SQL Server Columnstore index can speed up the performance of analytics queries significantly but are you getting the best performance possible? Come to this session on to learn 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. Familiarly with columnstore index is required. Key Learning: Most people know that columnstore index can deliver significant query performance boost but many don’t realize that they are not getting the optimal performance possible. This session will allow attendees to learn how to diagnose the query performance and take steps to fix it Demos: Demo heavy session. I present 5 common issues that lead to poorly performing queries on columnstore index and then show how you can diagnose and fix it. One demo per query performance scenario