Microsoft @ DPS 2020

Keynote

Rohan Kumar

Rohan Kumar leads the Azure Data engineering and product management organization for Microsoft. His team is responsible for the development of intuitive, world-class products and platforms that enable customers and partners to deliver the greatest insights from their data. Some of these products and solutions include the family of SQL Database services, Cosmos DB, Open Source databases, Azure Synapse Analytics, Azure Databricks, HDInsight, Azure Stream Analytics, Azure Data Factory, Cognitive Search and SQL Server.

We are thrilled to announce Rohan Kumar (Corporate Vice President, Microsoft Azure Data) as the Keynote Speaker of Data Platform Virtual Summit 2020. Learn about the key innovations in Microsoft Data Platform directly from the Azure Data Leadership.

Azure Data Gurukul

Get direct access to MS engineers and architects. Talk about your Azure Data projects and solutions and the real life challenges that you are facing. Learn innovative stuff about you favourite SQL Server, Power BI, Azure SQL, SQL on VM, Managed Instances, Azure Data Factory, Cosmos DB, Synapse Analytics and complete Azure Data stack. Just talk Data!

Azure Data Gurukul

Microsoft Training Classes

Checkout the full list of Training Classes & watch this video

Microsoft Training Classes

The Azure SQL Workshop

by Bob Ward (Principal Architect) & Anna Hoffman (Data & Applied Scientist)

Learn More


SQL Server: Advanced Training for Azure VM Deployments

by David Pless (Sr. SQL Program Manager), Pam Lahoud (Sr. Program Manager), Tejas Shah (Principal Program Manager),  Amit Khandelwal (Sr. Program Manager) & Aditya Badramraju (Sr. Program Manager)

Learn More


Deep Dive SQL Server Migration To Azure SQL

by Raj Pochiraju (Principal Program Manager) & Mukesh Kumar (Principal Group Engineering Architect Manager)

Learn More


Building Enterprise-Grade Data Pipelines Using Synapse Pipelines in Azure Synapse Analytics

by Abhishek Narain (Sr. Program Manager)

Learn More


Dashboard In a Day

by Sivakumar Harinath (Principal Group Manager)

Learn More


DAX In A Day

by Philip Seamark (Sr. Program Manager)

Learn More


Power BI Admin In A Day

by Kelly Kaye (Business Applications Customer Advisory Board Lead)

Learn More


Power BI – Data Visualization

by Yana Berkovich (PM Instructor-Led Training Power Platform)

Learn More

Microsoft Breakout Sessions

For Full Session List: Click Here

Session_TitleAbstractTrackSpeaker(s)Level
SQL Server 2019: Building A Foundation With Persistent MemoryData volumes have exploded. There is much more data at rest than ever before with only a small amount of the ingested data ever processed. Intel estimates that this is less than 1% of the volume ingested. Yet, we continue to produce data at record levels and systems can barely keep up to meet the demands.

In this session we will cover some of the benefits of a hyper-converged infrastructure, Storage Spaces and Storage Spaces Direct in Windows Server 2019, the capabilities of Intel Optane DC Persistent Memory, and how SQL Server 2019 can build upon these technologies.

Intel Optane DC Persistent Memory is an innovative memory technology that delivers a combination of large capacity storage and support for data persistence. Persistent Memory can help with increased capacity needs and unique memory modes, lower the overall total cost of ownership while maximizing virtualization densities, and increase memory security with automatic hardware-level encryption.

Persistent Memory can be a powerful technology for larger systems such as SQL Server, SharePoint, and private cloud deployments.

We will cover how SQL Server can take advantage of Persistent Memory today and where the opportunities lie for all supported versions.

We will cover SQL Server data access performance (block access), persisted log buffer (tail-of-log caching), enlightened I/O (with Direct Access), and Hybrid Buffer Pool capabilities.

Finally we will address the scenarios where applications and platforms can best take advantage of hyperconvergence with persistent memory as a complete solution a foundation to build upon.

We look forward to seeing you there!

#PersistentMemory #SQLServer2019 #SQLServer #Virtualization #Hyperconvergence
Data AdministrationDavid Pless & Brian CarrigAdvanced
Azure SQL: Getting Started With An Intelligent DatabaseAzure SQL encompasses Azure SQL Database, Azure SQL Managed Instance, and SQL Server.
As part of the Intelligent Query Processing family, the latest SQL Server 2019 and Azure SQL Database introduce ground-breaking enhancements.
These enhancements make up the latest in Microsofts mission to improve critical parallel workloads when running at scale while remaining adaptive to the ever-changing landscape of data.
Join us to know more about the Intelligent Database world that's available to you today, and to know more about the journey onwards.
ArchitecturePedro Lopes & Joe SackExpert
Azure SQL Database - Troubleshooting real world scenarios with Microsoft Support EngineersIn this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos

