Keynote: Creating a Data Culture
(Principal Architect, Microsoft, USA)
(Applied Data Scientist, Microsoft, USA)
Women-In-Technology Round Table Panel
Alexandra Ciortea
(Principal Program Manager, Microsoft, Romania)
Evangeline White
(Senior Program Manager, Microsoft, USA)
Valorie Hampton
(Senior Product Manager, Microsoft, USA)
Nikita Takru
(Product Manager, Microsoft, USA)
Anna Hoffman
(Data & Applied Scientist, Azure SQL, Microsoft, USA)
Shreya R. Aithal
(Program Manager, Microsoft, India)
Microsoft Breakout Sessions
Checkout the complete list of Sessions
Speaker(s) | Delivery Language | Session_Title | Abstract | Track | Level |
---|---|---|---|---|---|
Bob Ward & Buck Woody | English | Keynote: Creating a Data Culture | Check-out the latest innovations in the Microsoft Intelligent Data Platform for SQL and operational databases and how you can enable everyone in your organization to securely locate and use data to make intelligent decisions. Bob Ward and Buck Woody from the Engineering team will show you how to meet the needs of developers across the spectrum to leverage the new tools, processes, and platforms in the Intelligent Data Platform to create a data culture in your organization. Bob will go deep on the newest release in the Intelligent Data Platform – SQL Server 2022. | NA | NA |
Alexandra Ciortea, Evangeline White, Valorie Hampton, Nikita Takru, Anna Hoffman & Shreya R. Aithal | English | Women-In-Technology Panel | NA | NA | NA |
Anna Hoffman, Marisa Brasile | English | Data Exposed Live: News Updates | Join the audience of a Data Exposed session LIVE from Data Platform Summit! You'll receive the latest updates containing all things SQL Server and Azure SQL. This not-to-miss session will include demos, special guests, and a sneak peek at the future! | Development | Intermediate |
Collin Brian & Kellyn Gorman | English | Make Azure the Future Home of Your Oracle Workloads | Migrate or modernize your Oracle workloads to Azure for greater flexibility, scale, and innovation, with industry leading security and compliance. With Azure VMs to cloud-native relational and non-relational databases, Azure has a home for all your Oracle workloads. Join this webinar to learn how to engage with Microsoft to advance your cloud adoption strategy with best practices, cost saving strategies, and more. We will walkthrough tools you can leverage to automate and accelerate the migration process. | Data Administration | Intermediate |
Neel Ball | English | Modernize your Oracle workloads to Azure SQL - What's new? | Are you looking to leave Oracle behind? Join us on a demo packed session to find out what's new in the Oracle to Azure Data 1st party migration tools as Database Schema Conversion Toolkit and Database Migration Assessment for Oracle. Assess your applications and identify connections strings and data access APIs using Data Access Migration Toolkit. | Data Administration | Advanced |
Pieter Vanhove | English | Protect your data from tampering with Ledger | Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is a new feature in Azure SQL and SQL Server that incorporates blockchain crypto technologies into the RDBMS to ensure the data stored in a database is tamper evident. Ledger introduces ledger tables that make data tampering easy to detect. In this session, we will cover • The basic concepts of Ledger and how it works • Ledger Tables • Digest management and database verification After completing this session, you will understand how Ledger works and how it can help to protect sensitive data. | Architecture | Intermediate |
Dinakar Nethi | English | Multicloud and Hybrid readiness: Mission Critical capabilities from Azure-Arc enabled SQL Managed Instance - Part1 | Many enterprise are modernizing their mission critical applications, data and infrastructure to be cloud-enabled, while they develop newer applications for multicloud platform for resiliency, data sovereignty, compliance and latency. The session will help you understand capabilities of Azure Arc-enabled SQL Managed Instance. You will learn how to spin up an Azure Arc environment quickly to run on Kubernetes and deploy your SQL managed instance on any cloud. You will understand how to run your mission critical data with high availability and performance. We can show how developers use Azure portal and Azure to centrally update, monitor and backup/restore the data. | Data Administration | Advanced |
Dinakar Nethi | English | Multicloud and Hybrid readiness: Mission Critical capabilities from Azure-Arc enabled SQL Managed Instance - Part2 | Many enterprise are modernizing their mission critical applications, data and infrastructure to be cloud-enabled, while they develop newer applications for multicloud platform for resiliency, data sovereignty, compliance and latency. The session will help you understand capabilities of Azure Arc-enabled SQL Managed Instance. You will learn how to spin up an Azure Arc environment quickly to run on Kubernetes and deploy your SQL managed instance on any cloud. You will understand how to run your mission critical data with high availability and performance. We can show how developers use Azure portal and Azure to centrally update, monitor and backup/restore the data. | Data Administration | Advanced |
Venkata Raj Pochiraju | English | Manage on-premises SQL Servers with the power of Azure- “Arc-enabled SQL Servers” | Do you want to continue hosting your SQL Servers on-premises but optimize administration of SQL Server instances in on-premises and multi-cloud environments by using Azure Arc? Please join our session that we can deep dive into how Arc enabled SQL Server capabilities assessing SQL Server configuration, availability, performance and help mitigating. Bring the power of Azure Defender, Best Practice Assessments and Azure Monitor services to optimize and secure your SQL Servers. In this session you learn below: Use cases and when to use Arc enabled SQL Servers Architecture: How does all this works Onboarding single and at scale SQL Servers Capabilities: SQL BPA, Defender, and Purview. Customer success stories Roadmap and references | Data Administration | Advanced |
Des FitzGerald, Naveen Samba & Sumit Sarabhai | English | SQL Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices | Come, Join this demo packed technical session from Data Engineers & Architects if you are looking to learn enterprise customer's challenges, reusable IPs, & best practices modernizing SQL estate to Azure. Focus will be to share frequent complex issues, their resolution, perf optimization including tips to select right SQL service on Azure and rightsize the environment. | Architecture | Intermediate |
Mukesh Kumar, Narendra Angane & Kapil Samant | English | Oracle to SQL/PostgreSQL Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices | Come, Join this demo packed technical session from Data Engineers & Architects if you are looking to learn enterprise customer's challenges, reusable IPs, & best practices modernizing Oracle estate to Azure. Focus will be to share frequent complex issues, their resolution, perf optimization including tips to select right SQL service on Azure and rightsize the environment. | Architecture | Intermediate |
Mukesh Kumar, Ashish Khandelwal & Amethyst Solomon | English | Mainframe/Midrange to Azure Data Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices | Learn from Mainframe and Data platform engineers in this demo packed session to find out how to execute a data first modernization strategy for mainframe and midrange systems. Learn about the Microsoft products, custom IPs, ISV tools, and engineering led support to implement this at your organization. Assess your workload, identify the complexity, and learn how to perform data migration, data ingestion, data replication, data integration and data co-existence. | Architecture | Intermediate |
Bob Ward & Ajay Jagannathan | English | Overview of SQL Server 2022 | Join us to learn about the new features in SQL Server 2022 that improve security, performance, and high availability. See how new features in SQL Server empower you to build modern, intelligent apps even faster. You will also learn how the integrated data platform enables new hybrid scenarios such as near real-time intelligence with Azure Synapse Link and enhanced data governance with Azure Purview, for applications that rely on the power of the SQL Server database engine. | Data Administration | Intermediate |
Kate Smith, Derek Wilson & David Pless | English | SQL Server 2022 IQP Deep Drive | Intelligent query processing is a key component to help business-critical workloads improve when running at scale, while remaining adaptive to the constantly changing world of data. In this session we will cover how the latest SQL Server versions improve performance with features and enhancements under the intelligent database feature family. These features include query store and intelligent query processing that helps improves performance and scalability with minimal changes to your application or database design. We will cover the scenarios where intelligent query processing can have the most benefit for your application workloads and how Query Store can help make it easier to identify poorly performing statements and respond to regression scenarios. We will cover Query Store use cases such as Query Store internals, performance regressions, and improvements in the latest versions of SQL Server including the new Query Store Hints improvement. | Data Administration | Advanced |
David Pless & Kevin Farlee | English | SQL Server 2022 Engine Deep Dive Part 1 | In this session we will focus on many of the storage improvements with advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power. The storage engine features and capabilities we will highlight are tempdb improvements, Always On Availability Group improvements, accelerated database recovery, shrink database with low priority, xml compression and more. We will touch on availability improvements such as Intel QAT backup compression to offload backup overhead and multi-write replication for multi-master writes users across multiple locations. Finally, we will review the security capabilities with SQL Server ledger, encryption enhancements, improvements to dynamic data masking, and more. | Data Administration | Intermediate |
David Pless & Kevin Farlee | English | SQL Server 2022 Engine Deep Dive Part 2 | In this session we will focus on many of the storage improvements with advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power. The storage engine features and capabilities we will highlight are tempdb improvements, Always On Availability Group improvements, accelerated database recovery, shrink database with low priority, xml compression and more. We will touch on availability improvements such as Intel QAT backup compression to offload backup overhead and multi-write replication for multi-master writes users across multiple locations. Finally, we will review the security capabilities with SQL Server ledger, encryption enhancements, improvements to dynamic data masking, and more. | Data Administration | Intermediate |
Venkata Raj Pochiraju | English | SQL Server 2022 – Azure integration to enable Hybrid solutions out of the box | In this session, you learn how SQL Server 2022 allows you to achieve business continuity, seamless analytics over on-prem operational data, manage, secure and govern data centrally through seamless integration with Azure services. You will learn how to leverage Azure Active Directory as a single sign-on solution for your database applications running on-premises or in other clouds. You will see how you can leverage the built-in integration with Microsoft Defender for Cloud to proactively check for vulnerabilities and get alerted for security attacks of your database application. | Data Administration | Intermediate |
Perry Skountrianos & Kendal Van Dyke | English | SQL Server 2022 “Goodies” | With over 70 new features coming in SQL Server 2022, there's a lot to get excited about! You've heard about the "meat and potatoes" features like Azure connectivity, IQP NextGen, and Contained Availability Groups. In this session, we'll cover additional features and capabilities ("goodies") that help SQL Server run faster, make it easier to manage, and simplify development, including: Accelerated Database Recovery (ADR) improvements, T-SQL Snapshot Backups, Time Series and T-SQL improvements, and a bevy of smaller improvements to get you even more excited for GA! | Data Administration | Intermediate |
Dhananjay Mahajan | English | SQL MI on Kubernetes | Data-intense workloads are increasingly deployed on K8s. Arc data service uses the elasticity and high availability provided by K8s and extends it to run business critical databases like SQL. This session will give us a simple overview of K8s and tips/tricks to run Arc data services without requiring you to be an expert. This session will go into the architectural details to help administrators and developers understand how to get the most out of Azure Arc-enabled SQLMI | Data Administration | Intermediate |
Nikita Takru | English | What is Azure Arc-enabled data services | Imagine running an Azure service on-premises or in another cloud…too good to be true? No! With Azure Arc-enabled Data Services, you can run Azure managed data services anywhere! Bringing a managed offering into the infrastructure of your choice brings benefits such as: built-in services like high availability, automatic backups, and point-in-time restore; an always-current database engine; and consistent database features and administration across environments. Join this session to learn the architecture of Arc-enabled Data Services, how to run SQL Managed Instance on it, and common use cases for this exciting new offering! | Data Administration | Basic |
Abhiman Tiwari | English | Data Replication in Azure SQL and Beyond | This session will cover data replication technologies such as CDC (with a focus on CDC in Azure SQL DB), SQL Data Sync, transactional replication, and more. The topics covered will include common use cases, benefits/limitations, demos for each of the products covered. | Data Administration | Intermediate |
Tejas Shah & Amit Khandelwal | English | SQL Server on Linux & Kubernetes! - From Zero to Hero | Continuing from the last year, this year's session is all about how you can get your SQL Server production workload deployed on your choice of Kubernetes and Linux distributions. This session will give you answers to the below questions, so if you have these question or any other questions on SQL Server on Linux/Containers then this is a session for you. And, no session is complete without Demos. This session will have lots and lots of demos that you can see and also try them in your environments after the session. 1) Do you know what stateful set SQL Server deployment means in Kubernetes? 2) What QoS(quality of Service) should SQL Server containers be deployed with? 3) Did you know, you could set HA using Always on AGs for SQL Server containers using few simple steps? 4) Do we have any reference architectures and numbers that can be shared? | Data Administration | Intermediate |
Anshul Sharma | English | Overview of Azure Data Explorer | Azure Data Explorer is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, IoT devices, and more. Join this session to learn about ADX features, common use cases, customer stories, and lots of demos. | Architecture | Basic |
Uri Barash & Anshul Sharma | English | Observational Analytics with Synapse Data Explorer | The integration of data explorer pools natively into Synapse unlocks new capabilities to bring insights from log and telemetry data into your enterprise analytics solutions. In this session we’ll review the basic capabilities, cover recent updates, and discuss plans for the future. | Data Administration | Intermediate |
Avner Aharoni | English | Building highly concurrent applications with Azure Data Explorer | Join the session to explore techniques to develop highly concurrent applications on Azure Data Explorer (i.e.. scenarios where the application is required to simultaneously handle many requests with low latency and high throughput). Use cases include large-scale monitoring and alerting dashboards. If your organization is looking to derive full potential of continuous streaming data, this session is for you. | Data Administration | Advanced |
Adi Eldar | English | Azure Data Explorer for Data Scientists | Join the session to learn about advanced analytics capabilities of ADX including native time series analytics capabilities, and ML features. | Data Science (AI/ML) | Advanced |
Charles Feddersen | English | Building Scale-out OLTP with PostgreSQL Hyperscale (Citus) | Join this session to learn how to do develop OLTP optimized databases at any scale using PostgreSQL Hyperscale | Industry Solution | Advanced |
Sudheesh Narayanaswamy & Shreya R. Aithal | English | Introduction to MySQL for the SQL Server user | Are you a SQL Server user curious about the world of open source databases like MySQL? What are the use cases and benefits to hosting workloads on MySQL? Join this session to learn more about what is MySQL, the options to host MySQL on Azure and the fully managed MySQL service Azure Database for MySQL - Flexible Server. | Data Administration | Intermediate |
Bashar Hussein & Siddhant Sawant | English | Improve database performance with Azure Database for MySQL - Flexible Server | Azure Database for MySQL - Flexible Server is a fully managed MySQL service on Azure designed to provide more granular control and flexibility over database management functions and configuration settings. In this session, you'll learn how this service provides tuned performance to handle your mission-critical applications at affordable costs with the new Business Critical service tier, and how you easily you can improve your database performance further with monitoring and customized controls. | Data Administration | Intermediate |
Shreya R. Aithal | English | Develop and deploy a MySQL application on Azure App Services. | Azure Database for MySQL - Flexible Server is a developer-friendly, affordable and fully managed MySQL service on Azure, which provides you the flexibility to develop applications using your favourite tools, languages, and frameworks, deploy faster by integrating with Azure ecosystem of services. In this session, you'll learn how to build and deploy your applications on Azure App Service, integrating with Azure Database for MySQL - Flexible Server in the backend. You'll also learn some of the best practices to apply which can help to ensure better performance, resilience and security. | Development | Intermediate |
Sunitha Muthukrishna & Vivek Gk | English | Copy and transform data in Azure Database for MySQL using Azure Data Factory or Synapse Analytics | In the world of big data, data engineers and analysts require services like Azure Data Factory (to orchestrate data movement and to transform data) and Azure Synapse Analytics (for data warehousing and analytics). You can now use ADF and Synapse Analytics to orchestrate, transform and analyse data hosted on Azure Database for MySQL - Flexible Server, the fully managed MySQL service on Azure. In this session, you'll learn how to use Copy Activity in Azure Data Factory or Synapse Analytics pipelines to copy data from and to Azure Database for MySQL, and use Data Flow to transform data in Azure Database for MySQL. | Development | Intermediate |
Avnish Rastogi | English | Migrate MySQL Databases from on-premises and other cloud providers to Azure Database for MySQL with near Zero Downtime | Join this session to learn different migration methodologies, techniques, tools and best practices to migrate from a self-managed MySQL environment running on-premises or other cloud providers to Azure Database for MySQL with near zero downtime | Data Administration | Intermediate |
Rahul Saha & Neil DSouza | English | Building fault tolerant applications with Azure Database for MySQL | Azure Database for MySQL is a fast, reliant, secure MySQL database as a service that lets customers build fault tolerant applications, in this talk we will talk about best practices on deploying fault- tolerant applications across multiple AZs in a region and globally distributed applications across regions | Architecture | Intermediate |
Sai Kondapalli | English | Scale out database write performance in Azure Database for MySQL | Join this session to learn how to improve write scalability in Azure Database for MySQL using Vitess as a sharding solution to segregate writes amongst different nodes. | Industry Solution | Advanced |
Avnish Rastogi & Sai Kondapalli | English | Leveraging ARM, CLI & Terraform to provision Azure Database for MySQL Flexible Server using private or public access | In today's world where agility and pace of development are key for a customer's business, we will talk about leveraging ARM / CLI and Terraform templates to build MySQL environments at a rapid rate. | Development | Intermediate |
Rohit Nayak, Sravani Saluru & Madhumita Tripathy | English | Protect your data in the cloud with the latest security enhancements for Azure SQL | Join this session to learn about the latest security enhancements in Azure SQL. The session will include an overview of the breadth of security capabilities available in Azure SQL, with a focus on new and upcoming investments in authentication, encryption, networking and more, with demos of the new capabilities in action. | Architecture | Intermediate |
Sandra Marin & Juliane Padrao | English | Prep for Exam DP-300 and the Azure Database Administrator Associate Certification | In this session we will review your path to Microsoft Certified: Azure Database Administrator Associate. We will check out what is covered on Exam DP-300 and which concepts to prioritize for further study. You will also receive resources to help you prepare for certification. | Data Administration | Intermediate |
Sandra Marin & James Herring | English | Prep for Exam DP- 203 and the Azure Data Engineer Associate Certification | In this session we will review your path to Microsoft Certified: Data Engineering on Microsoft Azure. We will check out what is covered on Exam DP-203 and which concepts to prioritize for further study. You will also receive resources to help you prepare for certification. | Data Administration | Intermediate |
Sandra Marin & Shannon Lindsay | English | Prep for Exam DP-500 and the Azure Enterprise Data Analyst Associate Certification | In this session we will review your path to Microsoft Certified: Azure Enterprise Data Analyst Associate. We will check out what is covered on Exam DP-500 and which concepts to prioritize for further study. You will also receive resources to help you prepare for certification. | Business Intelligence & Advanced Analytics | Intermediate |
Sandra Marin | English | Ask the Expert: Get Microsoft Certified | Microsoft has certifications for many technical job roles. And upon earning a certification, 61% of tech professionals say they earned a promotion. Join this session to learn about the process of certification and why you should take the steps to get certified. | Professional Development | Basic |
Carlos Robles, Ajith Krishnan & David Levy | English | How to migrate SQL Server databases to Azure | Microsoft provides data professionals with multiple tools and services, to handle SQL Server migrations to Azure. However, the key to a successful migration is to understand the differences and benefits of each one of these different tools and services, moreover how to leverage them according to your migration scenario. In this session, you will learn the different cloud migration strategies, phrases, and examples through demos that will help you drive a successful migration of your SQL Server to the different options in Azure; like Azure VM, Azure SQL Database, and Azure SQL MI. Join us in this exciting journey to modernize your SQL Server workloads to Azure quickly and easily! | Architecture | Advanced |
Shireen Bahadur, Chuck Heinzelman, Rodrigo Souza, Jason Huang & Wee Hyong Tok | English | Overview of Synapse Link | Synapse Link enables near real-time analytics over operational data. Join this session to learn more about Synapse Link for SQL, CosmosDB, and Dataverse. | Development | Intermediate |
Leo Li | English | Managed VNET in Cloud Scale Analytics: What's New & Best Practices | Join this session to learn about the latest enhancements being made to Managed VNET in cloud scale analytics. | Development | Intermediate |
Mark Kromer | English | What's New in Azure Data Factory | Azure Data Factory is Azure's cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management. Join this session to learn what's news with Azure Data Factory, and resources to help you get started, and be productive with ADF. | Development | Intermediate |
Ulrich Christ | English | SAP connectivity in Azure Data Factory | Join this session to learn about the latest enhancements being made to SAP connectivity in cloud scale analytics. | Development | Intermediate |
Sudhir Raparla, Rajesh Setlem & Scott Kim | English | Azure SQL availability and resiliency for modern applications | Modern applications need databases with high availability and extreme resilience. You can build the most resilient databases with highest availability using the latest capabilities of Azure SQL such as zone redundancy, geo replication, maintenance window and backup/restore. In this session you will be taken on a deep dive journey through architectures, configurations, and our industry leading SLAs which will help you get the right level of availability, resilience and disaster recovery your databases need. | Data Administration | Intermediate |
Charles Webb | English | What's new in Datamarts | Join this session to learn about the latest features and improvements to Datamarts | Business Intelligence & Advanced Analytics | Intermediate |
Srdjan Bozovic & Mirek Sztajno | English | Azure AD authentication and Microsoft Purview access policies for SQL Server 2022 on Azure Arc-enabled servers | Join this session on SQL Server 2022 security to learn about new capabilities using Microsoft Purview and Azure Active Directory authentication. With Microsoft Purview unified data-governance solution, Data Officer can assign permissions to Azure Active Directory users at a scale, without the need to run scripts or to explicitly create logins or users on SQL Servers through the org. To align with the principle of least privilege, SQL Server 2022 will make the following server roles eligible for assignment using the Microsoft Purview access policies: Data Reader, Performance Monitor, and Security Auditor. Join this session to learn how to harden the security of SQL Server 2022 deployed on Azure Arc-enabled servers with Azure AD Authentication and Microsoft Purview access policies. | Data Administration | Intermediate |
Nellie Gustafsson & Mark Hamilton | English | Massively scalable machine learning on Spark with Synapse ML | SynapseML (Previously MMLSpark) is an open-source library, aiming to simplify the creation of massively scalable machine learning pipelines. Composing tools from different ecosystems often requires considerable “glue” code, and many frameworks aren’t designed with thousand-machine elastic clusters in mind. SynapseML resolves this challenge by unifying several existing ML frameworks and new Microsoft algorithms in a single, scalable API that’s usable across Python, R, Scala, and Java. This session will provide an overview of these features, a demonstration, and resources to learn more. | Data Science (AI/ML) | Intermediate |
Manish Sharma & Sandeep Nair | English | Synapse Link for Cosmos DB Best practices | In this session you will learn what are the best practices to implement a successful analytical solution using your Cosmos DB data at no RUs cost. From data modeling to SQL serverless and Spark configurations, this session will cover everything you need to do to achieve good and scalable performance. | Data Administration | Advanced |
David Pless | English | SQL Server 2022 tempdb - The Uncontended | Over the years, there have been many recommendations regarding configuration options for tempdb. tempdb is used by every database workload for temporary storage, and additionally for internal operations. So, it’s important to get SQL Server’s tempdb as optimal as possible. The behavior of tempdb has also changed over time, but what hasn't changed is the criticality of tempdb and how its proper use and configuration can have major implications in the performance of your application. In this session we will discuss some of the improvements with tempdb in the latest versions of SQL Server and what good tempdb practices look like today. We will also discuss the improvements in SQL Server that will unlock scalability of tempdb-heavy workloads now and into the future. SQL Server has improved tempdb in every single release and SQL Server 2022 is no exception. | Data Administration | Intermediate |
Daniel Coelho | English | An in-depth look into Azure Synapse Spark | In this session, prepare to get an in-depth look into Synapse Spark to gain an understanding on how to maximize your performance for your workload. Learn more about Autoscale, Delta, and the latest features to gain an understanding of when and where to apply them. | Development | Intermediate |
Gaurav Malhotra | English | Unified data governance with Microsoft Purview | In this session, Learn how to create a comprehensive, automated map of all your data, and see how Microsoft Purview data governance works with Azure Synapse Analytics, Power BI, and the rest of your hybrid data estate to deliver timely, reliable insights—with an overview followed by a deep dive into key topics and real companies’ experiences. | Business Intelligence & Advanced Analytics | Intermediate |
Uros Milanovic | English | From bare metal to the SQL Managed Instance PaaS | Azure SQL Managed Instance is a fully managed platform-as-a-service offering for deploying SQL workloads in the cloud. As a PaaS service it relies on multiple Azure components including compute, networking, and storage. These components combined provide a variety of configuration options reflected in different service tiers powered by customer selected hardware, organized in virtual cluster, and maintained and patched in the time spans that customer define. We will go over configuration options and explain how they impact the deployment flows. | Data Administration | Basic |
Attinder Pal Singh & Balmukund Lakhani | English | Scale out read workloads with Azure SQL DB Hyperscale Named Replicas | Join this session to learn how Named Replicas enables you to scale-out a variety of read workloads, be it highly concurrent OLTP workloads or HTAP solutions for real-time data analytics. | Industry Solution | Intermediate |
Denzil Ribeiro & Balmukund Lakhani | English | Azure SQL DB Hyperscale - What's new and Beyond | Azure SQL Hyperscale, the innovative architecture of Azure SQL Database, provides applications with scale and availability needed from a cloud database. In this session, we will discuss Hyperscale architecture, including new scalability improvements in the platform. We will also discuss recently released and upcoming features, and cover Hyperscale-specific diagnostics that help gain insights into system performance. | Industry Solution | Advanced |
Richa Gaur | English | How to model and partition data in Azure Cosmos DB to achieve cloud scale | The era of cloud computing has ushered in a new era where applications now demand unprecedented levels of scale and size. Relational databases which have been with us for 50 years were never designed to ingest vast quantities of data per second, grow to Petabytes in size, or provide 99.999% availability. Enter distributed NoSQL databases which were designed specifically to deal with these and other unique challenges brought about by the cloud. In this session we will take the relational data model for a simple healthcare application and migrate it to a horizontally partitioned, NoSQL database. Along the way you will learn the concepts, techniques and technologies needed to model for a horizontally partitioned NoSQL database that will allow your application to achieve millisecond response times with near unlimited size and scalability. | Data Administration | Intermediate |
Madhumita Tripathy & Anton Fritz | English | How to protect your data when it travels from Azure Synapse to PowerBI and to office | Join this session to understand how you can leverage Microsoft Purview Information Protection capability to classify sensitive information in Azure Synapse, Azure SQL, SQL on-prem and then how these protection lebels travel to PowerBI & to Office 365 applications. | Data Administration | Intermediate |
Morgan Oslake | English | Compute auto-scaling using serverless in Azure SQL Database | Serverless in Azure SQL Database optimizes price-performance for databases with unpredictable and intermittent usage patterns. Extension of support for serverless to the Hyperscale tier in SQL DB enables native auto-scaling of compute for workloads requiring more storage or IO performance, read-scale out, or HA configuration flexibility among other benefits not available in the General Purpose tier. Join this session to learn about serverless for Hyperscale. | Industry Solution | Intermediate |
Anton Fritz, Yael Biss & Naama Tsafrir | English | Govern your sensitive data in Power BI with Microsoft Purview | Learn how you can meet your organization's compliance and information protection requirements with natively integrated into Power BI Microsoft Purview Information Protection and Data Loss prevention solutions. These solutions are widely used by Enterprises to meet compliance requirements for Microsoft 365 apps, like Office, SharePoint, Teams and Exchange. These solutions will enable you to classify and label sensitive data, protect data as it travels from Synapse trough Power BI and to Office and enable you to automatically detect upload of sensitive data leveraging content scan. | Business Intelligence & Advanced Analytics | Intermediate |
Arvind Shyamsundar | English | SQL Graph: best practices for easily modelling and querying complex data models | Have you struggled with how to represent a "many-to-many" relationship in relational tables? Has your mind been strained in the process of writing a recursive CTE to query a hierarchy? Have you given up trying to implement core graph algorithms efficiently in T-SQL? For all these cases, and more, SQL Graph provides an elegant way to model a graph (nodes and edges) built-in T-SQL support (MATCH / SHORTEST_PATH) to help with pattern matching and recursive path finding in such a graph. In this session we will use examples derived from real-world cases where SQL Graph has been used to ease development effort and enable new types of workloads on Azure SQL DB, Azure SQL Managed Instance, and SQL Server. | Development | Intermediate |
Niko Neugebauer & Uros Randjelovic | English | Azure Sql Managed Instance - the future of flexible cloud-based data centers | In a world where we're faced with ever increasing workloads and a constant pressure to decrease costs it was never more important to enjoy maximum flexibility. SQL Managed instance with a new set of features including cross subnet move, start stop and preprovisioning gives you the necessary flexibility and prepares you for the future workloads. | Data Administration | Advanced |
Niko Neugebauer, Zoran Rilak & Mladen Andzic | English | Cost optimization for workloads on Azure SQL Managed Instance | Cost savings make cloud and PaaS attractive options; however, the structure of costs in the cloud is different from the traditional on-prem model. To get the most value for the price, it is important to understand how cloud services operate, how their offerings are structured and priced, and what options exist to optimize the cost according to the workloads. This session will focus on cost optimization in Azure SQL Managed Instance. We will cover the key benefits of PaaS SQL, server consolidation, service tiers, configuration options to right-size cloud resources, SQL licensing, cost monitoring, and tools that can help you along the way. | Architecture | Intermediate |
Dani Ljepava & Mladen Andzic | English | Enjoy Azure SQL benefits using your SQL Server and Managed Instance link feature | We’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance. Embark with us on the innovation journey and hear directly from the Microsoft SQL engineering product group on how we’ve started this as an internal project codename Chimera to what became the link feature. | Architecture | Intermediate |
Aditya Badramraju & Mohammed Kabiruddin | English | SQL Server in Azure Virtual Machines - Configuring for price-performance | When selecting a virtual machine to host your SQL Server workload in Azure, you need to choose a virtual machine size that provides optimal performance and fits your organization’s budget. There are a number of different compute and storage options in Azure, so choosing the configuration that gives you the best price-performance for your workload can be a challenge. In this session, we will cover topics such as the different virtual machine types that are most appropriate for SQL Server workloads (including the new Ebdsv5 series), configuring storage, and features unique to Azure such as host caching and write acceleration that can help boost your performance without breaking the bank. | Data Administration | Intermediate |
Andreas Wolter | English | Inside data and access policies for Azure SQL and SQL Server | Join this session to gain an understanding of how policies from Azure Purview are integrated into the SQL Engine and how to troubleshoot policy based authorization with XEvents and DMVs. | Data Administration | Advanced |
Anshul Pandey | English | Emerging trends in Data & Analytics - Data MEsh | This session will help Organisation to become a data-driven (Data at scale) organization. It will open new efficiencies for Data Platform, it will help in driving innovations and unlock the new business models, eventually increasing customer satisfaction. | Architecture | Intermediate |
Balram Prasad | English | Authoring, publishing Policy and Workflows in Azure Purview | Access policies in Microsoft Purview enable you to manage access to different data systems across your entire data estate. For example: A user needs read access to an Azure Storage account that has been registered in Microsoft Purview. You can grant this access directly in Microsoft Purview by creating a data access policy through the Policy management app in the Microsoft Purview governance portal. Data access policies can be enforced through Purview on data systems that have been registered for policy. Workflows are automated, repeatable business processes that users can create within Microsoft Purview to validate and orchestrate CUD (create, update, delete) operations on their data entities. Enabling these processes allow organizations to track changes, enforce policy compliance, and ensure quality data across their data landscape. We will walkthrough how to create policy and workflow in this demo. | Business Intelligence & Advanced Analytics | Intermediate |
Daron Yöndem | English | Discover Serverless Data for Serverless Apps | Serverless is all the hype. We walk about Serverless applications but rarely look into our data services options. Building a full-on serverless architecture requires all layers to conform to our serverless world. In this session, we will look at data services in Azure that are Serverless in their nature, or can be serverless with the right implementation. | Development | Intermediate |
Eason Lai | English | Building AI/ML model effectively with Microsoft AI solutions | The demand for AI/ML models and solutions keeps rising in the digital era. AI/ML models are infused into an entire digital transformation journey, from backend operation to front-end experience. But how do we effectively build AI/ML models to fulfill the demands? In this session, I will share how to leverage Microsoft AI & Platform solutions to build AI/ML models in an effective way. | Data Science (AI/ML) | Intermediate |
Florian Eiden | English | You know SQL? Then you're set for real-time data processing with Azure Stream Analytics | You know SQL? You need to process data in real time? Azure Stream Analytics (ASA) is the service for you. But let's dig a bit deeper and understand what makes a streaming query in ASA different from a T-SQL one in SQL Server._x000D_ _x000D_ In this session we'll start by a short introduction to stream processing and its typical applications like Streaming ETL or real-time dashboarding, Then we'll focus on the 3 key aspects that we need to keep in mind when working on our streaming SQL queries in ASA._x000D_ _x000D_ First we'll talk data types. We'll see how to best handle the complex ones (JSON nested records and array), but also that ASA applies types at the row level (which is both awesome and treacherous) and how to deal with it._x000D_ _x000D_ Then we'll discuss the temporal aspect of stream processing, in theory and how it's implemented in ASA. That means time skew policies, windowing functions and how timestamps evolve as data flows through query steps._x000D_ _x000D_ Finally we'll have a performance conversation. We'll see how partitioning a stream differs (or not) from partitioning a table. We'll take a look at the metrics to monitor and how/when to scale an ASA job._x000D_ | Business Intelligence & Advanced Analytics | Advanced |
Gonzalo Bissio | English | Azure SQL Managed instance HA-DR Options to ensure business continuity | On this session we are going to talk about all the high availability and disaster recovery options in Azure SQL Managed Instance. Internals and demos are ensured! | Data Administration | Intermediate |
Jayendra Khatod | English | Explore the Azure Data Explorer | Join this Pre-con for an immersive learning experience on the Microsoft Azure Data Platform which will prepare you for DP-203 certification. _x000D_ Understand Big data engineering as it pertains to working with batch and real-time analytical solutions using Azure Synapse, Databricks, Stream Analytics etc._x000D_ Cover end to end Data Engineering from ingestion of differently formatted data to processing-transformation, storing in data lake and data warehouse and visualizations through Power BI and also integration with AI/ML and dev-ops. | Business Intelligence & Advanced Analytics | Advanced |
Namrata Sherkhane | English | Customer Use cases on latest Azure AI Services | Detail discussion on how Azure AI services have solved real world customer challenges. Case studies on digital document processing , IVR chat bot etc | Data Science (AI/ML) | Intermediate |
Srikantan Sankaran & Bishnu Agrawal | English | Large scale Bulk Data ingestion | Join us to understand the approaches & Best Practices in bulk ingestion of large datasets from Azure Data Lake Stores into Databases (OLTP, OLAP and HTAP), using Spark with Azure Databricks | Data Administration | Intermediate |
Bishnu Agrawal & Vishakha Arbat | English | Deliver Personalized experience with Customer Data Platform | Join us to understand how Microsoft Customer Data Platform(D365 Customer Insights) helps deliver personalized customer experience. In this session, we will showcase, how can you easily plug in customer profiles from first and third party data sources. Get 360-degree customer views and derive out-of-the-box insights with prebuilt AI models. | Business Intelligence & Advanced Analytics | Intermediate |