#AzureSQL #QDS #Monitoring #Improving
Data AdministrationJose Manuel Jurado & Roberto CavalcantiAdvanced
Modernize your data on Azure Database for Postgres and MySQL Flexible ServerAre you looking to migrate it to the cloud, gain operational efficiency, and yet more importantly, not give up control of your database? Look no further. In this session you will learn how the new Flexible Server for Azure Postgres or Azure MySQL gives you full control for choosing your configuration, optimize cost, manage automatic maintenance, with flexible high availability options for your databases. For each of these capabilities, we will cover the ‘why’ and how using with simple demos to make your learning real. DevelopmentParikshit Savjani & Sunil AgarwalAdvanced
Best Practices For Migrating Your Workloads To Azure Database For PostgreSQL And Azure Database For MySQLFor open source relational database workloads, customers are increasingly adopting Azure Database for MySQL and Azure Database for PostgreSQL to take advantage of a fully managed database service technical teams innovate faster. In this session, we will cover the best practices to migrate existing MySQL/PostgreSQL/Oracle workloads to Azure PaaS. We will also dive deeper into various migration tools available for offline (one-time migrations and online (ongoing replication) migrations with a live demo of a MySQL to Azure DB for MySQL online migration.Data AdministrationSunil Agarwal & Arun KumarAdvanced
Create Secure API With .NET, Dapper And Azure SQLCreating backend REST API is a very common duty in today's work. But what about creating an API that is also secure and  only shows the authorized data to each user invoking it? Thanks to Azure SQL's Row Level Security feature, it's very easy to create an API, even on an existing data, without any change to the database schema, that is secure and fast. In this session we'll see how we can create a full REST API in an hour, using Azure SQL, the micro-ORM Dapper and .NET Core.

You'll be amazed to see how simple it is, even while you are not giving up on performances and security!

#RLS #Security #REST #API #Dapper #.NETCore #microORM
DevelopmentDavide MauriAdvanced
Turbocharge Your MySQL Engine On Azure To Make It Fast, Resilient And ScalableLooking to unleash the full power of the cloud and build fast, resilient and internet scale applications with MySQL on Azure? Are you looking to extract more performance and scale out of your Azure Database for MySQL service?  Join this action packed deep technical session to understand how do you measure and monitor the right metrics with Azure Database for MySQL service, configure your Azure DB for MySQL server for best performance and how to scale your application seamlessly from 0 to thousands of QPS without any application changes. Whether you are a DBA, developer or devops engineer, you'll leave the session with a list of great tips and tricks for optimizing performance of your MySQL server without any application side changes.DevelopmentAmol BhatnagarAdvanced
Build Modern Cloud Native Applications With Kubernetes And OSS Databases (MySQL & Postgres)With changing customer requirements, you need to think about modernizing your approach to application development to be cloud-ready. In this session, we will show you how to modernize your application with Azure Kubernetes Service (AKS) and MySQL on Azure. We will walk through on how to migrate an application that uses PostgreSQL or MySQL to Kubernetes using AKS and Azure Database for MySQL.  In additional to the migration, you will also learn how to optimize AKS to work best with Postgres or MySQL on Azure and to simplify migration and operational efficiency resulting in increased scalability, improved performance, and reduced costs.DevelopmentSunitha MuthukrishnaIntermediate
Azure AI, Power new possibilities for every organizationAI and data is at the center of the digital feedback loops. The quintessential characteristic of every application going forward will have AI, we have invested in a comprehensive portfolio of AI tools, infrastructure and services. We are also pushing the bounds of how computers and AI can generalize learning beyond narrow domains. We work with our partners on our collective pursuit to democratize AI and its benefits for everyone. Come to this session to get an update of Azure AI with demos.Data Science (AI/ML)Lindsey AllenIntermediate
Monitor Your Data in Real-time with Microsoft Power BIWhy make decision based on data from yesterday when you can learn what is happening now? Wouldn't it be better to look forward instead of the rear-view mirror? Learn about the real-time data visualization capabilities for datasets, reports, and dashboards

In this session you will learn:

How to create dashboards, reports, and visuals with data that's always up to date.
Different options for real-time datasets: streaming, push, et.
How to monitor critical events with automatic page refres.

#real-time #dataviz #streaming
Business Intelligence & Advanced AnalyticsMiguel Martinez & Peter MyersIntermediate
What is Azure Arc Enabled Managed Instance?Have you checked out Azure Arc yet? Azure Arc enabled Managed Instance enables you to run SQL Server compatible workloads with the added management capabilities anywhere. In this session, we’ll bring you quickly up to speed on Azure Arc enabled Managed Instance, discuss use cases, and demo this product. We’ll also cover how you can get easily get started with this product.

#AzureArc
Data AdministrationVin YuIntermediate
Azure Arc Enabled SQL ServerEven if you cannot migrate or modify your SQL Server application, you can leverage Azure. Whether your existing SQL server instances deployed to your private infrstraucture, AWS or GCP, you can use Azure Arc to manage your global inventory, protect SQL Server instances with Azure Security Center or periodically assess and tune the health of your SQL Server configurations.

#AzureArc
ArchitectureSasha NosovIntermediate
What is Azure Arc enabled PostgreSQL Hyperscale?You would like to modernize to the cloud but you can't migrate everything overnight? For regulatory/compliance reasons you need to keep some workloads on your premises while you move other applications to the cloud? You need a database engine that is able to scale dynamically, with no downtime to match the growth of your multi-tenant/SaaS workloads or your real-time analytics applications? You are already using the Postgres database engine or you are planning to migrate to it? You would like to use the same Postgres based solution both as a managed service in the cloud and in your data center?  If you answered yes to any of these questions, join us in this session to learn about Azure Arc enabled PostgreSQL Hyperscale. This is a new hybrid Azure data service that runs on any physical infrastructure, on premises, at the edge or in the cloud (Azure, AWS, GCP). It is the same technology as the Azure Database for PostgreSQL Hyperscale (Citus) managed service and is now available on the infrastructure of your choice with Azure Arc. Like its sibling in Azure PaaS, Azure Arc enabled PostgreSQL Hyperscale uses the open source Citus extension to scale horizontally, transform Postgres into a distributed database by distributing your data and your queries across all the nodes in a cluster. In the cloud and on your own infrastructure, we have it for you. Let's connect.

#Azure #PostgreSQL #AzureDBPostgres
Data AdministrationJean-Yves Devant & Nikhil PatelIntermediate
SQL Server Licensing: DemystifiedLearn about the new licensing benefits that were introduced with Software Assurance and how it can help you drive lower TCO for SQL Server deployments. In this session you will also understand how you can derive additional benefits by leveraging Azure SQL as an extension of your existing datacenter using Azure Hybrid Benefit.

#AzureArc
Data AdministrationAmit BanerjeeAdvanced
Inside Waits, Latches, and Spinlocks ReturnsThis session marks the return of a popular session dive into the internals of waits in SQL Server including latches and spinlocks. In this session, you will learn how SQL Server implements waits, how you can monitor and troubleshoot waits, and a deep dive into specific common wait types. This session will include new wait types specific to Azure SQL. The session will include plenty of demos and back by popular demand the use of the Windows Debugger to peek inside how waits are truly implemented in SQL Server.

#sqlserver #azuresql
Data AdministrationBob WardBrain-Hurting
Inside SQL Server on KubernetesContainers are the new "virtual machines" and one of the hottest technologies in the industry. While containers compliment virtual machines and provide consistency, portability, performance, and availability, how do you deploy containers at scale? For many, Kubernetes, an open-source system for automating deployment, scaling, and management of containerized applications, is the answer. In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. You will see how SQL Server can take advantage of Kubernetes for "built-in" high availability, easy to deploy patching, and integration with Always On Availability groups. We will discuss deploying SQL Server in various popular Kubernetes distributions including but not limited to Azure Kubernetes Service, OpenShift, and kubeadm. This session assumes a fundamental knowledge of both SQL Server and containers. We will move fast, and go deep using demos as a method to learn SQL Server and k8s.

#sqlserver
Data AdministrationBob WardAdvanced
Effective Data Engineering and Data Science on SQL Server Big Data ClustersWe are on a mission to show you how to effectively use SQL Server BDC to deliver Data Engineering and Data Science use cases. Let’s go through an end-to-end implementation focusing on most used big data engineering patterns and how to use all BDC components in conjunction to achieve a sound solution architecture. We will double down on how to effectively enable and execute Data Science at scale while keeping things organized and secure. At the end, you will walk away with all the generalizable artifacts do make it your own and solve your organization Big Data modernization challenges.

#sqlserver #BigDataClusters
Data Science (AI/ML)Daniel Coelho & Rahul AjmeraIntermediate
Gain insights with SQL Server Big Data Clusters on Red Hat OpenShiftBig Data Clusters (BDC) is a set of capabilities introduced in SQL Server 2019 to help achieve data-driven business insights from ever increasing sources and amounts of data. With BDC, organizations can run containerized Apache Spark and Hadoop Data File System (HDFS) in an integrated matter side by side with SQL Server, in a single, secure and unified data platform. BDC requires Linux containers and Kubernetes, and recently Red Hat OpenShift was added as a commercially supported Kubernetes platform for BDC. OpenShift helps achieve the desired agility, consistency, flexibility, scalability, portability, etc. for data science and application development workflows. In this session, you will learn about BDC on OpenShift architecture, key capabilities and use cases, best practices, and technical resources to get you up to speed.

#SQLServer #BigDataClusters
ArchitectureMihaela BlendeaAdvanced
Deployment, High Availability and Performance guidance for SQL Server on Linux in Azure IaaS ecosystemSQL Server on Linux has been one of the fasted growing database on Linux platform over last couple of years. At the same time many customers are looking to migrate their SQL Server instances and SQL based applications to the cloud to take advantage of scalability, flexibility, advanced high availability and disaster recovery options, optimized licensing scenarios, access to Azure monitoring & Azure security and advisory technologies. If you are considering SQL Server on Linux in cloud, look no further than Azure. In this session you will learn about how to quickly deploy production grade SQL Server on Linux in Azure ecosystem, including new fully supported High Availability configuration. You’ll learn how to configure AD authentication reliably and quickly with new and improved experience. You’ll also see suggestions on how to get best performance out of SQL Server on Linux in Azure. We look forward to seeing you there!

#SQLServeronLinux
Data AdministrationTejas ShahIntermediate
Azure Data Studio Notebooks Power HourJoin this session to learn more about Notebooks in Azure Data Studio. We'll demo new features in notebooks in Azure Data Studio, through the different use case lenses. Learn how to author notebooks, convert + organize your scripts to more manageable and shareable notebooks, all the way to fun + productive tricks that you can try at home! DBAs, Data Engineers and all data professionals are welcomed.

#AzureDataStudio, #Notebook, #AzureSQL, #ClientTooling
DevelopmentJulie Koesmarno & Alan YuIntermediate
SQL Database ProjectsAzure Data Studio has recently added project functionality, supporting both compatibility with SQL Server Data Tools (SSDT) and new features. With the growth of cross platform environments and DevOps for databases, now is a great time to learn about database development in Azure Data Studio. We will dive into the SQL Database Projects extension for Azure Data Studio through an end to end example with Azure SQL Edge as well as a review of the overall functionality.

#AzureDataStudio, #AzureSQLEdge
DevelopmentDrew Skwiers-Koballa & Udeesha GautamBeginner
State of the SQL ToolsLearn about what's new and what's coming soon for SQL Server tools in this demo-heavy session from the SQL Server product team, highlighting Jupter notebooks, sql database projects, and more.

#AzureDataStudio #OSS
Development/Database AdministrationVicky Harp & Ken Van HyningBeginner
SQL containers are ready, are you? - For DBA and DevelopersIn this session, learn how as a Data Engineer/DBA or a developer can you take your faviorite SQL Server to the container world. In this session we will also show you how easy it is for you to implement SQL Server in containers and get started with it. We will talk about new features available, how you can implement the containers in a secure way for production environments, customize it as per your requirement, we will also talk about the scenarios that best suit for SQL containers.

#containers #sqlcontainers
Development/Data AdministrationAmit KhandelwalIntermediate
How to Become an Azure Data Studio ContributorLearn how to make an impact on Azure Data Studio in this session, where we’ll discuss how you can leverage the GitHub repository, extensibility points, and open-source community to maximize your value in the application. New features are added to Azure Data Studio every month, and the team is always listening for feedback. We will walk through the various ways the community is empowered to shape changes to the application. Users are invited to engage by voting on feature requests, discussing use cases, and testing the nightly Insiders build. The Azure Data Studio code base is both open and extensible – meaning that contributors are welcome to build an independent extension or submit changes to the core of the application. We will walk through the available extension APIs and newly improved extension generator, as well as demonstrate how to build the full application. Come to this session and become a part of the Azure Data Studio community.

#AzureDataStudio #OSS
Development/Database AdministrationHannah Qin & Drew Skwiers-KoballaBeginner
New ways to keep your SQL databases on Azure VMs protected and availableKeeping your SQL database available and protected is a critical mission of any DBA. In this session, we will discuss new ways and best practices for keeping your SQL Server databases available on Azure VMs.

#SQLHA
Data AdministrationKevin FarleeIntermediate
Administrating Big Data Clusters ( BDC )SQL Server Big Data Clusters (BDC) is a cloud-native, platform-agnostic, open data platform for analytics at any scale orchestrated by Kubernetes, it unites SQL Server with Apache Spark to deliver the best data analytics and machine learning experience. Join this session if you are interested in the administration scenarios of the big data clusters, including tooling for monitoring, how to deploy and secure the environment, and to learn about the latest improvements.

#SQLServer #BigDataClusters #Kubernetes
Data AdministrationMelony QinIntermediate
Real-time data analysis using Azure SQL EdgeJoin us to learn how Azure SQL Edge provides the flexibility and capabilities to develop IoT/Edge solutions that leverages machine learning & real-time analytics to drive continuous optimization and efficiency.

#AzureSQLEdge #SQL #IoTSolutions #AzureSQL #SQLServer #Edge
Data AdministrationVasiya Krishnan & Sourabh AgarwalIntermediate
Understanding your SQL Server readiness to migrate databases to Azure SQL using database assessment and migration toolsIn this session we will walk you through database assessment and migration tools that will assist in seamlessly migrating your SQL Server databases to Azure SQL. The session will guide you through migration process on how to determine readiness of your SQL Server instances, identify a recommended target, and complete the migration to Azure SQL.

#AzureSQL
Data AdministrationRajesh Setlem & Mohammed KabiruddinIntermediate
Database modernization best practices and lessons learned through customer engagementsIn this session you’ll learn the real-world ins and outs of how we successfully migrated customers to Azure data platform.
You will get a detailed view of Microsoft investments accelerating Azure SQL migrations, the migration lifecycle phases, and specific tools/ services help you in the migration journey.
You will listen to real world customer migration case studies, the speciifc migration strategies adopted and best practices implemented.

#AzureSQL #DMS #SQLMigration
Data AdministrationRaj Pochiraju & Mukesh KumarIntermediate
App Modernization and Migration from End to end, using data migration tools and Azure SQL In this session, you'll learn about an end-to-end scenario that takes customers through the application and database migration process.
This demo heavy session will help you understand the Microsoft recommendations, tools, & services that help you migrating your .NET application and databases to Azure.

#AzureSQL #DMS #SQLMigration
Data AdministrationRaj Pochiraju, Balmukund Lakhani & Ajay JagannathanAdvanced
Fine Tuning Clouds: Azure SQL Database Performance Tuning Tips and TricksPerformance tuning might be seen as magic, and those who can tune might look like magicians. There are no “go-faster” buttons and in reality, performance tuning is more art than magic. In this session we share common performance issues seen by various customers while using Azure SQL Database, and possible ways to fix them. You will learn database tuning techniques to gain the best performance for your application. While there are many tips and tricks available for traditional SQL Server installations, there are additional tuning best practices specific to Azure SQL Database. This session covers efficient data loading, dealing with high resource consumption, practical usage of various DMVs and various diagnostic telemetry available to look back in time.

#AzureSQL
Data AdministrationBalmukund Lakhani & Dimitri FurmanAdvanced
Modernize your SQL applications with the recently enhanced version of Azure SQL Managed InstanceAzure SQL Database Managed Instance offers the best combination of a fully managed cloud service in Azure and compatibility with SQL Server on-premises product. This makes it the recommended destination for SQL Server workloads migrating to Azure cloud.
If you think about digital transformation in Azure, start exploiting the increased productivity and cost savings that the managed instance can provide to you.
Managed Instance remains to be one of the strategic investments in Azure SQL product portfolio. Over the last year it has been greatly enhanced in terms of new programmability surface area and increased application compatibility, improved price-performance, networking security and compliance, and better migration and manageability experience.
Come and hear about the best practices of migration to managed instance, the latest product enhancements, and get a sneak peek at the future product roadmap.

#AzureSQL
Data AdministrationBorko Novakovic, Vladimir Ivanovic, Srdan BozovicIntermediate
The Future of Cloud Relational DatabasesRelational databases have been a key foundation for applications for over 40 years. How does the future look for relational databases, especially in the cloud? This session will also bust several myths that have come to surround relational databases in the last few years through demos.

#AzureSQL
Data AdministrationSanjay MishraIntermediate
DevOps for AzureSQL"But... it worked on my computer!" A good DevOps practice and implementation will help eliminate that unwelcome phrase! Come to this session to learn how to use tools and platforms like Visual Studio Code, Git, Azure DevOps, GitHub Actions for a modern, secure and easy-to-use database DevOps experience for Azure SQL. We will use demos to show and evaluate two approaches: first, a code-centric migration-based approach (using DbUp and GitHub Actions), and second, a more complex project/state-based approach (using Visual Studio SQL Projects and Azure DevOps and a locked-down Azure SQL DB) to understand some of the many possibilities for implementing DevOps for Azure SQL.

#AzureSQL
DevelopmentArvind ShyamsundarIntermediate
Azure SQL Hyperscale Deep DiveAzure SQL is a world class database and it’s new tier Hyperscale enables separation of compute and storage and gives you the scale and availability needed in the cloud. In this session, we will go through the Hyperscale architecture and all its components such as Page servers, read scale replicase, Xlog as well as multiple cache layers. We will also cover analyzing performance and the diagnostics unique to hyperscale and discuss best practices to migrate to Hyperscale. We see Hyperscale as the future, come learn about it!

#AzureSQL
Data AdministrationDenzil RibeiroAdvanced
Azure SQL: What to use when and product updatesCome learn about the latest capabilities in the Azure SQL family (VM, SQL Managed Instance, SQL Database) in the past year, along with the latest "game changers" that Azure SQL brings to the table for organizations, including hyperscale, serverless, intelligence, and more.

#AzureSQL
Data AdministrationAjay JagannathanIntermediate
Azure SQL High Availability and Disaster RecoveryIf you've ever had to deploy an Availability Group, Failover Cluster Instance, or backups you'll appreciate learning about the availability architectures and disaster recovery solutions that Azure SQL provides automatically when you deploy Azure SQL Database or Azure SQL Managed Instance. You'll learn about the latest innovation in availability, including topics around Availability Zones and Monitoring. You'll also learn about options, recommendations, and tutorials for recovering from a disruptive event that could cause data loss.

#AzureSQL
Data AdministrationEmily Lisa & Shreya VermaAdvanced
360-degree view of Azure SQL MonitoringTake a trip with the product group through all the monitoring options for Azure SQL. Learn more about some of the new upcoming features and capabilities in Azure to monitor Database workloads. You can come and see more on a new solution for gathering and ingesting telemetry, which allows you access to new telemetry for your database, with full granular control of the collection and ingesting of data.  This session will help you understand all your options to adequately monitor your SQL workloads in Azure. 

#AzureSQL
Data AdministrationAlain Dormehl & Mara SteiuIntermediate
Leverage Azure SQL Database for Hybrid Transactional and Analytical Processing (HTAP)?In real world, applications can rarely be classified as "pure OLTP" or "pure OLAP", but more often they will be present a mix of these two workloads. Learn how Azure SQL Database features and capabilities can nicely cover customer requirements and data processing scenarios.

#AzureSQL
DevelopmentSilvano CorianiIntermediate
SQL Server in Azure Virtual Machines ReimaginedMost of the enterprise workloads would want both control and Manageability of their databae solutions. For such scenarios, deploying SQL Server in VM is a best choice. By deploying SQL Server in Azure Virtual Machines customers can take advantage of many features around administration, high availability and performance. In this session we will look at different best practices,advantages we have when we deploy SQL Server on Azure Virtual Machines.

#AzureSQL #SQLonVM #SQLIAAS
Data AdministrationAditya Badramraju & Pam LahoudIntermediate
Securing your data in Azure SQL DatabaseIn this session we will guide you through the steps on how to secure your databases. Where to start, what to use, and what to watch out for. While the focus will be on Azure SQL Database, Microsoft’s PaaS offering, you will also learn about the few potential differences when it comes to Managed Instance or SQL Server in a VM (IaaS) and on-prem. The aim is to give first-time users or adopters a checklist to make sure all areas of data security are covered.

#SQLSecurity #AzureSQL
Data AdministrationAndreas WolterBeginner
Self-service analytics and BI using Azure Synapse Link for Azure Cosmos DBIn this session, we will cover how you can build real time BI dashboards with deep granularity using Azure Synapse and Azure Cosmos DB. Learn how to enable no-ETL analytical processing on real time operational data with no performance impact on mission critical operational workloads.
Azure Synapse Link for Azure Cosmos DB is Microsoft’s cloud-native implementation of hybrid transactional/analytical processing (HTAP).

#Azure #AzureCosmosDB
Business Intelligence & Advanced AnalyticsRodrigo SouzaExpert
Best practices for deploying Azure Cosmos DB in enterprise mission-critical scenariosIn this session, we will cover the best practices for deploying a mission-critical Azure Cosmos DB workload. We will begin by walking through how to secure, stress test, and diagnose a pre-production environment ahead of your go-big launch. Next, we will discuss how to monitor livesite, as well as, further optimize the Azure Cosmos DB production environment using various knobs including autoscale, indexing, and high availability. By the end of the session – you will be able to safely and confidently go big with your Azure Cosmos DB workload – just like how existing Fortune 500 customers like Walmart, ExxonMobil, American Cancer Society, ASOS and Symantec have done before.

#Azure #AzureCosmosDB
DevelopmentAndy FeldmanAdvanced
Data modelling and partitioning in Azure Cosmos DB: What every relational database user needs to knowIf you are new to Azure Cosmos DB and have only ever used relational databases, this session is for you! Azure Cosmos DB is unique in that a database that it can provide the same exact performance whether it is Megabytes in size or Petabytes in size. But the only way to get that kind of performance is understand how to model and partition data. Even if you're not trying to design a database with ultimate scale, you may have other questions How should I structure my data? When should I co-locate data in a single container? Should I de-normalize or normalize properties? What’s the best partition key for my model?

In this demo-filled session, we discuss the strategies and thought process one should adopt for modeling and partitioning data effectively in Azure Cosmos DB. Using a real-world example, we explore Azure Cosmos DB key concepts—request units (RU), partitioning, and data modeling—and how their understanding guides the path to a data model that yields best performance and scalability. If you're familiar with relational databases, and want to dive into the non-relational world, this is the session for you.

#Azure #AzureCosmosDB
DevelopmentMark BrownAdvanced
How Delta Lake with Azure Databricks can accelerate your big data workloadsDelta Lake empowers you to build reliable Data Lakes at scale. Come learn how you can leverage the new and advanced features of Delta Lake on Azure Databricks to easily transform your big data analytics and machine learning workloads. We will discuss Apache Spark optimizations like file compaction, Z-Order partitioning, schema evolution, unified batch and streaming, time travel, and how you can set expectations on data quality.

#AzureDatabricks #Spark #BigData #Analytics
Business Intelligence & Advanced AnalyticsKyle WellerAdvanced
Migrating & Operating Business Critical Open Source Analytics Applications with Azure HDInsight The world today runs on data. And enterprises need to gain lightning fast insights from increasingly sensitive data while meeting the strictest security & compliance requirements. And they need to do so while controlling costs and ensuring high levels of productivity amongst their employees. Azure customers can do just that and more with Azure HDInsight – now with new cost control, performance and enterprise grade security features all based upon Apache analytics frameworks built and fully supported by Microsoft. Learn how to use the Migrate, Optimize and Modernize strategy to easily migrate your big data applications from on-premises and transform them to run optimally on Azure.

#HDInsight #BigData #Spark #Analytics
Business Intelligence & Advanced AnalyticsArindam ChatterjeeIntermediate
How Data Engineers and Data Scientist can get started with Azure Synapse Analytics, Azure Data Factory and Azure Machine LearningData is the fuel of AI. Data engineers and data scientists spend significant time performing data preparation, and feature engineering. Often, the data that sits in diverse data sources spread across the organization, and lots of time is spent on figuring out data acquisition. In this session, you will learn how Azure Data Factory and Azure Synapse Analytics can empower data engineers and data scientists to connect to various data sources, perform data transformation, and operationalize their data models, all at elastic scale. You will learn how data scientists can leverage this new found superpower to get to the data they need to develop and train and deploy the machine learning models using Azure Machine Learning, orchestrate it using Data Factory, and scale their models using Azure Synapse.

Don't miss this demo-packed sessions as you learn how Azure Data Factory, Azure Synapse, and Azure Machine Learning can come together to help you achieve more!

#MachineLearning #AzureSynapse #AzureDataFactory #BigData #Analytics
Data Science (AI/ML)Wee Hyong Tok & Nellie GustafssonIntermediate
Building a connected analytics hub with Azure Synapse LinkIn this session, we will cover how you can build real time BI dashboards with deep granularity using Azure Synapse and Azure Cosmos DB. Learn how to enable no-ETL analytical processing on real time operational data with no performance impact on mission critical operational workloads. Azure Synapse Link for Azure Cosmos DB is Microsoft’s cloud-native implementation of hybrid transactional/analytical processing (HTAP).

#Analytics #AzureSynapse #CosmosDB #BigData
Business Intelligence & Advanced AnalyticsArnaud CometIntermediate
Microsoft Power BI: Business Intelligence Strategy, Vision, and Roadmap Update Our main goal for Power BI is to help our customers drive a data culture – helping everyone make better decisions based on data. Join Microsoft's Business Intelligence leadership team to learn about our strategy, experience the newest capabilities available in Power BI, and see what is coming next. 

#PowerBI
Data AdministrationArun Ulagaratchagan & Amir Netz Intermediate
Building systems of insights for enterprise scale with Power BI and AzureBringing business intelligence to thousands of users in the enterprise requires scaling for the largest datasets in the organization without compromising performance or security. Join us to learn about how Power BI deeply integrates with Azure Synapse Analytics and how you can easily leverage your investments in Azure to bring insights to those who need it the most.

#PowerBI
Business Intelligence & Advanced AnalyticsPriya SathyIntermediate
Big data analytics with Power BI and Azure Synapse AnalyticsThis session will discuss the modern data warehouse stack focusing on Azure Synapse Analytics and Power BI for semantic modeling and data visualization. Learn how to unlock petabyte-scale datasets for interactive analysis. Use the Power BI Performance Accelerator for Synapse Analytics as a self-learning, self-optimizing system which automatically creates and manages materialized views in Synapse based on Power BI usage and query patterns.Business Intelligence & Advanced AnalyticsVijay GopalakrishnanIntermediate
Inside OCR and Form RecognizerLearn about Microsoft Cognitive Services capabilities in Optical Character Recognition (OCR) and Document AI with the Form Recognizer product.Data Science (AI/ML)Sanjeev JagtapIntermediate
Inside Computer VisionProviding insights on the capabilities of the Computer Vision API in Azure Cognitive Services

#Computer-Vision #Azure-Machine-Learning #Artificial-Intelligence #Azure-Cognitive-Services
Data Science (AI/ML)Varsha Parthasarathy
Intermediate
Inside QnA MakerThis session is to give an overview of Microsoft Cognitive Service: QnA Maker. You can create a conversational layer over your data with no/low code experience. QnA Maker can be used to create your own bot in minutes without writing a single line of code. It uses deep learnt models which understands the user query and returns the best possible answer for them.Data Science (AI/ML)Neha RajputBasic
Inside Reinforcement Learning - how RL is powering Decision AI and the next set of Cognitive ServicesUnderstand what Reinforcement Learning (RL) is and how is RL helping and power the next set of Cognitive Services such as Personalizer in Azure AI. These services are helping enterprises build applications for the changing world.

#AI, #AzureAI, #RL, #ReinforcementLearning, #CognitiveServices
Professional DevelopementAmit BahreeIntermediate
Developing sophisticated virtual assistants using the Microsoft Conversational AI PlatformToday, organizations are responding to increased demand from customers and employees looking for information and support. In this session, you will see how you can build your own Conversational AI applications using the Microsoft AI Platform - using Bot Framework Composer to rapidly create sophisticated and personalized conversational experiences which can be surfaced wherever your end users are, including Teams, WebChat, Alexa and more!

#ConversationalAI #Azure #BotFramework #Microsoft
DevelopmentGary PrettyIntermediate
Challenges to Overcome while Building Machine Translation Models for Indian LanguagesMicrosoft Translator has shipped machine translation support for 10+ Indian languages. In this session, we will use Indian languages as example to cover why it’s important to build machine translation models for digitally low resourced languages and challenges you would face during data acquisition and building machine translation models.  You will learn tips to overcome those challenges.  We will demo how those machine translation models makes societal and business impact.

#MachineTranslation #Azure #CognitiveServices #IndianLanguages #AI #ML #DataEngineering
Industry SolutionKrishna Doss MohanIntermediate
Inside Text Analytics, an Azure Cognitive serviceIn this session, you will learn about various capabilities of Text Analytics (TA), an Azure Cognitive services to gather insights from unorganized and unstructured text that comes from online sources such as emails, blog posts, support tickets, web chats, social media channels, forums and comments. During the session you learn about the following capabilities of TA:
1. Language detection
2. Sentiment analysis
3. Opinion mining
4. Key phrase extraction
5. Named entity recognition
6. PII and redaction
7. TA for health
You will learn how to use TA's pre-built models and what's new in TA. You will also see some cool demos & reference architectures on how to use Text Analytics in your business.
Data Science (AI/ML)Parashar ShahIntermediate
Architecting enterprise-grade data pipelines with Azure Data FactoryAzure Data Factory is the modern data integration service (hybrid, server-less, cloud scale) that enables customers to build their ETL/ ELT pipelines for their Modern Data Warehouse (MDW) from Big Data. What truly makes Azure Data Factory an enterprise-ready ETL service is the in-built security features. In this talk we will learn all security fundamentals and best practices while building data pipelines in Azure Data Factory.

#AzureDataFactory#ETL#Azure#AzureData#DataFactory#Security#DataPipelines
ArchitectureAbhishek NarainIntermediate
Inside Azure Speech ServicesQuickly add speech capabilities to your solutions or experiences with no-code tools. In this session, we will cover how you can accelerate your development process with ready-to-go samples and a Speech services command line tool (SPX), customize solutions for your use case (Speech Studio), and benefit from flexibility in the hosting model from on-prem to the cloud.
#speech-to-text #speech-recognition #speech #speech-synthesis #text-to-speech #speaker-recognition #speaker-identification #speaker-verification #keyword-recognition
Data Science (AI/ML)Oliver ScholzBasic
Building Enterprise grade bot in no timeIn todays world every body need information on finger tips. It reduced peoples productivity if they have to spent hours and hours to find right information. Also finding right resources within organization is a big pain. Microsoft AI services can help but how about an interface to share this information. Microsoft bot can help here but as an AI developer or programmer how can I quickly create a enterprise grade bot in no time? How can we provide tools for business users or non developers to create a bot for their departments or team. This session will show case various ref architecture and tool to build enterprise grade bot in no time.

#AI #Code #Developer #Architect #bot #knowlwdgeMining
DevelopmentSudhir RawatIntermediate
Running Azure AI @ ScaleAI is driving transformation across organizations, including at Microsoft. Our recent, cutting edge AI innovations have allowed us to enhance the customer experience in all Microsoft products from Teams to Office 365 to Bing. In this session, I’ll share how Microsoft is leveraging AI and packaging some of those innovations to deliver as part of our Azure AI services. I’ll specifically deep dive into use cases for Azure Cognitive Services, share examples of customers who have made a transformative impact in their business, and demo some of the capabilities that you can leverage in your organization today.

#Azure AI #CognitiveServices #machineLearning
Data Science (AI/ML)Anand RamanIntermediate
Responsible ML – A Peek into Model InterpretabilityAre you building a ML model and want to ensure you adapt ‘Responsible AI’ Design principles ? As AI systems become more involved in the everyday decision-making in the society, it is of utmost importance that these systems work well in providing fair outcomes. Join this session to understand the approach, the toolset and the techniques to ensure you build a robust ML model on AzureData Science (AI/ML)Sandeep AlurAdvanced
Updates to Power BI Composite modelsBig changes are coming to Power BI – especially when it comes to working with Composite Models over Power BI Datasets. Composite Models have been evolving, and allow you to combine data from multiple datasets into a reusable model for use with many reports, saving on development time, and adding reporting agility. You might have seen part of it already at MBAS, but in this session you'll get the opportunity to learn first-hand how composite models work and what's ahead.

You will learn:
* The role of composite models in self-service reporting models
* How this will help you create Enterprise Semantic Models
* How these changes will impact you and your business

#PowerBI
Business Intelligence & Advanced AnalyticsJeroen ter HeerdtIntermediate
Harnessing Data With Synapse AnalyticsToday organizations deal with a variety of data, both structured and unstructured. Azure Synapse has unique ability to provide a unified experience for data analysts looking forward to perform descriptive/predictive analysis on any Big Data/SQL Data Warehouse scenario. It adds layers of productivity by serving as single stop shop solution for building your data estate, starting with ingestion of data into data lake to executing ml training jobs on curated data or to create BI dashboards. Let us get a detailed description of how all this is facilitated in this session!

#Data Analytics #Big Data #Azure Data Lake #Spark #SQL Data Warehouse
Business Intelligence & Advanced Analyticsshikha agrawalAdvanced
Blast to The Future: Accelerating Legacy SSIS Migrations into Azure Data FactoryThis session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (SSIS IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components via standard/express custom setups. We will next show you how to enable the following scenarios: assessing SSIS packages for cloud compatibility and testing their executions in ADF from SSDT, accessing data on premises by joining SSIS IR to a VNet or using Self-Hosted IR as a proxy for SSIS IR, accessing Azure SQL DB/Managed Instance with OLEDB connectors that are configured for Azure Active Directory authentication with ADF managed identity, running SSIS packages stored in MSDB/SSISDB/file system/Azure Files/SSIS IR package stores or embedded in ADF JSON payload as first-class activities in ADF pipelines, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe, monitoring and alerting on SSIS IR operations and SSIS package executions using Azure Monitor, etc. We will finally show you the complete SSIS Migration Playbook to perform package assessments and package/job migrations using SSDT, Data Migration Assistant, Database Migration Service, dtutil.exe, scripts, etc.Business Intelligence & Advanced AnalyticsSandy WinarkoBrain-Hurting
Designing for high performance in Power BIIt's so easy to get started with Microsoft Power BI Desktop and get immediate value. Power BI is a feature-rich platform with many advanced capabilities. However, as solution complexity grows, with this great power comes great responsibility. It's important to carefully consider how your datasets and reports are going to be deployed and consumed so that they perform at scale and save you from future pains. In this session we address common pitfalls and cover top tips to get great performance across the entire platform - from sourcing data to designing reports and dashboards. Bonus material - special considerations for Power BI Premium. Key Learning: Understand what features of Power BI based on business needs and performance implications. Demos: Most of the content will be presentation and guidance.Business Intelligence & Advanced AnalyticsSiva Harinath & Philip SeamarkAdvanced
DBA to Data engineer1. How transition from monolithic to Microservices applications brought this radical change
2. Evolution of Data engineering and data scientist roles
3. Transition from Data warehouse to Modern data warehouses
4. Transition from Data mining to Advanced data analytics
5. Real time and batch mode data processing
6. Lambda and Kappa Architecture
7. Anatomy of Modern data warehouse and Advanced data analytics solutions
Professional DevelopmentHarsh ChawlaIntermediate

 

Microsoft Round Tables

Rohan Kumar

Engage in a focused group discussion with Microsoft experts. At DPS 2020, there will be Ask Me Anything (AMA) sessions, Panel Discussions & LIVE Technical Round Tables – all of these will be spread across different time zones to cover the global audience. Each of these engagement opportunities will be focused on specific technology/subject/topic – quite valuable. These too will be recorded and delegates will get access to the recordings post the event.