Sessions, Agenda & Schedule

At DPS 2021, 130+ Sessions were delivered by 150+ Speakers. Each Session was approximately 60 to 75 mins, including Q&A time. So that is a whopping 200+ hours of learning content across the entire stack of Azure Data, Analytics & AI. Check out the feedback from the delegates.


click Here To Access

Data & Analytics Summit   Data & Analytics Summit

Complete Sessions List

Highlights

Breakout Sessions

Deep-Dive Sessions

Demo-Only Sessions

Short-Drive Sessions

Data + AI Gurukul

DaySessionTitleSpeakerNameTrackAbstractStart_Time(UTC)End_Time(UTC)RoomView In Your Timezone
Day 1Welcome NoteDPS Team13-09-21 5:0013-09-21 5:25HydraView In Your Timezone
Day 1SQL Server on Linux- Deployments made easy!Amit KhandelwalData AdministrationThis is going to be a fast paced demo filled session, where we spend time on how you can automate the SQL Server deployments across Azure Linux VMs. We also will talk about how we can configure the SQL Server HA on Azure Linux VMs, key aspect of how you can rotate keytabs for AD authentication and if time permits we will bind all this together with a monitoring solution all this in 60 min, so fasten your seatbelts and enjoy!13-09-21 5:3013-09-21 6:45HydraView In Your Timezone
Day 1Quicker, faster and easier Power BI datasets using Power BI Premium Per User/PremiumGilbert QuevauvilliersBusiness Intelligence & Advanced AnalyticsIn this presentation I will explain what Power BI Premium per user is and what is the difference between Power BI Premium.

I will then go through and demonstrate the advantages with tips and tricks on how to use PPU for quicker, faster and easier deployments by using the new 3rd Party Tools.

I will demonstrate the following tools and how they can enable you to do more in a shorter amount of time

Tabular Editor

Creating Measures

Formatting of all DAX Measures

Creating Calculation Groups

And more…

ALM Toolkit

Granular Deployment of new columns

Granular deployment of new or existing measures

Updating Power Query and deploying the changes.

And more…

DAX Studio

Creating measures to test

Testing measure performance

Understanding what is taking up memory in your dataset

And more…

13-09-21 5:3013-09-21 6:45SphinxView In Your Timezone
Day 1Data Modelling in Azure Cosmos DBWill VelidaDevelopmentModelling your data correctly is vital when building efficient applications that use Azure Cosmos DB. Proper data modelling allows us to easily scale our Cosmos DB resources as our applications grow.

Many developers fall into the trap of thinking that just because Azure Cosmos DB is a NoSQL service, we don’t need to spend time modelling our data. Lack of attention to proper data modelling in Azure Cosmos DB can lead to poor performing apps that can’t scale and are expensive to run.

In this session, we will cover:

– Why you should model your data correctly for NoSQL databases and how this is different to relational data modelling.

– When you would reference entities in NoSQL vs embedding entities in your documents.

– How partitioning and collections factor in when modelling our data and how we can design our collections accordingly.

By the end of this session, attendees will be empowered with data modelling techniques that they can use to build highly scalable and successfully applications that use Azure Cosmos DB.

13-09-21 5:3013-09-21 6:45ShilohView In Your Timezone
Day 1Power BITom Martens13-09-21 5:3013-09-21 6:45HekatonView In Your Timezone
Day 1Azure Synapse AnalyticsDavid Alzamendi13-09-21 5:3013-09-21 6:45KatmaiView In Your Timezone
Day 1Advanced Conditional Formatting in Power BI

Adewale Yusuf

Business Intelligence & Advanced Analytics

Learn to configure conditional formatting rules to add colours & dynamic text to Power BI Dashboards

13-09-21 7:0013-09-21 8:15SphinxView In Your Timezone
Day 1Zero downtime database deploymentsAlex YatesDevelopmentYou understand that big bang deployments are painful, but

each deploy may disrupt users, so you are restricted to

tight deployment windows for your database. The consequences

of missing your windows aren’t worth thinking about – but it

gets more difficult each time.

In order to move to smaller, more frequent and more reliable

deployments you need to demonstrate that you can safely

deploy during business hours – without disrupting users.

In this session we’ll discuss the most popular strategies:

Blue/Green and Canary deploys, Cluster Immune Systems and

Feature Toggles. Then we’ll discuss the fundamental changes

that we need to make to the way we think about database

“deployments” and “releases” in order to support these

strategies.

We will finish with a SQL Server demo that uses a feature

flag and the expand/contract model to support backward

compatibility and safe, fast rollback options.

13-09-21 7:0013-09-21 8:15ShilohView In Your Timezone
Day 1The ML HeroÂ’s Secret Weapon: AutoMLDaron YondemData Science (AI/ML)If you are into development, you know that we love to automate things we don’t want to do. Do you still want to work on training the same model over and over using different features or hyperparameters to preventing over-fitting? I did not think so. Let’s see how AutoML can help you.13-09-21 7:0013-09-21 8:15YukonView In Your Timezone
Day 1Azure Function for Everyone.

Alpa Buddhabhatti

Development

In this session, we will provide you with an overview of Azure Function. Azure Function is a fully managed serverless integration service. A use case with Azure Function and Azure Blob Storage and Azure Key Vault will be used for a demo. You’ll also learn about Continuous Integration and Continuous Delivery of Azure Function objects using Azure DevOps Pipelines.

At the end of this session, you’ll have a basic understanding of both Azure Function and Azure DevOps. You can apply these ideas to event driven scenarios and the automation of Azure Function pipelines.

13-09-21 7:0013-09-21 7:30KilimanjaroView In Your Timezone
Day 1Power BINikola Ilic13-09-21 7:0013-09-21 8:15HekatonView In Your Timezone
Day 1Run Microsoft Azure Arc enabled data services anywhereBapi ChakrabortyArchitectureThis lightening talk (with a short demo) will focus on Architecture and solutions made possible by Azure Arc enabled data services anywhere. With latest innovation, we are now able to run always updated, scalable, Azure data services on any infrastructure. With Azure Arc, any enterprise can deploy Azure SQL Managed Instance or PostgreSQL (with hyperscale) to supported Kubernetes infrastructure whether on-premises, on any cloud or at the edge. This also includes unified & at scale management and always updated services.13-09-21 7:4513-09-21 8:15KilimanjaroView In Your Timezone
Day 1Automation with SQL, PowerShell, & Interactive NotebooksMikeProduct Showcase (For Sponsors)At Pure, our Solutions’ team has created some simple, effective, and scalable automation toolkits for SQL Server, FlashArrays, cloud, and more. In this session, we will take a walk through some of the integrations that we have developed and show how they work. These will include the PowerShell SDK, PowerShell Toolkit, and .Net Interactive Notebook learning scenarios utilizing a Pure Validated Design. If your interested in automation using frameworks and toolkits, or learning cool things with Interactive notebooks, come join our session!13-09-21 8:3013-09-21 9:45HydraView In Your Timezone
Day 1Doing IoT from Scratch – how we deliver successful IoT projectsBenjamin KettnerProduct Showcase (For Sponsors)At ML!PA we have our own take on IoT projects, we will walk you through our company and show you how we are able to deliver successful IoT projects from scratch.13-09-21 8:3013-09-21 9:45SphinxView In Your Timezone
Day 1Building a Production Environment for Azure Arc enabled Data ServicesChris ADKINData AdministrationThinking of transforming your on-premises SQL Server estate to a farm of Azure Arc managed SQL Server instances ?, and you want the setup to be production grade, then this session is for you, it will cover Kubernetes distro options, storage plugin options, options for backup and restore, load balancing and everything that you need to consider in order to build a production grade environment. This session assumes that attendees will have a basic working knowledge of containers and Kubernetes.13-09-21 10:0013-09-21 11:15HydraView In Your Timezone
Day 1Enterprise data governance with Azure Purview

Richard Conway

Architecture

In this session Richard Conway will talk about how to build an enterprise data governance strategy with Azure Purview. He will describing patterns and practices of data governance and how to use features of Azure Purview within complex Hub and Spoke cloud network topologies.

Richard will consider the gap in the current Purview offering and how to fill the gap. There will be fast paced demos showing Azure Purview setup, Purview automation and usages of the Apache Atlas API to get catalogue information.

Richard will show how to integrate Purview into pre-existing Azure Data Platform and Cloud Data Warehouse deployments that have built using Azure Data Factory, Azure Databricks and Azure Synapse.

13-09-21 10:0013-09-21 11:15YukonView In Your Timezone
Day 1All You Wanted to Know About CollationsErland SommarskogDevelopmentCollations is a topic that tends to confuse SQL Server professionals. It is not that the implementation of collations in SQL Server is extremely confusing, but computer people are not always well versed in human languages and character encodings, and therefore it can be a big surprise that V and W could be considered equal or that i and I could be different in a case-insensitive comparison.

In this light-minded presentation I cover what a collation controls and I explain what all the funny components in a collation name like Latin1_General_100_CI_AS_KS_WS_SC_UTF8 actually mean. I illustrate this by giving examples of how they work with different languages. I provide some tricks you can apply to overcome some traps related to collations. I give particular attention to the UTF-8 collations added in SQL 2019. Finally, I discuss how the choice of collations can affect performance.

13-09-21 10:0013-09-21 12:00KilimanjaroView In Your Timezone
Day 1Monitor Azure SQL DatabaseTaiob Ali13-09-21 10:0013-09-21 11:15HekatonView In Your Timezone
Day 1Power BI Reports Embedded in SharepoingAndrea Martorana Tusa13-09-21 10:0013-09-21 11:15KatmaiView In Your Timezone
Day 1Power BI scenarios for automated monitoring

Andrea Martorana Tusa

Business Intelligence & Advanced Analytics

Power BI grows at an exponential rate and so probably does your environment.

Many new users every day, workspaces, data sources etc. How to deal with it?

For a Power BI tenant’s administrator it’s a challenging task keeping everything under control, documenting the model, tracking changes, cleaning it up, knowing which dataset is used and which one isn’t.

What is needed is automation. Monitor workloads, track changes, read and download logs, set alerts, handle contents and artifacts.

How to achieve this goal? Through the use of the three automation pillars: Powershell, Microsoft Flow, Power BI APIs.

Many examples will be illustrated during the session, based on a customer implementation where the Power BI admin plays a central role for governance and management of the solution.

13-09-21 11:3013-09-21 12:45SphinxView In Your Timezone
Day 1Test Driven Database Development

Magnus Ahlkvist

Development

est Driven Development, or TDD, means we start with unit tests, even before writing our code. When done properly, TDD leads to higher quality systems. It gives us good test coverage, it’s automated and it gives us good regression testing.

To isolate the unit tests, so that they only verify the behaviour of an invidiual method or function, everything outside of the function is mocked. This is a really good idea. If we write a function ConvertCurrency and that function calls service GetCurrencyRate(date,currency), create a mock service which always returns the same value.

How about unit tests for the service GetCurrencyRate? The service probably gets the currency rate for a certain date/currency combination from a database, perhaps through the stored procedure call Finance.GetCurrencyRate. And just like the unit tests for ConvertCurrency uses a mock service for GetCurrencyRate, the unit test for GetCurrencyRate will use a mock for the stored procedure Finance.GetCurrencyRate.

But who will test the stored procedure Finance.GetCurrencyRate?

In this session we will talk about test driven database development. How we can apply the TDD methodology to database development. We will look at the most common unit testing frameworks and how they integrate with database development environments. We will look at unit test design and how we can isolate unit tests to only test the logic of an individual statement, view, stored procedure or user defined function.

13-09-21 11:3013-09-21 12:45ShilohView In Your Timezone
Day 1Azure SQL DB, MI and VMAmeena Lalani13-09-21 11:3013-09-21 12:45KatmaiView In Your Timezone
Day 1SSIS in ADFSandy Winarko13-09-21 11:3013-09-21 12:45HekatonView In Your Timezone
Day 1Data Platform Confusion: What are viable Data Platform Options when considering Azure from On-Prem?

Charley Hanania

Architecture

Modernising and Migrating to the Cloud can be both destabilising and opportunistic, depending on how it is approached. If someone you’ve been given the “”Lift-and-Shift”” option as preferred, think about all the history and practices that are inherent on-premises that you may want to correct through this transition.

In this session, Charley will go through the options for storing and using data in the Azure Cloud versus what may have been available on premises and how light through to heavy redesigns can open your platform and systems up to safer, scalable and more flexible capabilities.

There are so many options that it can be difficult to determine which architecture options are right for which scenarios, so this should shed some light on capabilities and opportunities that may not have been considered.

13-09-21 13:0013-09-21 14:15YukonView In Your Timezone
Day 1Getting Started with Extended EventsKathi KellenbergerData AdministrationOver the years, many DBAs have avoided using Extended Events and continued using Trace. At first, this made sense because Extended Events had no user interface and you had to know XML to work with it. Eventually, Microsoft added a GUI, but many folks continued to use familiar tools. In this session learn how to transition from Trace to Extended Events. YouÂ’ll find that itÂ’s easy when you take the right approach.13-09-21 13:0013-09-21 14:15HydraView In Your Timezone
Day 1Building Event-Driven Microservices with the Azure Cosmos DB Change FeedLeonard LobelDevelopmentThe change feed in Azure Cosmos DB is one of the most overlooked features of MicrosoftÂ’s globally distributed, massively scalable, multi-model database service. Similar to the transaction log of a relational database, the change feed gives you a continuous record of changes as they occur. It therefore serves as an excellent event source for a wide range of cloud-based microservices. In this demo-filled session aimed at developers and data professionals alike, youÂ’ll learn how to leverage the change feed and build event-driven microservices with Azure Functions to achieve replication, denormalization, notifications, materialized views, and data archival.13-09-21 13:0013-09-21 14:15ShilohView In Your Timezone
Day 1Benefits of Installing IaaS Agent Extension on Azure SQL VMAmeena Lalani

Data AdministrationSQL Server IaaS Agent Extension, formerly known as Resource Provider, enables additional management capabilities for self-installed SQL Server on Azure VMs. It provides PaaS-like capabilities to IaaS-based SQL for customers who adopt it. During this session, I will demonstrate some of the unique benefits of the SQL IaaS extension that will help you discover, manage and administer your SQL Servers in Azure VM.

This is what you are going to learn in this session.

1. What is IaaS?

2. What is IaaS Agent Extension?

3. What are the Benefits of enabling this extension?

4. How to enable and disable this extension?

13-09-21 13:0013-09-21 13:30KilimanjaroView In Your Timezone
Day 1SQL Server on-prem or in the CloudMichelle Gutzait13-09-21 13:0013-09-21 14:15HekatonView In Your Timezone
Day 1Machine Translation – Empowering users and organization to be more productive by minimizing the language barrier

Charan Mohan

Data Science (AI/ML)

As businesses and supply chains have globalized, organizations need to continue to remain productive ensuring language is not a barrier for communication. Not only large organizations but large populations of multi-lingual societies are now trickling into the digital world for the very first time. Businesses are now looking to tap into this underserved user populace which represents a significant opportunity (The next billion users). Microsoft, through our Translation API (as part of azure cognitive services) provides developers and users with the ability to embed machine translation into their services and platforms thus enabling translation of text in real time or in batch across 90 languages and dialects. The translation service is built atop the latest advancements in neural machine translation (NMT) with built in data security. In this talk, I will walk through the various capabilities offered by the Azure cognitive- Translation service and how these services are being employed to reduce barriers to adoption across products and services both within Microsoft and by other customers.

We will dive deep into aspects of Text translation, language detection, transliteration, document translation and the ability for organizations to train and deploy custom translation models via the custom translator API.

13-09-21 13:4513-09-21 14:15KilimanjaroView In Your Timezone
Day 1KeynoteBob Ward, Anna Hoffman & Buck Woody13-09-21 14:3013-09-21 16:00HydraView In Your Timezone
Day 1Vision in Microsoft Azure Cognitive ServicesAndreas ErbenData Science (AI/ML)Microsoft Azure Cognitive Services offers various commoditized yet powerful and sophisticated services to work with visual content through Computer Vision.

Currently those services can

– detect and recognize Faces,

– classify images or find objects in an image

– run spatial analytics on video,

– understand rich information in an image,

– process whole videos and get insights from the video

– recognize handwriting and ink in applications

– provide OCR (Optical Character Recognition) on documents

– automatically parse a scan of a paper form.

This fast paced session will introduce the currently available set of services and explain through sample code and demonstrations how to use them.

13-09-21 16:1513-09-21 17:30YukonView In Your Timezone
Day 1Automated provisioning of SQL Server VMs on AzureKay Sauter

Development

If you need to have an (almost) fully automated deployment of a SQL Server VM including restoring databases and installations of needed software on Microsoft Azure, this PowerShell demo shows how.13-09-21 16:1513-09-21 17:30ShilohView In Your Timezone
Day 1SQL Server on Azure Virtual Machines Reimagined: OverviewPam Lahoud, David Pless, Aditya Badramraju & Rajesh SetlemData AdministrationRunning SQL Server in an Azure virtual machine gives you the same capabilities and experience you are used to with on-premises SQL Server, plus the additional ease of use and management benefits available only on Azure. In this session, we will discuss the SQL Server in Azure VM experience, including some new features of the SQL Server IaaS Extension that help you optimize cost, enhance security, improve manageability and increase uptime for your SQL Servers in Azure. Expect a focused session on best practices and proven methods to get the most out of your Azure SQL VM experience.13-09-21 16:1513-09-21 17:30HydraView In Your Timezone
Day 1PowerBI Vision, strategy and roadmapPatrick LeBlancBusiness Intelligence & Advanced AnalyticsPower BI is helping organizations large and small, drive a data culture. We will cover our vision and roadmap. You will learn how AI automatically finds patterns in your data, you will learn about how Power BI is built into Teams and Excel to enable incredible collaboration experiences, and how Power BI with Synapse and other Microsoft technologies meets your most demanding needs.13-09-21 16:1513-09-21 17:30SphinxView In Your Timezone
Day 1Docker Deep DiveAndrew PruskiData AdministrationRunning SQL Server in a Docker container has many benefits (and drawbacks!) that we as SQL professionals should be aware of.

In this demo heavy session we’ll dive deeper into running SQL Server in Docker containers. We’ll cover: –

What exactly is container isolation?

Container networking

Persisting data for SQL Server in Docker containers

Building custom SQL Docker images

Running SQL containers with Docker Compose

This session is for anyone who has run SQL Server in a container and wants to learn more about the platform

13-09-21 16:1513-09-21 17:15KilimanjaroView In Your Timezone
Day 2Modernize your Oracle Workloads to Azure SQLAlexandra CiorteaData AdministrationAre you looking to leave Oracle behind? Join us to find out how to accelerate the migration journey by automating Oracle migrations to SQL Server using 1st party tools as SQL Server Migration Assistant  and Data Access Migration Tool14-09-21 5:3014-09-21 6:45HYDRAView In Your Timezone
Day 2Enabling Data with Azure ArcDaman KaurData AdministrationThe session covers Azure Arc-enabled data services in detail.

Azure Arc enabled SLQMI, SQLDB, Postgres Hyperscale,

Business use cases for each of the services and when to choose each over others.

As a bonus, we will see how we can leverage azure monitor to manage the SQL workload running on On-prem infrastructure over the Kubernetes cluster.

14-09-21 5:3014-09-21 6:45YukonView In Your Timezone
Day 2Tips and Tricks to Modernize Power BI Paginated Reports

Hariharan Rajendran

Business Intelligence & Advanced Analytics

The demand for Power BI Paginated reports is keep increasing from the announcement of Premium Per User License and most of you interested to learn. This session is for all report developers who started working with Power BI Paginated Reports.

In this session I will be explaining how to make modern paginated reports with different built-in features. If i say modernize, it does not mean that I am covering only the look and feel of the reports. I will be explaining what kind of features are available and how you can effectively use them and how the tool can compete with other BI tools. Basically, I will be showing the hidden gems of Paginated Reports. In simple, this session will cover development, automation, performance and etc with Paginated Reports.

14-09-21 5:3014-09-21 6:45SphinxView In Your Timezone
Day 2Azure Database for MYSQL – Flexible Server

Sravani Saluru

Data Administration

Azure Database for MySQL – Flexible Server is a fully managed MySQL database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. In this session we will cover

Overview of Single and Flexible Server for MYSQL Azure DB

Performance

Monitoring & Security

High Availability & Disaster Recovery

Migration strategies

Q&A

14-09-21 5:3014-09-21 6:45ShilohView In Your Timezone
Day 2Power BIMarkus Ehrenmueller-Jensen14-09-21 5:3014-09-21 6:45KatmaiView In Your Timezone
Day 2Data Lakehouse Architecture with Azure Synapse AnalyticsDavid AlzamendiArchitectureWhat are Data Lakehouses? When and why should you use this design pattern? How are they different from Data Warehouses?

This session will answer these questions and expand on how new architecture design patterns can help you solve some of your business problems and prepare for the future.

You may have heard about Data Lakes and data warehouses, but as technology evolves, there are new design patterns like Data Lakehouses that you should take into account when building data solutions.

14-09-21 5:3014-09-21 6:30KilimanjaroView In Your Timezone
Day 2Protect your SQL assets anywhere with Azure Defender for SQLDavid Trigano & Michael MakhlevichData AdministrationSQL assets are critical resources and contain the most precious information a company owns, which makes them one of the preferred target for attackers. Protecting them across the environments can be challenging and requires multiple skills to deploy, manage, and remediate those precious resources. In this session, you will learn how Azure Defender for SQL protects your SQL anywhere, and offers capabilities to discover misconfigurations and raise alerts in case of usual activities across every flavor or SQL you are using today, in any environment.14-09-21 7:0014-09-21 8:15HydraView In Your Timezone
Day 2Tips & Tricks for creating Paginated Reports based on Power BI datasetsFerenc CsonkaBusiness Intelligence & Advanced AnalyticsPower BI is a world-class BI and data analytics tool with stunning interactive data visualization features, but in many business use cases companies need to produce multi-page printouts from their Power BI reports on paper and/or send them in PDF/Excel format to their customers. Power BI Paginated Reports based on the matured and well-known SSRS (SQL Server Reporting Services) technologies can be created from existing Power BI datasets using the Power BI Report Builder tool and can be published to Power BI Service. The recently released PPU (Premium Per User) license and Power BI Embedded Gen2 will also help to have an increasing number of paginated reports in the Power BI ecosystem. Moreover, Paginated Reports visual in Power BI also helps and accelerates the implementation of paginated reports based on existing Power BI datasets.

Therefore, in this session, we will present several tips & tricks how to create paginated reports using existing Power BI datasets available in the Power BI Service and also from your Power BI Desktop, how to reproduce the different Power BI visuals in a paginated report, how to create analytical lines in a paginated report, how to handle parameters, especially multi-value parameters in DAX queries, how to enable for the end-users to select which Power BI report pages should be included in the final printout, how to create printouts with portrait and landscape pages, etc.

14-09-21 7:0014-09-21 8:15SphinxView In Your Timezone
Day 2How to do Real-Time Analytics Using Apache Kafka and Azure Data ExplorerNeils BerglundDevelopmentThe de facto standard for real-time event streaming is Apache Kafka, and a lot of businesses are streaming tons of data; business events, IoT/telemetry events, etc. The problem is how we can perform analytics and get business insight into the data we are streaming over Kafka.

The answer to this is Azure Data Explorer (ADX). 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. It is a big-data analytics database that allows ingestion of event streams from, among others, Apache Kafka.

In this “demo-heavy” session, we see how we stream event data from Apache Kafka (running on Confluent Cloud in Azure) into Azure Data Explorer.

Some of the topics we cover:

* Overview of Apache Kafka and Confluent Cloud.

* Introduction to Azure Data Explorer.

* Ingestion of data from Kafka into ADX.

* Analyse ingested data in ADX.

14-09-21 7:0014-09-21 8:15ShilohView In Your Timezone
Day 2How to achieve the best performance and scalability on your Azure SQL Database using the HyperscaleVitor FavaArchitectureIn this session let’s discuss Hyperscale, an Azure SQL Database tier that allows us to create a high-performance environment for OLTP intensive workload scenarios.

We’ll understand the architecture of Hyperscale and how we can create and configure the replicas to redirect any intensive report to avoid any issues on your production environment

14-09-21 7:0014-09-21 8:15YukonView In Your Timezone
Day 2Serverless AI  Daron Yondem14-09-21 7:0014-09-21 8:15KatmaiView In Your Timezone
Day 2Microsoft latest Web UI technology, Blazor, working with Azure SQL Azure database in cloud

Ming Man Chan

Development

The topic is targeted at startup organizations that have limited resources to develop coding and maintain the infrastructure. ASP.NET has been using many JavaScript and proven hard to maintain. Thus, Microsoft has emerged a new platform to do all the necessary code in C#, Blazor. Blazor uses open web standards without plug-ins or code transpilation. Blazor is able to work in all modern web browsers, including mobile browsers. In order to setup servers and maintain databases is not cost efficient for the startup company. By using SQL Azure Database organization can mitigate the infrastructure cost and focus on the business core competency. In this short session you will learn how to get started with Blazor UI as a frontend and SQL Azure as a backend for your solution.14-09-21 7:0014-09-21 7:30KilimanjaroView In Your Timezone
Day 2Power BIMohammed Adnan14-09-21 7:0014-09-21 8:15KatmaiView In Your Timezone
Day 2Remote Work and Certifications

Oluwaseyi Oluwawumiju

Professional Development

The session will take a dive into the new Role base certification and its effect and how we can align it with remote jobs.14-09-21 7:4514-09-21 8:15KilimanjaroView In Your Timezone
Day 2Delta Lake with Azure Databricks – Let’s build a reliable Data Lake!

Mohit Batra

Business Intelligence & Advanced Analytics

While Data Lakes allow us to store massive amounts of data, there are many challenges that come along – maintaining data and multiple files, providing consistency to downstream applications, handling updates, data recovery in case of failures, slower transactional query performance, consolidation of streaming data and much more. On the other hand, Data Warehouses based on relational databases, handle many of these challenges, but they do not scale well and are expensive to maintain.

Are you interested to build a large-scale, reliable Data Lake?

This session will take you through Delta Lake – an open-source storage layer that brings ACID transactions and reliability to your data lakes. It can scale to handle TBs and PBs of data, handle updates, combine and store batch and streaming data, as well as data and metadata management. And this is what we will look into, via demos:

1. What is Delta Lake, and its features

2. How to get started with Delta Lake using Azure Databricks

3. How to handle Inserts, Updates, Deletes and Merge for the records

4. How it provides ACID guarantees, using transactional logs

5. How Time Travel works

6. How schema enforcement and schema evolution works

7. How data clustering, and clean up works

8. And compare it with Parquet format in terms of features and performance

These features of Delta Lake can truly help you build large-scale data warehouses in your Data Lake.

14-09-21 8:3014-09-21 9:45SphinxView In Your Timezone
Day 2Build your first recommendation engine using AWS Personalize with Zero ML experienceSandip PaniData Science (AI/ML)

Recommendation Engine is one of the demanding feature now almost everyone wanted to build. In this session we will learn how to design the recommnedation engine from scratch. If you are new to ML world or no prior knowledge about Data science no worries, We will learn together what is a recommnedation engine , what are the things you need to consider to build your own recommendation engine. In this rapid development world we need to first build with minimal time and validate your MVP. Come join with me to learn how to build recommendation engine step by step using AWS personalize.14-09-21 8:3014-09-21 9:45ShilohView In Your Timezone
Day 2Simplify data management with partitioningUwe RickenDevelopmentThe times of small database systems are now over. Even “small” systems already provide databases with several 100 GB data volume. It can be a real challenge for the DBA to complete the daily maintenance tasks, data backup, consistency checks, … in a reasonable time frame.

With the help of partitioning (also a feature of the Standard Edition since SQL 2016), considerable advantages in ETL processes, maintenance and backup / recovery can be achieved.

The main area of application for partitioning is the optimization of the load paths for complex DWH solutions and the maintenance of large databases (statistics, indexes, backups, restores). The very strongly demo-based session shows partitioning scenarios that let the DBA do alternative things again and encourage ETL developers to dance the joys.

14-09-21 8:3014-09-21 9:45HydraView In Your Timezone
Day 2Why Data Governance is important and how you can start immediately with Azure PurviewWolfgang StrasserArchitectureCollecting data is one part of the story. To know your data estate is another part. Let’s see how Azure Purview can help you to manage and govern your data estate and bring it to another level.

No matter if the data resides in a database, SAP, Power BI or a datalake – Azure Purview can scan and help you classify your data estate.

Join this session if you want to know how Azure Purview can be a solid part of your data cataloging strategy and how easy it is to start with your Azure Purview environment.

14-09-21 8:3014-09-21 9:45YukonView In Your Timezone
Day 2Top 13 best security practices for Azure

Radu Vunvulea

Architecture

Security nowadays is just a buzzword. Even so, by joining this session, we discover together what are the most important security best practices that you need to have in mind when you work inside the cloud – inside Microsoft Azure.

14-09-21 8:3014-09-21 9:00KilimanjaroView In Your Timezone
Day 2SQL Server on Linux/Containers and KubernetesAmit Khandelwal14-09-21 8:3014-09-21 9:45KatmaiView In Your Timezone
Day 2Azure Machine LearningNeil Hambly14-09-21 8:3014-09-21 9:45HekatonView In Your Timezone
Day 2AI: Powering New Possibilities with Indian Languages

Shaily Goel

Data Science (AI/ML)

AI growth in India is happening at exponential level. As per the Accenture report, AI will add $957million to Indian Economy by 2035. Today more and more Indian users are using internet. Phone growth is massive. 9 out of every 10 users uses phone to communicate. However Large portion of this population still cannot read and write. Voice is the important communication media for all these users. These users will harness the power of internet eventually in their own vernacular language. Hence Government is pushing hard enterprises to enable AI for barrier free communications. Initiatives like NLTM are steps towards it. Multiple Indian startups are funded that taps into regional language. Voice, vernacular and video will be important pillars of the India AI growth. . This talk aims to showcase the work Microsoft is doing in this space for India market, showcasing use cases that are powered by these AI services for India.

14-09-21 9:1514-09-21 9:45KilimanjaroView In Your Timezone
Day 2SQL Stateful Containers on Kubernetes with Helm!Amit KhandelwalData AdministrationSQL Server is a stateful application and hence should be deployed as a stateful set. In this session, we look at the helm method of installing multiple instances of SQL Server as stateful deployments, look at the recommendations and best practices when running SQL Server on containers for production environment. After this session, you can go ahead and look to take the next step towards modernization of your data estate via SQL containers!14-09-21 10:0014-09-21 11:15HydraView In Your Timezone
Day 2Insight Discovery – how to define business requirements for a successful cloud data & analytics projectJames BroomeBusiness Intelligence & Advanced AnalyticsMany data projects fail to deliver the impact they should for a simple reason – they focus on the data. In this session, James explains a different way of thinking that will set up your data & analytics projects for success. Using an iterative, action-oriented, insight discovery process, he will demonstrate tools and techniques that will help you to identify, define and prioritize requirements in your own projects so that they deliver maximum value. He’ll also explore the synergy with modern cloud analytics platforms like Azure Synapse, explaining how the process and the architecture actively support each other for fast, impactful delivery.14-09-21 10:0014-09-21 11:15YukonView In Your Timezone
Day 2Enough of the Azure Pipeline GUI demos for Data Platform deploymentsKevin Chant & Sander StadDevelopmentI’m sure plenty of you have being there before. Hoping to see some YAML being used for real-life scenarios CI/CD deployments in Azure DevOps, only for the demos shown to be GUI based using the Classic Editor.

Well fear not, for in this session we will cover how to use YAML in Azure DevOps for your CI/CD deployments. In this advanced session we will show you how to use YAML for Microsoft Data Platform deployments. Aimed mostly at SQL Server related services, including SQL Server and Azure Synapse SQL Pools. Along the way well also cover other topics like PowerShell and Containers.

You will see a reasonable amount of YAML in this session, which is why we class this session as a borderline expert/brain-hurting one. You might want to bring along pen and paper to take down some notes and help with muscle memory, or at least bring something electronic to enter notes in.

We will show you demos for some real-life scenarios, including Unit Testing for both SQL Server and Azure Synapse SQL Pools.

14-09-21 10:0014-09-21 11:15ShilohView In Your Timezone
Day 2Power BI Performance – 7 deadly sins!Nikola IlicBusiness Intelligence & Advanced AnalyticsCongratulations! You’ve built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever…Or, your report is utterly slow when interacting with visuals…You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more…

And, if you feel lost, I don’t blame you – I’ve also been there!

That’s why this session is for you: we will examine potential bottlenecks in your Power BI report – starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.

14-09-21 10:0014-09-21 11:15SphinxView In Your Timezone
Day 2Serverless Azure data handlingBenjamin KettnerDevelopmentHow can serverless services help you when building a data application in Azure? What serverless services exist and how do they align with the requirements of data applications? How can you use them and how do they interact?

In this all-demo-session (1 slide only) we will show you how to build a data processing pipeline using serverless services. you will learn some details that will help you to build a modern datawarehouse in Azure or any other application that handles volumes of data.

14-09-21 10:0014-09-21 11:00KilimanjaroView In Your Timezone
Day 2Power BI GovernanceAugustin Dokoza Bukvic14-09-21 10:0014-09-21 11:15KatmaiView In Your Timezone
Day 2Starting with Azure SQL Edge on Raspberry PiHasan SavranIndustry SolutionAzure SQL Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on resource-constrained interactive devices such as cameras, scanners, IoT gateways, and light-weight edge servers.

You need to be familiar with many different technologies to make Azure SQL Edge work. We will start with the history of IOT and continue with available Azure IOT features you need to use to install Azure SQL Edge into an IOT device. We will explore Linux tools and command that you need to know to enable IOT functionalities of your device.

Hasan will share his experience with installing and connecting Azure SQL Database Edge to Raspberry Pi.

14-09-21 11:3014-09-21 12:45YukonView In Your Timezone
Day 2From Report to Interactive Data Application with Power BIMarkus Ehrenmueller-JensenBusiness Intelligence & Advanced AnalyticsReports were yesterday – data applications own the future! In this demo rich session you will learn how to leverage Power BI Desktop’s interactive features to transform your existing reports into highly interactive applications which allow the report user to discover the data in an easy way.

You will learn about: Bookmarks, Drilling, Drill-through, Tooltips, What-if parameters and more!

14-09-21 11:3014-09-21 12:45HydraView In Your Timezone
Day 2Help!! My SQL Server database is not performing well!Michelle GutzaitDevelopmentToo often you see database issues, especially as your databases grow.

In this session, Michelle will talk about the main SQL Server Development Best Practices for optimized performance as well as remedies to resolve performance bottlenecks due to data growth.

14-09-21 11:3014-09-21 12:45ShilohView In Your Timezone
Day 2New Enterprise-Friendly Features for SSIS in Azure Data FactorySandy WinarkoBusiness Intelligence & Advanced AnalyticsThis session will cover new enterprise-friendly features for SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), such as express virtual network (VNet) injection, dual standby SSIS integration runtime (IR) pair for business continuity & disaster recovery (BCDR), Azure Monitor/Purview integrations, SSIS DevOps tools for continuous integration & continuous delivery (CI/CD), Azure-enabled SQL Server Data Tools (SSDT) to assess/test/migrate SSIS packages, ADF templates to run SQL/any process anywhere in 3 easy steps, etc.14-09-21 11:3014-09-21 12:45SphinxView In Your Timezone
Day 2EDW Automation and Design Best PracticesBob DuffyBusiness Intelligence & Advanced AnalyticsStar schema can be very slow to develop an expensive to maintain. You need to add a column to a dimension or a new Fact table. Does that take hours, weeks, an entire development sprint, or is this just too expensive to even think about ?

In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too.

Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility.

14-09-21 11:3014-09-21 12:30KilimanjaroView In Your Timezone
Day 2Modernize Your Oracle Workloads to Azure SQLAlexandra Ciortea14-09-21 11:3014-09-21 12:45KatmaiView In Your Timezone
Day 2Knowing and Controlling Your Azure Spend

Dustin Dorsey

Industry Solution

Cloud technologies provide us so many benefits to get us what we need very quickly with its extensive library of services, easy to deploy infrastructure, and flexibility to scale. However, without proper planning, control and monitoring you can end up with some unexpected surprises when your bill arrives that can jeopardize your project. As technical professionals it is easy to get focused on the technology and not consider items such as cost management, but you are essential to successfully creating a cost efficient system. In this session, we will review the primary components of budgeting and cost management, review the tools and programs in place to assist you, and provide several tips based on years of experience to help get you started.14-09-21 13:0014-09-21 14:15YukonView In Your Timezone
Day 2Monitoring SQL Server on Linux performance with Performance Co-Pilot and GrafanaLouis ImersheinData AdministrationRecent advancements in open source projects make it easier than ever to do much more than just basic performance monitoring of SQL Server on modern Linux systems. In this talk we’ll look into two tools which have recently been enhanced to support SQL Server on Linux: Performance Co-Pilot (PCP), and Grafana.

PCP is a lightweight system performance analysis toolkit. Metrics are provided to PCP through Performance Metric Domain Agents (PMDAs). The PMDAs provide special-purpose modules that allow PCP to collect a wide range of specialized metrics. Recently, a PMDA for SQL Server was introduced as well as an ansible playbook to deploy and configure the PMDA across multi-server Linux environments. While PCP is used to collect metrics, Grafana is the web-based open source tool to display performance graphs and notify you of the unexpected. The new SQL Server Performance Dashboard for Grafana displays not only SQL Server data, but also important Linux system graphs that you can use to identify trouble spots. By the time youÂ’re done with this talk youÂ’ll understand: how to use PCP and Grafana to identify SQL Server on Linux performance problems and track down solutions.

14-09-21 13:0014-09-21 14:15ShilohView In Your Timezone
Day 2The Data Talks Back: Speech & Language AI for the Data ProfessionalMatt GordonData Science (AI/ML)AI is, was, and will be a part of our world for a long time to come. The Speech and Language areas of Azure Cognitive Services provide powerful opportunities for data professionals to enable richer reporting, create chatbots to answer repetitive questions, or just bolster their resume for their next job. Even though my day-to-day job is a DBA/Data Architect, I’ve worked with these AI technologies for years to provide instant information to my employees, enable richer interactions on internal and external websites, and easily localize apps and documentation to local languages. Want to know more about AI and how it can help you? Attend this session. Want to know more about AI and how it can help you level up in your career? Attend this session. Want to know more about how much fun it is to play with Language and Speech in Cognitive Services? Attend this session. Let’s kickoff your AI journey together!14-09-21 13:0014-09-21 14:15SphinxView In Your Timezone
Day 2SQL Server on Azure Virtual Machines Reimagined: Sizing Deep DivePam Lahoud, David Pless & Aditya BadramrajuData AdministrationTypically, you choose a VM when your application requires more control over the computing environment than the other platform-as-a-service options offer. This can be due to vendor requirements, familiarity with virtualization, ease of migration and other scenarios. 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. In this session, we will cover topics such as the different virtual machine types that are most appropriate for SQL Server workloads, optimal memory-to-core ratios for various workload types, and features unique to Azure such as write acceleration that can help boost your performance without breaking the bank. We will also cover the Azure Virtual Machine naming conventions and how you can quickly identify a given machines capabilities from the virtual machine series name. We will close out the discussion with a review of virtual machine disks and storage limits that will be a precursor to the next deep dive session on Azure SQL VM storage.14-09-21 13:0014-09-21 14:15HydraView In Your Timezone
Day 2An Hour of SQL Server Big Data Clusters DemosBob PusateriData AdministrationAttend this session and gain a better understanding of the capabilities and use cases of SQL Server Big Data Clusters, a new feature in SQL Server 2019 that combines the SQL Server relational engine with HDFS and Spark. Through this all-demo session, you will see how to work with a SQL Server Big Data Cluster, and a variety of the tasks that can be easily performed on one. If you like to learn by observing instead of just looking at slides, this is the session for you!14-09-21 13:0014-09-21 14:00KilimanjaroView In Your Timezone
Day 2Azure Synapse AnalyticsMohit Batra14-09-21 13:0014-09-21 14:15HekatonView In Your Timezone
Day 2Data ModelingLeslie Andrews14-09-21 13:0014-09-21 14:15KatmaiView In Your Timezone
Day 2Getting more realistic testing into your database DevOps process with Flyway and SpawnGrant Fritchey & Santiago AriasIndustry SolutionRedgate DevOps Advocate Grant Fritchey and Tech Lead Santiago discuss how to get more realistic testing into your database DevOps process.14-09-21 14:3014-09-21 15:45HydraView In Your Timezone
Day 2DBAmp: Integrate Salesforce and SQL Server with Real-Time Bidirectional ConnectivityJerod JohnsonData AdministrationDBAmp is the ultimate Salesforce integration solution for any SQL DBA. With DBAmp, you can easily access all your Salesforce data through SQL Server, using standard SQL.

Use SQL to select and modify objects in Salesforce without programming

Run reports that join local tables with Salesforce

Write stored procedures for bidirectional integration from SQL Server to Salesforce

Replicate all your Salesforce data into SQL Server with one command

Bulk insert and update data from SQL Server tables into Salesforce

In this session, you’ll learn how DBAmp provides real-time integration between SQL Server and Salesforce, including a demo showcasing some of the available functionality.

14-09-21 14:3014-09-21 15:45SphinxView In Your Timezone
Day 2Power Up Copy Data Management for SQL Server with New IntegrationsRobert QuimbyProduct Showcase (For Sponsors)14-09-21 14:3014-09-21 15:45ShilohView In Your Timezone
Day 2Azure Databricks for AI and AnalyticsBhanu PrakashBusiness Intelligence & Advanced AnalyticsAzure Databricks brings a premium Spark Engine to unlock insights go enterprises. In this session, we’ll provide an overview of Azure Databricks and some of the latest developments in Spark that will accelerate your analytics workloads and time to insight.14-09-21 16:0014-09-21 17:15SphinxView In Your Timezone
Day 2Inside Serverless SQL pools in Azure Synapse AnalyticsBob Ward & Anshul RampalArchitectureAzure Synapse Analytics is the first unified, cloud native platform for converged analytics. As a cloud data warehouse, Synapse provides traditional warehouse capabilities but evolves this feature set to include big data processing and data integration in a single cloud service. Synapse SQL is the ability to do T-SQL based analytics in Synapse workspace. As part of this capability, Synapse supports serverless SQL pools. In this session, we will dive into how Serverless SQL pools let you use SQL without having to reserve capacity.  You will learn how Serverless SQL pools work, how you can use the familiar T-SQL language to query data lake assets, and Serverless SQL pools use a distributed data processing system, built for large-scale data and computational functions.14-09-21 16:0014-09-21 17:15YukonView In Your Timezone
Day 2What’s New in SQL Tools for DevelopersDrew Skwiers-Koballa & Alan YuDevelopmentWith the growth of cross platform environments and DevOps for databases, now is a great time to learn about database development in Azure Data Studio and VS Code. Learn the latest updates to the tooling features for developers working with SQL Server in this demo-heavy session presented by the team that is creating these features, covering SQL Projects, Azure Data Studio, SqlPackage, VSCode and more.14-09-21 16:0014-09-21 17:15ShilohView In Your Timezone
Day 2Cloud Data PlatformsWarner Chaves14-09-21 16:0014-09-21 17:15KatmaiView In Your Timezone
Day 2Azure Database for PostgreSQL, MySQL – Flexible ServerSridhar Ranganathan & Bashar Hussein14-09-21 16:0014-09-21 17:15HekatonView In Your Timezone
Day 2Visualization Magic in the Age of Numbers & ScienceReid HavensBusiness Intelligence & Advanced AnalyticsPower BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations and features can be created a number of ways including: layering visuals, customizing visual formatting, and/or utilizing DAX measures. The session will include a series of visualization and reporting techniques that you’ll be able to leverage in your company’s reports to take them to the next level.14-09-21 16:0014-09-21 18:00KilimanjaroView In Your Timezone
Day 2WIT PanelAnna Hoffman, Lindsey Allen, Marisa Brasile, Vicky Harp, Nikita Takru, Mara-Florina Steiu14-09-21 16:0014-09-21 17:15HydraView In Your Timezone
Day 3Getting started with Query StoreDeepthi GoguriData AdministrationDo you face performance problems with queries generating multiple query plans? Identifying the optimal plan for these queries becomes difficult if you only depend on the plan cache. You need a history of the query plans over time to identify performance degradation, and this is where Query Store can help!

If you are not familiar with Query Store and its benefits, this session is right for you! You will learn about Query Store fundamentals, monitoring performance using Query Store, how to manually force and unforce plans, automatic plan correction, things to remember while using Query Store, and the new query hint feature added recently to Azure SQL Database and available for preview.

The demos will show you how to readily test and implement Query Store and take advantage of this amazing feature SQL Server has to offer!

15-09-21 12:3015-09-21 13:45HydraView In Your Timezone
Day 3Getting Beyond the Basics with Azure Machine LearningKevin FeaselData Science (AI/ML)Azure Machine Learning offers a low-code approach to performing machine learning tasks, but what happens when you need to do something a little more complex? In this talk, we will go beyond the Azure Machine Learning designer and show how to use Azure Machine Learning in a code-first environment. We will understand how the Pipeline metaphor works within code and use that to generate and deploy models, as well as writing outputs to locations such as an Azure SQL Database. For deployment, we will see the differences between batch and real-time inference. We will also review how Azure Machine Learning handles model registration and versioning. This talk assumes some basic familiarity with Azure Machine Learning and the Python language.15-09-21 12:3015-09-21 13:45SphinxView In Your Timezone
Day 3Querying Azure Log Analytics with KustoPaul Ou YangData AdministrationTo detect performance anomalies, suspicious activity, or error patterns of your Azure resources such as Azure SQL, you donÂ’t need to be a Data Scientist, all you need is Azure Log Analytics and Kusto. In this session, you will learn how to configure your Azure resources to send data to an Azure Log Analytics workspace and leverage the built-in time-series and machine learning Kusto functions to detect changes in the behavior of your resources.15-09-21 12:3015-09-21 13:45ShilohView In Your Timezone
Day 3Power BI Universe – Mapping the hiveTom MartensBusiness Intelligence & Advanced AnalyticsIn this session, an Azure-based solution will be created that maps your Power BI tenant. This solution, of course, also contains a Power BI report that is part of this solution, allows you to see the data sources that are fueling your datasets, how many workspaces exist, and a lot more.

This solution uses Power Shell, Azure Automation, Power BI Rest APIs, and some Azure-based storage.

15-09-21 12:3015-09-21 13:45SphinxView In Your Timezone
Day 3Get to know the latest & coolest features in “Azure SQL Database Hyperscale”Pooja Kamath & Balmukund LakhaniData AdministrationIn this session we will demo the latest and newly released features from Azure SQLDB ‘Hyperscale’- the architectural evolution of Azure SQL, which has been natively designed to take advantage of the cloud.

One of the main key features of this new architecture is the complete separation of Compute Nodes and Storage Nodes. Because of this Hyperscale service tier removes many of the practical limits traditionally seen in cloud databases

While the most common notion is that Hyperscale tier is intended for customers whose requirements encompass very large databases, we will see why it is a great fit for most business workloads that even have smaller databases, but require fast vertical and horizontal compute scaling, high performance, instant backup, fast database restore & have significant read-only workloads.

We will look at some interesting use cases from recently released features that makes Azure SQL DB Hyperscale unique & how it compares with other offerings.

Don’t worry if you are new to Azure SQL DB Hyperscale! Our session will also look at the brief overview of the revolutionary Hyperscale architecture before we dive into the demos

15-09-21 12:3015-09-21 13:30KilimanjaroView In Your Timezone
Day 3Microsoft latest Web UI technology, Blazor, working with Azure SQL DatabaseMing Man Chan15-09-21 12:3015-09-21 13:45HekatonView In Your Timezone
Day 3Azure Synapse AnalyticsJames Broome15-09-21 12:3015-09-21 13:45KatmaiView In Your Timezone
Day 3What’s new in Azure SQLAnna HoffmanData AdministrationJoin this session to get all the updates on what’s new in Azure SQL in 2021. You’ll learn about updates containing all things SQL Server and Azure SQL. This not-to-miss session will include demos and a sneak peak at the future!15-09-21 14:0015-09-21 15:15ShilohView In Your Timezone
Day 3Inside Azure SQL Managed InstanceBob Ward & Niko NeugebauerData AdministrationSQL Server professionals are looking to modernize all aspects of their data platform. Azure SQL Managed Instance is a fully managed database service for those looking to modernize SQL Server in the cloud. Azure SQL Managed Instance includes almost the complete surface area of a SQL Server instance but saves you time and effort with a versionless server and powerful built-in HADR capabilities.15-09-21 14:0015-09-21 15:15HydraView In Your Timezone
Day 3Salesforce & QuickBooks Integration to SQL Server via SSISJerod JohnsonBusiness Intelligence & Advanced AnalyticsThe vast majority of companies today have data stored in multiple systems that reside in the cloud. Consolidating this data into a single data store provides a single source of truth for corporate reporting. In this session, you’ll see how to build a data flow in SQL Server Integration Services to consolidate data from Salesforce and QuickBooks Online into a SQL Server database for reporting, analytics, and more.15-09-21 14:0015-09-21 15:15YukonView In Your Timezone
Day 3Building a Data Lake with Azure Synapse AnalyticsWarner ChavesBusiness Intelligence & Advanced AnalyticsSynapse Analytics is Microsoft Azure’s premier data analytics service, combining the power of MPP warehousing, serverless execution, Spark and pipelines.

With tight storage integration, flexible compute and massive scale, Synapse is a great platform to build an enterprise data lake and unlock the value of both structured and unstructured data.

In this session we will focus on Synapse’s capabilities to read and analyze raw data sitting in Azure Data Lake storage. We will cover best practices on how to organize your data lake, how to process the data and ways to expose this data to outside tools and consumers.

15-09-21 14:0015-09-21 15:15SphinxView In Your Timezone
Day 3NLP Capabilities with Azure Cognitive Services.

Disha Agarwal

Data Science (AI/ML)

With Language cognitive services, we bring multiple cloud-based NLP Capabilities such as language understanding, entity extraction, question answering, sentiment analysis, language detection etc, within the reach of every developer – without requiring machine-learning expertise. These capabilities enable developers to easily build NLP capabilities into their apps to power business solutions. For instance, Language understanding and Question Answering capabilities are leveraged to build conversational bots. Sentiment analysis and opinion mining capabilities are leveraged for use cases such as analyzing surveys, social media feedback on products and even customer support calls. Many of these applications can be integrated with other cognitive services such as Speech and Translation to power more sophisticated use cases such as voice assistants across multiple languages. Through the course of the presentation, I will be talking about some of these NLP capabilities and how enterprises are building business solutions with these capabilities.

15-09-21 14:0015-09-21 14:30KilimanjaroView In Your Timezone
Day 3Unified Data Governance with Azure PurviewGaurav Malhotra15-09-21 14:0015-09-21 15:15KatmaiView In Your Timezone
Day 3Fast GDPR compliance

Yuli Stremovsky

Industry Solution

Privacy by design compliance is a challenging task for most startups. It is better to build it from the first steps of the product. Otherwise, you will have to add privacy to an already developed product. It is much more complicated and much more expensive. In this session, I am going to deep dive into a Databunker. Databunker is a Swiss army knife tool for storing personal records or PII. Databunker is an open-source, network-based, self-hosted, GDPR compliant, secure storage for personal data. This product can streamline GDPR compliance.

15-09-21 14:4515-09-21 15:15KilimanjaroView In Your Timezone
Day 3Latest Access Control enhancements in Azure SQLAndreas WolterData AdministrationLearn about the latest enhancements in the authentication and authorization space for Azure SQL that help you adhere to the Principle of Least Privilege when granting access to Database resources, and how to do it in a scalable way.15-09-21 15:3015-09-21 16:45ShilohView In Your Timezone
Day 3Intro to Azure Data Service and Azure Synapse Analytics

Balram Prasad

Development

In this talk i will present a slide where i will talk about different data services offered by azure and then how we can use azure synapse for different purpose and in the end i will have demo about how we can create notebook and run sql script in azure synapse15-09-21 15:3015-09-21 16:45YukonView In Your Timezone
Day 3Unified Data Governance with Azure PurviewGaurav MalhotraBusiness Intelligence & Advanced AnalyticsAzure Purview is a unified data governance service that helps you manage and govern your on-premises, multicloud, and software-as-a-service (SaaS) data. Easily create a holistic, up-to-date map of your data landscape with automated data discovery, sensitive data classification, and end-to-end data lineage. Empower data consumers to find valuable, trustworthy data. During this we will showcase the power of Azure Purview as a unified data governance service. Both existing capabilities and roadmap items will be discussed.15-09-21 15:3015-09-21 16:45SphinxView In Your Timezone
Day 3Power BI Tips to increase your productivity

Mohammed Adnan

Development

All about short cuts and tips to increase the Power BI development and some of the Industry best practices which we need to follow15-09-21 15:3015-09-21 16:00KilimanjaroView In Your Timezone
Day 3DEI PanelJennifer Stirrup, Sandip Pani, Sangeetha Gupta, Deepthi Goguri, Kay Sauter15-09-21 15:3015-09-21 16:45HydraView In Your Timezone
Day 3IoT Data: From Edge to Cloud – OPC/UA data Journey using Azure IoT EnvironmentJorge MaiaProfessional DevelopementCome to a journey of the data from sensors, PLCs, and industrial hardware with OPC/UA, passing through transformation and filtering on the Edge, Its ingestion on the cloud, and finally presenting a Time Series model. In this session, you will see how to connect an Azure IoT Edge device to an OPC/UA server, subscribe to data, transform the payload to have a smooth path on IoT services in the cloud, and then present data as a Time Series on the Time Series Insights. After this presentation, you will understand the architecture of the solution that you will need to reproduce with a clear understanding of pitfalls and challenges.15-09-21 16:1515-09-21 16:45KilimanjaroView In Your Timezone
Day 3Power BI: Using streaming for real-time data

Dennes Oliveira

Business Intelligence & Advanced Analytics

There are many scenarios of data ingestion when we would like to see our real time data. Come to this session to learn how to build reports over real time data using power bi15-09-21 17:0015-09-21 18:15ShilohView In Your Timezone
Day 3Azure Synapse Analytics: AI, Synapse Link, and Microsoft Business ApplicationsJosh CaplanBusiness Intelligence & Advanced AnalyticsAzure Synapse Analytics is meant to help data engineers and data scientists work with data to transform their businesses. In this session you’ll see the latest in how Synapse gives superpowers to these users to work with the data in their enterprise and use Synapse to operationalize machine learning at scale.15-09-21 17:0015-09-21 18:15SphinxView In Your Timezone
Day 3SQL Server on Azure Virtual Machines Reimagined: Storage Deep DivePam Lahoud, David Pless & Aditya BadramrajuData AdministrationOptimizing Virtual Machine storage is one of the most critical areas to master when considering a migration to Azure SQL Virtual Machine. Azure virtual machines have input/output operations per second (IOPS) and throughput performance limits based on the virtual machine type and size. Additionally, OS disks and data disks will have their own IOPS and throughput limits. Workloads can be limited at either the virtual machine or the disk level. In this session we demystify storage and how VM sizing will impact performance limits. We will cover what you should consider when choosing Azure disks and storage pool configurations. We will discuss Storage Spaces and Storage Pools. We will also simplify the correct block level, interleave, and the NumberofColumns settings necessary for an optimized storage configuration. Finally, we will review how to monitor IOPs and throughput limits of your virtual machine, the underlying disks, and the caching capabilities of the ephemeral disks and the storage cache.

Get ready, this is one of the most important sessions to get the best performance out of your Azure virtual machine deployment!

15-09-21 17:0015-09-21 18:15HydraView In Your Timezone
Day 3Bad Decisions Revealed: How our Emotional Brain Wins Over our Thinking Brain Every Single Time!Tammy GunsProfessional DevelopmentDo you ever wonder why supposedly “smart” people seem to make “not so smart” decisions? We are far more controlled by our emotional brain than our thinking brain. We all KNOW how to be at our ideal weight and yet few of us are able to maintain that goal. We all KNOW how to engage in behaviors that are supportive of our health and yet we fail to do so on a consistent basis. We all KNOW what to do in many areas of our life and how it benefits us, but we fail to take action. Why? We are actually incentivized to make “bad decisions” in the immediate time frame. This presentation will help uncover and demystify our curious behaviors that seem to be counterproductive to our desired goals. You won’t want to miss out on these simple tips and tricks for a better future starting NOW!15-09-21 17:0015-09-21 18:15YukonView In Your Timezone
Day 3Parallelism in Microsoft SQL ServerTorsten StraussProfessional DevelopmentSQL Server can execute queries in parallel which can sometimes improve the performance of your queries. However, parallelism has its own challenges; therefore, we will look at the concept of parallel executions to understand when it makes sense to run a query on more than one thread. We deal with topics such as CXPacket, threads, workers, execution context, branches, MAXDOP, Cost threshold for parallelism, NUMA nodes and the iterators that SQL Server can implement in the execution plan to enable parallelism.15-09-21 17:0015-09-21 18:00KilimanjaroView In Your Timezone
Day 3T-SQL Kathi Kellenberger15-09-21 17:0015-09-21 18:15HekatonView In Your Timezone
Day 3Power BI Hariharan Rajendran15-09-21 17:0015-09-21 18:15KatmaiView In Your Timezone
Day 3DBAs getting more done in less time with PowerShell

Ben Miller

Data Administration

Have you thought about how you would use PowerShell to do your Administrative work with SQL Server? This session is all about practical use of the PowerShell to actually do DBA work on a daily basis. In this session I will cover using DbaTools module, SqlServer module and combine that with PowerShell Notebooks in Azure Data Studio. You will learn different ways to backup databases and to restore databases as well as quickly find out when each database was backed up. I will also cover how you can use TSQL in PowerShell to get information to store for trending. From AdHoc backups and restores, to automated tasks to gather data for trending and combining these concepts in a PowerShell Notebook to create habits and transportable insights into your environment, this session is a great way to take the PowerShell you know and use it to do actual work. This session is not meant to teach you PowerShell, but to show you how you can use it more effectively.15-09-21 18:3015-09-21 19:45YukonView In Your Timezone
Day 3Best Practices Using Power BI datasets in Paginated Reports –

Parvinder Chana

Business Intelligence & Advanced Analytics

Paginated reports aka pixel-perfect reports are designed to provide output that can be printed or exported as PDF. They’re called paginated because they’re formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. They’re also called pixel perfect because you can control the report page layout exactly the way you want.

With the Power BI dataset is in the center and used as a single data source for analytical and operational reporting, in this meetup, you will learn how to effectively use the Power BI dataset in Paginated Reports. We will talk about how to create cascaded parameters, date parameters, use Paginated Reports to export large data from Power BI reports, and many other tips and tricks.

15-09-21 18:3015-09-21 19:45SphinxView In Your Timezone
Day 3Discover, assess Azure SQL readiness of SQL Server data estate at scale using Azure Migrate serviceRaj Pochiraju & Ajay JagannadhanData AdministrationCome and join our latest Azure Migrate innovations, a seamless discovery and assessment of your SQL Server data estate at scale. Learn how Microsoft makes your migration and modernization decision making easy by providing the target Azure SQL deployment option and sizing recommendations using Azure Migrate. You can also get the monthly pricing estimates migrating to Azure SQL.15-09-21 18:3015-09-21 19:45HydraView In Your Timezone
Day 3Business Analysis with T-SQLDejan SarkaDevelopmentNo matter if you use SQL Server on premises, Azure SQL Database, or Azure Synapse Analytics, you might have a feeling that the main language for these services, the T-SQL language, is somehow obsolete and not capable enough for the need of the modern analytics. This session will show you the opposite. You can make advanced business analytics also with T-SQL, you do not need to use R, Python, or some other currently fashionable language for every single in-depth view in your data. In addition, you can get magnitudes better performance inside a database management system when in statistical languages and engines. You will learn how to use T-SQL for queries that you might already be familiar with, for aggregating queries. But this is only to warm you up. Then you will learn how to do hazard and survival analysis, market basket analysis with association rules using different measures like support and confidence, and even sequential market basket analysis, when there is a sequence in the basket. Then the session introduces the look-alike model, which is a mixture of k-nearest neighbor and decision trees algorithms. The session finishes with Bayesian inference implemented with T-SQL.15-09-21 18:3015-09-21 20:30KilimanjaroView In Your Timezone
Day 3Data Science and Machine LearningKevin Feasel15-09-21 18:3015-09-21 19:45HekatonView In Your Timezone
Day 3SQL Server Big Data ClustersBob Pusateri15-09-21 18:3015-09-21 19:45KatmaiView In Your Timezone
Day 3Protecting Data from Disasters and RansomwareAnthony Nocention & Argenis FernandezData AdministrationBackups are core to a recovery strategy for SQL Server. In this session, you will learn how to tune backups to make them go as fast as your infrastructure supports so that you can backup and restore data quickly! We will then combine backups with snapshots which give you nearly instantaneous recovery of your volumes and databases to help protect your workloads from disasters, corruptions, and ransomware. By the end of this session, you will learn SQL Server’s backup architecture, how to configure and tune it for speed and how to leverage storage based snapshots for nearly instantaneous recovery.15-09-21 18:3015-09-21 19:45ShilohView In Your Timezone
Day 3Data Replication in Azure SQL and BeyondAlain Dormehl & Mara SteiuData AdministrationThis session will cover data replication technologies such as CDC (with a focus on CDC in 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.15-09-21 20:0015-09-21 21:15YukonView In Your Timezone
Day 3Scaling database workloads with Azure SQL HyperscaleDenzil RibeiroData AdministrationAzure 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.15-09-21 20:0015-09-21 21:15HydraView In Your Timezone
Day 3Azure Synapse Analytics: Overview, Updates, & RoadmapSaveen ReddyBusiness Intelligence & Advanced AnalyticsAzure Synapse Analytics become generally available in December 2020. Since then we’ve seen tremendous growth in usage and interest in using it to deliver enterprise analytics. At the same time, Azure Synapse is delivering more and more capabilities that help make it a one-stop solution for analytics. The volume of the service, dive deep into the latest key capabilities, and explore the roadmap of what’s coming and what is top-of-mind for the Synapse engineering team.15-09-21 20:0015-09-21 21:15SphinxView In Your Timezone
Day 3Using clustered columnstore indexes efficentlyThomas GrohserData AdministrationClustered column stores are a great feature that if used correctly can save a lot of space and increase the performance of your reporting and analytical queries. But it needs do be designed and configured correctly and the data needs to be loaded in a certain way to make if effective. This session will demonstrate how to partition, model, select data types and insert data into a clustered column store and how to write queries to get the data out as efficient and quickly as possible.

It will also tell you all the things you unfortunately can not (or should not) do with a clustered column store index.

15-09-21 20:0015-09-21 21:15ShilohView In Your Timezone
Day 3Azure Data FactoryAlpa Buddhabhatti15-09-21 20:0015-09-21 21:15KatmaiView In Your Timezone
Day 3SQL Server on AzurePam Lahoud, David Pless & Aditya Badramraju15-09-21 20:0015-09-21 21:15HekatonView In Your Timezone
Day 3Power BI: Modernizing Obsolete Semantic ModelsThimantha VidanagamageBusiness Intelligence & Advanced AnalyticsAre you an owner of a semantic model which was developed before Power BI dataflows were introduced? It is time to modernize your semantic model by integrating dataflows. In this lightning talk, I will take you through the process of integrating dataflows into your existing Power BI semantic models. By the end of the session, you will have an understanding on how to modernize your existing semantic models in Power BI by integrating dataflows.15-09-21 20:4515-09-21 21:15KilimanjaroView In Your Timezone
Day 3Migrate Your MySQL and PostgreSQL Databases to AzureArun ThiagarajanData AdministrationEver wondered what it takes to migrate your existing Open-Source Database workloads to Azure? Azure offers a fully managed PostgreSQL, MySQL which provides maximum flexibility including, zone redundant high availability, AI powered performance optimization and enterprise-grade security and compliance. In this session, we will cover – 1. The benefits of migrating your MySQL and PostgreSQL databases to Azure; and 2. The benefits of migrating your Oracle workloads to Azure Database for PostgreSQL. We will show you various migration tools to make this journey easy, discuss tip/tricks we have learnt from helping customers migrate 1000s of workloads into Azure and showcase some technical demos to visualize the migration journey.15-09-21 21:3015-09-21 22:45HydraView In Your Timezone
Day 3Azure Arc enabled data servicesDinakar NethiData AdministrationThis session will cover Microsoft’s latest offering in the Hybrid space – Azure Arc. Come find out what is Azure Arc enabled data services, what is the value proposition, what is the benefit for customers, what does the architecture look like, etc. There will be demos!15-09-21 21:3015-09-21 22:45ShilohView In Your Timezone
Day 3What’s new in Azure’s path to an Intelligent DatabasePedro LopesDevelopmentAzure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years.

These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data!

Now join us to find about what’s coming in this new intelligent database world!

15-09-21 21:3015-09-21 22:45YukonView In Your Timezone
Day 3Near Real Time Data Analytics with ADFSunil SabatBusiness Intelligence & Advanced AnalyticsThis session will cover how ADF can be used to orchestrate twitter data ingestion with EventHubs and perform PoweBI lead analytics in realtime. We will also cover how Tweeter data can be shaped with Synapse Warehouse to deliver enterprise analytics at scale, all on the foundation of Azure Data Factory.15-09-21 21:3015-09-21 22:45SphinxView In Your Timezone
Day 3See how Decision AI can boost decision Intelligence organizations for better business outcomes

Neta Hiaby

Data Science (AI/ML)

Decision AI can be used to personalize your customer experience, improve your supply chain management, detect anomalies in your business or equipment and more. In this session we will see how Azure Decision AI can improve business processes and assist with decision in organizations. Data is everywhere and effective decision making keeps getting more difficult. Azure Decision AI enables you to make ever-faster decisions based on data analysis such as anomaly detections and personalization. See how you can use Azure Decision AI in your organization to instill better decision intelligence and make more impactful data-driven decisions.

15-09-21 21:3015-09-21 22:00KilimanjaroView In Your Timezone
Day 3Anything Power BIParv Chana15-09-21 21:3015-09-21 22:45HekatonView In Your Timezone
Day 3Azure Cost Management/ Azure DataDustin Dorsey15-09-21 21:3015-09-21 22:45KatmaiView In Your Timezone
Day 3Microsoft Azure AI – Computer Vision

Varsha Parthasarathy

Data Science (AI/ML)

Learn what’s new in Azure Vision AI and build new capabilities with Azure Cognitive Services APIs.

15-09-21 22:1515-09-21 22:45KilimanjaroView In Your Timezone
Day 3Develop serverless, full stack apps with Azure SQLAnna HoffmanDevelopmentLearn how to create, build, and deploy modern full stack applications in Azure by using the language of your choice (Python, Node.js, or .NET) and with a Vue.js frontend. Topics covered include modern database capabilities, CI/CD and DevOps, backend API development, REST, and more. Using a real-world scenario of trying to catch the bus, you will learn how to build and architect solutions that use Azure SQL Database, Azure Functions, Azure Static Web Apps, Logic Apps, Visual Studio Code, and GitHub Actions.15-09-21 23:0016-09-21 0:15ShilohView In Your Timezone
Day 3Backup Options for SQL Server in Azure

Frank Gill

Data Administration

Database backups are the foundation of data protection in SQL Server. In Azure, backups for Azure SQL Database are managed, but there are options for both short- and long-term retention. Backups for SQL Server databases running on Azure VMs can be backed up using SQL Server Agent jobs. Alternately, these databases can be backed up using Azure Recovery Vault. Join me for this session to learn about these options, including demonstrations of set up and administration.15-09-21 23:0016-09-21 0:15YukonView In Your Timezone
Day 3Understanding and designing HA/DR solutions in SQL ServerKevin FarleeData AdministrationLearn the fundamentals of HA/DR in SQL Server. Understand what solutions work best where, and what the tradeoffs are. Understanding how the HA/DR solutions work will enable you to make better choices for your systems, both in terms of protecting your data and in terms of protecting your bottom line by not paying for solutions that don’t help your situation.15-09-21 23:0016-09-21 0:15HydraView In Your Timezone
Day 3Designing for high performance in Power BISiva Harinath & Philip SeamarkBusiness Intelligence & Advanced AnalyticsIt’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.15-09-21 23:0016-09-21 0:15SphinxView In Your Timezone
Day 3Azure SQL Edge : Real-time analysis of IoT DataSourabh Agarwal & Vasiya KrishnanData AdministrationIn this session, we will be designing an end to end IoT solution for real time data analysis. This is a demo-only session where we will take you from

1. Setting up the sensors

2. Streaming the data from sensors to the Azure SQL Edge module

3. Conducting real-time analysis using the Time-series/AI/ML features in Azure SQL Edge

4.Data visualization and managing Azure SQL Edge across multiple devices

15-09-21 23:0016-09-21 0:00KilimanjaroView In Your Timezone
Day 4Serverless SQL Pool in Azure Synapse AnalyticsArmando LacerdaBusiness Intelligence & Advanced AnalyticsAzure Synapse Analytics is a collection of data processing engines. In this session Armando Lacerda will demo how the Serverless SQL pool, which is part of Synapse Analytics, can be used with Power BI to implement data exploration on top of a data lake.16-09-21 12:3016-09-21 13:45ShilohView In Your Timezone
Day 4Feeding the Modern Data Warehouse

Christian Cote

Business Intelligence & Advanced Analytics

When it comes to feed the modern data warehouse in Azure, we’re facing new challenges. This session will explain what id the modern data warehouse and how it can be fed using ETL 2.0 methodologies. Topics like Common Data Model and services will also be talked and demonstrated.16-09-21 12:3016-09-21 13:45SphinxView In Your Timezone
Day 4Azure DevOps and Database Deployment AutomationGrant FritcheyData AdministrationAutomation is a fundamental aspect when adopting a DevOps-style deployment process. Learn how you can use Azure DevOps tools to automate your database deployments successfully. Topics include the challenge of supporting more than one database system, deployments in Azure SQL Database, Postgres and Maria DB. We’ll also show how you can use Azure DevOps to deploy to an on-premises database. All the databases you have under management can have their deployments automated. Come to this session to learn how.16-09-21 12:3016-09-21 13:45HydraView In Your Timezone
Day 4Becoming a Person of InfluenceJason HuntProfessional DevelopmentWe all want to live lives that matter, but just how do we make a positive difference? Some believe that you must have an impressive title to do so, but that is a mistake. The best leaders recognize that no matter where you are in the organization, you have influence – and intentionally using that influence to make a positive difference makes you a leader. This is a highly engaging and powerful session on leadership, breaking this complicated subject down into four simple components: A heart that cares, a head that connects, hands that collaborate, and feet that show courage. Whatever your vocation or aspiration, master these four and watch your influence lead to a greater positive impact in the lives of others – at home, at work, and in every other area of life.16-09-21 12:3016-09-21 13:45YukonView In Your Timezone
Day 410 superb tips about Azure Data FactoryAbhishek NarainBusiness Intelligence & Advanced AnalyticsLearn how to build enterprise-grade data pipelines using Azure Data Factory. We will run through 10 data engineering best practices which will help you build scalable and secure data pipelines. Some of the areas that we will cover are – pipeline architecture patterns, pipeline deployments, performance, governance, security, collaboration, logging and monitoring.16-09-21 12:3016-09-21 14:30KilimanjaroView In Your Timezone
Day 4SQL ServerKay Sauter16-09-21 12:3016-09-21 13:45KatmaiView In Your Timezone
Day 4Let’s talk Monitoring !Alain Dormehl & Anna HoffmanArchitectureCome and learn from Anna and Alain, and maybe some special guests, about the latest Microsoft monitoring features for SQL. We will walk through the current product landscape, explain the current options, talk about the best options for customers, current industry trends and even look at some of the roadmap items for monitoring. This will be a session jam packed with demos and some really great features !16-09-21 14:0016-09-21 15:15YukonView In Your Timezone
Day 4NoSQL For The SQL DBAs & Developers

Jean Joseph

Data Administration

Businesses are quickly moving to NoSQL databases to power their modern applications. Reason is that they are looking for a way to host a relatively unmodified RDBMS schema on a NoSQL database, then optimize it over time.

This presentation will show DBAs and SQL developers how to achieve the benefits of NoSQL within their environments. You’ll learn how to migrate a table-based data model to JSON documents, tweak your queries for relational JSON data, and create indexes to support fast query performance moreover the risk involved when using NoSQL.

16-09-21 14:0016-09-21 15:15ShilohView In Your Timezone
Day 4Azure SQL readiness assessment and migration from Azure Data StudioMohamed Kabiruddin & Rajesh SetlemData AdministrationIn this session we will walk you through database assessment and migration using Azure Data Studio 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 using Azure Data Studio.16-09-21 14:0016-09-21 15:15HydraView In Your Timezone
Day 4What’s new with Azure Data FactoryWee Hyong Tok

Linda Wang

Business Intelligence & Advanced AnalyticsAzure 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. You can also lift and shift existing SSIS packages to Azure and run them with full compatibility in ADF. In this session, you’ll learn what’s news with Azure Data Factory, and resources to help you get started, and be productive with ADF.16-09-21 14:0016-09-21 15:15SphinxView In Your Timezone
Day 4Working with Azure SQL DB Serverless

Carlos Lopez

Data Administration

Abstract:

Summary: In this session we will be working with Azure SQL DB, we will be exploring

the use of the compute model serverless. Using the Azure CLI, and the declarative mode we will be

creating, deleting and altering the server and databases. All of this with the help of Visual Studio Code

integrating with different technologies to make SQL Server better.

Goal 1: Provisioning the server with the serverless compute model

Goal 2: Creating and altering db using declarative model through Azure CLI

16-09-21 14:4516-09-21 15:15KilimanjaroView In Your Timezone
Day 4Protecting your data from tampering with Azure SQL Database ledgerJason AndersonData AdministrationHow can you rely on your business critical data if you can’t ensure that it has not been tampered with? Blockchain has been a destination for many customers who want data immutability, but blockchain is targeted at decentralized multi-party business processes. How do you get the immutability benefits blockchain offers if your system is centralized?

Azure SQL Database ledger is a new capability that uses the same cryptographic patterns employed in blockchains to protect your data from tampering. Join this session to understand how the ledger feature works, and how you can use it to build the digital trust you need in your data.

16-09-21 15:3016-09-21 16:45HydraView In Your Timezone
Day 4An IoT application built on Azure Platform services, what to use and where to use it – an architectural guideBenjamin KettnerArchitectureWhen designing an IoT application, you have many services to chose from. But which service works how and when to choose which service? These questions need to be answered.

After implementing multiple successful IoT projects that process large volumes of data and offer the results of analytics workloads as well as monitoring of assets to customers, certain usage patterns have proven to be useful. In this session, we will dive into an architecture that has proven to be useful for many use cases, we will discuss the services used and alternatives available.

16-09-21 15:3016-09-21 16:45SphinxView In Your Timezone
Day 4Database Modernization Best Practices & Lessons Harvested from Customer EngagementsRaj Pochiraju

Mukesh Kumar

Data AdministrationIn this session you’ll learn the real-world ins-and-outs of how we successfully migrate customers to Azure data platform. You learn, customer migration patterns, FUDs, IP & migration tools that worked in our customer migrations and modernization engagements. We also share few recent customer evidence, what worked and not.16-09-21 15:3016-09-21 16:45YukonView In Your Timezone
Day 4Now where did THAT estimate come from?Hugo KornelisDevelopmentThe SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And thereÂ’s nothing you can do about it. Or is there?

In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.

Though the focus of this session is on understanding the causes of bad estimates, you will also learn ways to fix the problems and get better estimates – and hence, better performing queries.

16-09-21 15:3016-09-21 17:30KilimanjaroView In Your Timezone
Day 4Everything SQLBob Ward16-09-21 15:3016-09-21 16:45KatmaiView In Your Timezone
Day 4Analyze Live Snowflake Data with SQL Server Analysis ServicesJerod JohnsonBusiness Intelligence & Advanced AnalyticsSQL Server Analysis Services often acts as a semantic model between SQL Server and front-end tooling for business intelligence. However, more data is moving to the cloud than ever before and that data is often too big to be imported into a model. In this session, you’ll see how to build a semantic layer using SSAS to provide real-time access to Snowflake data from any tool or platform that supports connecting to SSAS.16-09-21 17:0016-09-21 18:15SphinxView In Your Timezone
Day 4How to Audit SQL Server for FreeJosephine BushData AdministrationAre you tired of not knowing who’s changing what on your SQL Servers? Maybe your company canÂ’t afford to buy third-party auditing tools, but there’s no need to buy expensive auditing tools if you can’t afford them or don’t want to use them. You can know about everything changing on your SQL Servers without having to pay for a tool. By auditing with the built-in features of SQL Server Audit, you can report on usage to auditors, change user permissions or passwords without breaking functionality, and/or understand your workload to migrate parts or all of your database to the cloud or other database technologies. This session will help you understand how to use SQL Server Audit. You will also learn how to compile the results in a central location for easy reporting and learn how to email audit findings with a SQL Agent job.16-09-21 17:0016-09-21 18:15YukonView In Your Timezone
Day 4Azure Data Factory for Beginners: Let’s Make some DataLeslie AndrewsDevelopment

Does Azure Data Factory really make data? Of course not, but what it does is allow you to make your data into something new and different! In this presentation you will learn the basics of Azure Data Factory, what it DOES do, the sections of the “factory”, and how to build a basic factory output. You will learn the basic skills of a Data Factory “machinist” and how to rebuild your data.16-09-21 17:0016-09-21 18:15ShilohView In Your Timezone
Day 4Modernize your open-source database workloads with Flexible Server for the Azure Database for Postgres and MySQLSridhar Ranganathan & Bashar HusseinData AdministrationYour feedback shaped the new Flexible Server for Azure Database for PostgreSQL and MySQL managed service. Flexible Server allows you to gain operational efficiency, and yet more importantly, not give up control of your database. In this session you will learn how the new Flexible Server gives you full control of choosing your configuration, reduces cost, automates maintenance – all with flexible high availability options for your databases. You will also learn about the migration tools that can transition your data to cloud with minimal downtime.  16-09-21 17:0016-09-21 18:15HydraView In Your Timezone
Day 4SQL Server SecurityDejan Sarka16-09-21 17:0016-09-21 18:15KatmaiView In Your Timezone
Day 4Azure Cognitive Services Speech and LanguageMatt Gordon16-09-21 17:0016-09-21 18:15HekatonView In Your Timezone
Day 4Azure SQL Database High availability & Disaster recoveryRoberto Bustos

Emily Lisa

Data AdministrationThis session will dive into Azure SQL Database High Availability and Disaster Recovery features including zone redundancy and geo replication. Come and share your expertise and feedback directly with the engineering team while also learning about the latest in HA/DR for Azure SQL Database.16-09-21 18:3016-09-21 19:45HydraView In Your Timezone
Day 4Conditional Formatting Tricks in Power BI

Pragati JainBusiness Intelligence & Advanced Analytics

In this session we will see different ways of applying conditional formatting to a Power BI reports at data level and visual level.

The session will cover the following details:

 Data Level Conditional Formatting

• Explore default conditional formatting options on data in Power BI:

a. Background Colour

b. Font Colour

c. Data Bars

d. Icons

• Using a calculated measure to create conditional formatting

• Use custom icons for conditional formatting

 Visual Level Conditional Formatting

• Conditional titles on the visuals based on the Slicer Selection

• Conditional Background colour to the visuals using a measure calculation

16-09-21 18:3016-09-21 19:30KilimanjaroView In Your Timezone
Day 4Programming and systems development with T-SQLErland Sommarskog16-09-21 18:3016-09-21 19:45KatmaiView In Your Timezone
Day 4How Storage Systems Work With SQL ServerAnthony Nocention & Argenis FernandezData AdministrationEver wonder what happens between your databae and the storage where it sits? What makes it fast? Why it may be slow? In this session you will discover how SQL Server interacts with storage devices for the different operations that it performs. You will explore the concepts of storage, Perfmon counters, understand how storage metrics directly correlate with database performance, and an overview the storage stacks in virtualization environments.16-09-21 18:3016-09-21 19:45SphinxView In Your Timezone
Day 4Inside the Memory of SQLBob WardData AdministrationThis will be the brain melting session for the event. In this session I’ll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I’ll also describe differences in memory management for SQL Server on Linux and Azure SQL.16-09-21 20:0016-09-21 21:15HydraView In Your Timezone
Day 4No Code Custom Visuals in CharticulatorMike CarloBusiness Intelligence & Advanced AnalyticsLearn how to use the most advanced custom visual from the Microsoft team – Charticulator. A Long time fan and massive advocate for the Charticulator app Mike Carlo will guide you through how to use and build visuals within the Charticulator app. Learn how to make simple visuals all the way to highly complex and stylized versions.16-09-21 20:0016-09-21 21:00KilimanjaroView In Your Timezone
Day 4SQL Server AuditingJosephine Bush16-09-21 20:0016-09-21 21:15KatmaiView In Your Timezone
Day 4SQL Server HA/DRKevin Farlee16-09-21 20:00HekatonKatmaiView In Your Timezone
Day 4Govern Power BI and the rest of your data estate with Azure PurviewCraig BrydenArchitectureA modern data estate will consist of many different components. You could have a wide range a data services which may be Databases, Data Lakes, Power BI, and many more. Keeping track of what assets your organization has and exposing that to your stakeholders is not easy. Azure Purview is Microsoft’s latest Data Catalog product that is going to help you discover, manage, and expose these assets to your users. Join Craig for a discussion on what Data Catalogs are, how Purview works, and how it will help you.16-09-21 21:3016-09-21 22:45SphinxView In Your Timezone
Day 4Notebooks deep dive sessionJulie Koesmarno & Alan YuData AdministrationIn this session, we will cover lessons learned during our journey in using Azure Data Studio Notebooks internally in SQL org and what it means for external customers. We’ll cover executable and automatable Troubleshooting Guides (TSGs aka. Playbook/Run Book) for external customers and internal customers. Finally, we’ll show you recent Notebook features/improvements in Azure Data Studio based on these lessons learned. 16-09-21 21:3016-09-21 22:45HydraView In Your Timezone
Day 4SQL Assessment – Microsoft’s Best Practices CheckerTaiob AliData AdministrationDo you want to get the current 204 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud.

In this all demo session (Yes, no slides), I will show you both the “what” and “how” to use the SQL assessment API. You will learn if a setting is changed after your initial check. How to customize your checks and create your own rules that fit your environments? The demo will use SQL assessment API, PowerShell cmdlets, and the new ‘SQL Assessment’ extension in Azure Data Studio to export assessment results in a SQL table and create an HTML report.

At the end of this session, you will be equipped with the toolset to set up and run your own assessment, create customized rules, and determine your compliance score against suggested best practices.

16-09-21 21:3016-09-21 22:30KilimanjaroView In Your Timezone
Day 4Azure Data FactorySunil Sabat16-09-21 21:3016-09-21 22:45HekatonView In Your Timezone
Day 4Azure Arc Enabled ServicesDinakar Nethi16-09-21 21:3016-09-21 22:45KatmaiView In Your Timezone
Day 4Analysing text with Azure Cognitive Services for Language

Parashar Shah

Data Science (AI/ML)

With Azure Cognitive services for Language, we bring multiple cloud-based NLP Capabilities such as Text Analytics for health, entity extraction, question answering, sentiment analysis, summarization, etc, within the reach of every developer – without requiring machine-learning expertise. In this session, I will give an overview of Text Analytics pre-built AI models and then do a deep dive in to Text Analytics for health. Text Analytics for health is a feature of the Text Analytics (Language) service that extracts and labels relevant medical information from unstructured texts such as doctor’s notes, discharge summaries, clinical documents, and electronic health records. I will also talk about integration available with Power Platform and Azure Search to easily consume our pre-built AI models in your end to end enterprise scenario.

16-09-21 23:0016-09-21 23:30KilimanjaroView In Your Timezone
SessionTitleSpeakerNameStart_Time(UTC)End_Time(UTC)RoomView In Your Timezone
Welcome NoteDPS Team2021-09-13 05:00:002021-09-13 05:25:00HydraView In Your Timezone
KeynoteBob Ward, Anna Hoffman & Buck Woody2021-09-13 14:30:002021-09-13 16:00:00HydraView In Your Timezone
Women-In-Technology Panel DiscussionAnna Hoffman, Lindsey Allen, Marisa Brasile, Vicky Harp, Nikita Takru, Mara-Florina Steiu2021-09-14 16:00:002021-09-14 17:15:00HydraView In Your Timezone
Diversity, Equity & Inclusion Panel DiscussionJennifer Stirrup, Sandip Pani, Sangeetha Gupta, Deepthi Goguri, Kay Sauter2021-09-15 15:30:002021-09-15 16:45:00HydraView In Your Timezone

Breakout Sessions – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos

SessionTitleSpeakerNameTrackAbstractStart_Time(UTC)End_Time(UTC)RoomView In Your Timezone
SQL Server on Linux- Deployments made easy!Amit KhandelwalData AdministrationThis is going to be a fast paced demo filled session, where we spend time on how you can automate the SQL Server deployments across Azure Linux VMs. We also will talk about how we can configure the SQL Server HA on Azure Linux VMs, key aspect of how you can rotate keytabs for AD authentication and if time permits we will bind all this together with a monitoring solution all this in 60 min, so fasten your seatbelts and enjoy!2021-09-13 05:30:002021-09-13 06:45:00HydraView In Your Timezone
Quicker, faster and easier Power BI datasets using Power BI Premium Per User/PremiumGilbert QuevauvilliersBusiness Intelligence & Advanced Analytics? In this presentation I will explain what Power BI Premium per user is and what is the difference between Power BI Premium.

I will then go through and demonstrate the advantages with tips and tricks on how to use PPU for quicker, faster and easier deployments by using the new 3rd Party Tools.

I will demonstrate the following tools and how they can enable you to do more in a shorter amount of time

• Tabular Editor

? Creating Measures

? Formatting of all DAX Measures

? Creating Calculation Groups

? And moreÂ…

• ALM Toolkit

? Granular Deployment of new columns

? Granular deployment of new or existing measures

? Updating Power Query and deploying the changes.

? And moreÂ…

• DAX Studio

? Creating measures to test

? Testing measure performance

? Understanding what is taking up memory in your dataset

And moreÂ…

2021-09-13 05:30:002021-09-13 06:45:00SphinxView In Your Timezone
Data Modelling in Azure Cosmos DBWill VelidaDevelopmentModelling your data correctly is vital when building efficient applications that use Azure Cosmos DB. Proper data modelling allows us to easily scale our Cosmos DB resources as our applications grow.

Many developers fall into the trap of thinking that just because Azure Cosmos DB is a NoSQL service, we don’t need to spend time modelling our data. Lack of attention to proper data modelling in Azure Cosmos DB can lead to poor performing apps that can’t scale and are expensive to run.

In this session, we will cover:

– Why you should model your data correctly for NoSQL databases and how this is different to relational data modelling.

– When you would reference entities in NoSQL vs embedding entities in your documents.

– How partitioning and collections factor in when modelling our data and how we can design our collections accordingly.

By the end of this session, attendees will be empowered with data modelling techniques that they can use to build highly scalable and successfully applications that use Azure Cosmos DB.

2021-09-13 05:30:002021-09-13 06:45:00ShilohView In Your Timezone
Advanced Conditional Formatting in Power BI

Adewale Yusuf

Business Intelligence & Advanced Analytics

Learn to configure conditional formatting rules to add colours & dynamic text to Power BI Dashboards

2021-09-13 07:00:002021-09-13 08:15:00SphinxView In Your Timezone
Zero downtime database deploymentsAlex YatesDevelopmentYou understand that big bang deployments are painful, but

each deploy may disrupt users, so you are restricted to

tight deployment windows for your database. The consequences

of missing your windows aren’t worth thinking about – but it

gets more difficult each time.

In order to move to smaller, more frequent and more reliable

deployments you need to demonstrate that you can safely

deploy during business hours – without disrupting users.

In this session we’ll discuss the most popular strategies:

Blue/Green and Canary deploys, Cluster Immune Systems and

Feature Toggles. Then we’ll discuss the fundamental changes

that we need to make to the way we think about database

“deployments” and “releases” in order to support these

strategies.

We will finish with a SQL Server demo that uses a feature

flag and the expand/contract model to support backward

compatibility and safe, fast rollback options.

2021-09-13 07:00:002021-09-13 08:15:00ShilohView In Your Timezone
The ML Hero’s Secret Weapon: AutoMLDaron YondemData Science (AI/ML)If you are into development, you know that we love to automate things we don’t want to do. Do you still want to work on training the same model over and over using different features or hyperparameters to preventing over-fitting? I did not think so. Let’s see how AutoML can help you.2021-09-13 07:00:002021-09-13 08:15:00YukonView In Your Timezone
Automation with SQL, PowerShell, & Interactive NotebooksMike NelsonProduct Showcase (For Sponsors)At Pure, our Solutions’ team has created some simple, effective, and scalable automation toolkits for SQL Server, FlashArrays, cloud, and more. In this session, we will take a walk through some of the integrations that we have developed and show how they work. These will include the PowerShell SDK, PowerShell Toolkit, and .Net Interactive Notebook learning scenarios utilizing a Pure Validated Design. If your interested in automation using frameworks and toolkits, or learning cool things with Interactive notebooks, come join our session!2021-09-13 08:30:002021-09-13 09:45:00HydraView In Your Timezone
Doing IoT from Scratch – how we deliver successful IoT projectsBenjamin KettnerProduct Showcase (For Sponsors)At ML!PA we have our own take on IoT projects, we will walk you through our company and show you how we are able to deliver successful IoT projects from scratch.2021-09-13 08:30:002021-09-13 09:45:00SphinxView In Your Timezone
Building a Production Environment for Azure Arc enabled Data ServicesChris ADKINData AdministrationThinking of transforming your on-premises SQL Server estate to a farm of Azure Arc managed SQL Server instances ?, and you want the setup to be production grade, then this session is for you, it will cover Kubernetes distro options, storage plugin options, options for backup and restore, load balancing and everything that you need to consider in order to build a production grade environment. This session assumes that attendees will have a basic working knowledge of containers and Kubernetes.2021-09-13 10:00:002021-09-13 11:15:00HydraView In Your Timezone
Enterprise data governance with Azure Purview

Richard Conway

Architecture

In this session Richard Conway will talk about how to build an enterprise data governance strategy with Azure Purview. He will describing patterns and practices of data governance and how to use features of Azure Purview within complex Hub and Spoke cloud network topologies.

Richard will consider the gap in the current Purview offering and how to fill the gap. There will be fast paced demos showing Azure Purview setup, Purview automation and usages of the Apache Atlas API to get catalogue information.

Richard will show how to integrate Purview into pre-existing Azure Data Platform and Cloud Data Warehouse deployments that have built using Azure Data Factory, Azure Databricks and Azure Synapse.

2021-09-13 10:00:002021-09-13 11:15:00YukonView In Your Timezone
Power BI scenarios for automated monitoring

Andrea Martorana Tusa

Business Intelligence & Advanced Analytics

Power BI grows at an exponential rate and so probably does your environment.

Many new users every day, workspaces, data sources etc. How to deal with it?

For a Power BI tenant’s administrator it’s a challenging task keeping everything under control, documenting the model, tracking changes, cleaning it up, knowing which dataset is used and which one isn’t.

What is needed is automation. Monitor workloads, track changes, read and download logs, set alerts, handle contents and artifacts.

How to achieve this goal? Through the use of the three automation pillars: Powershell, Microsoft Flow, Power BI APIs.

Many examples will be illustrated during the session, based on a customer implementation where the Power BI admin plays a central role for governance and management of the solution.

2021-09-13 11:30:002021-09-13 12:45:00SphinxView In Your Timezone
Test Driven Database Development

Magnus Ahlkvist

Development

est Driven Development, or TDD, means we start with unit tests, even before writing our code. When done properly, TDD leads to higher quality systems. It gives us good test coverage, it’s automated and it gives us good regression testing.

To isolate the unit tests, so that they only verify the behaviour of an invidiual method or function, everything outside of the function is mocked. This is a really good idea. If we write a function ConvertCurrency and that function calls service GetCurrencyRate(date,currency), create a mock service which always returns the same value.

How about unit tests for the service GetCurrencyRate? The service probably gets the currency rate for a certain date/currency combination from a database, perhaps through the stored procedure call Finance.GetCurrencyRate. And just like the unit tests for ConvertCurrency uses a mock service for GetCurrencyRate, the unit test for GetCurrencyRate will use a mock for the stored procedure Finance.GetCurrencyRate.

But who will test the stored procedure Finance.GetCurrencyRate?

In this session we will talk about test driven database development. How we can apply the TDD methodology to database development. We will look at the most common unit testing frameworks and how they integrate with database development environments. We will look at unit test design and how we can isolate unit tests to only test the logic of an individual statement, view, stored procedure or user defined function.

2021-09-13 11:30:002021-09-13 12:45:00ShilohView In Your Timezone
Data Platform Confusion: What are viable Data Platform Options when considering Azure from On-Prem?

Charley Hanania

Architecture

Modernising and Migrating to the Cloud can be both destabilising and opportunistic, depending on how it is approached. If someone you’ve been given the “”Lift-and-Shift”” option as preferred, think about all the history and practices that are inherent on-premises that you may want to correct through this transition.

In this session, Charley will go through the options for storing and using data in the Azure Cloud versus what may have been available on premises and how light through to heavy redesigns can open your platform and systems up to safer, scalable and more flexible capabilities.

There are so many options that it can be difficult to determine which architecture options are right for which scenarios, so this should shed some light on capabilities and opportunities that may not have been considered.

2021-09-13 13:00:002021-09-13 14:15:00YukonView In Your Timezone
Getting Started with Extended EventsKathi KellenbergerData AdministrationOver the years, many DBAs have avoided using Extended Events and continued using Trace. At first, this made sense because Extended Events had no user interface and you had to know XML to work with it. Eventually, Microsoft added a GUI, but many folks continued to use familiar tools. In this session learn how to transition from Trace to Extended Events. YouÂ’ll find that itÂ’s easy when you take the right approach.2021-09-13 13:00:002021-09-13 14:15:00HydraView In Your Timezone
Building Event-Driven Microservices with the Azure Cosmos DB Change FeedLeonard LobelDevelopmentThe change feed in Azure Cosmos DB is one of the most overlooked features of MicrosoftÂ’s globally distributed, massively scalable, multi-model database service. Similar to the transaction log of a relational database, the change feed gives you a continuous record of changes as they occur. It therefore serves as an excellent event source for a wide range of cloud-based microservices. In this demo-filled session aimed at developers and data professionals alike, youÂ’ll learn how to leverage the change feed and build event-driven microservices with Azure Functions to achieve replication, denormalization, notifications, materialized views, and data archival.2021-09-13 13:00:002021-09-13 14:15:00ShilohView In Your Timezone
Vision in Microsoft Azure Cognitive ServicesAndreas ErbenData Science (AI/ML)Microsoft Azure Cognitive Services offers various commoditized yet powerful and sophisticated services to work with visual content through Computer Vision.

Currently those services can

– detect and recognize Faces,

– classify images or find objects in an image

– run spatial analytics on video,

– understand rich information in an image,

– process whole videos and get insights from the video

– recognize handwriting and ink in applications

– provide OCR (Optical Character Recognition) on documents

– automatically parse a scan of a paper form.

This fast paced session will introduce the currently available set of services and explain through sample code and demonstrations how to use them.

2021-09-13 16:15:002021-09-13 17:30:00YukonView In Your Timezone
Automated provisioning of SQL Server VMs on AzureKay Sauter

Development

If you need to have an (almost) fully automated deployment of a SQL Server VM including restoring databases and installations of needed software on Microsoft Azure, this PowerShell demo shows how.2021-09-13 16:15:002021-09-13 17:30:00ShilohView In Your Timezone
SQL Server on Azure Virtual Machines Reimagined: OverviewPam Lahoud, David Pless, Aditya Badramraju & Rajesh SetlemData AdministrationRunning SQL Server in an Azure virtual machine gives you the same capabilities and experience you are used to with on-premises SQL Server, plus the additional ease of use and management benefits available only on Azure. In this session, we will discuss the SQL Server in Azure VM experience, including some new features of the SQL Server IaaS Extension that help you optimize cost, enhance security, improve manageability and increase uptime for your SQL Servers in Azure. Expect a focused session on best practices and proven methods to get the most out of your Azure SQL VM experience.2021-09-13 16:15:002021-09-13 17:30:00HydraView In Your Timezone
PowerBI Vision, strategy and roadmapPatrick LeBlancBusiness Intelligence & Advanced AnalyticsPower BI is helping organizations large and small, drive a data culture. We will cover our vision and roadmap. You will learn how AI automatically finds patterns in your data, you will learn about how Power BI is built into Teams and Excel to enable incredible collaboration experiences, and how Power BI with Synapse and other Microsoft technologies meets your most demanding needs.2021-09-13 16:15:002021-09-13 17:30:00SphinxView In Your Timezone
Modernize your Oracle Workloads to Azure SQLAlexandra CiorteaData AdministrationAre you looking to leave Oracle behind? Join us to find out how to accelerate the migration journey by automating Oracle migrations to SQL Server using 1st party tools as SQL Server Migration Assistant  and Data Access Migration Tool2021-09-14 05:30:002021-09-14 06:45:00HydraView In Your Timezone
Enabling Data with Azure ArcDaman KaurData AdministrationThe session covers Azure Arc-enabled data services in detail.

Azure Arc enabled SLQMI, SQLDB, Postgres Hyperscale,

Business use cases for each of the services and when to choose each over others.

As a bonus, we will see how we can leverage azure monitor to manage the SQL workload running on On-prem infrastructure over the Kubernetes cluster.

2021-09-14 05:30:002021-09-14 06:45:00YukonView In Your Timezone
Tips and Tricks to Modernize Power BI Paginated Reports

Hariharan Rajendran

Business Intelligence & Advanced Analytics

The demand for Power BI Paginated reports is keep increasing from the announcement of Premium Per User License and most of you interested to learn. This session is for all report developers who started working with Power BI Paginated Reports.

In this session I will be explaining how to make modern paginated reports with different built-in features. If i say modernize, it does not mean that I am covering only the look and feel of the reports. I will be explaining what kind of features are available and how you can effectively use them and how the tool can compete with other BI tools. Basically, I will be showing the hidden gems of Paginated Reports. In simple, this session will cover development, automation, performance and etc with Paginated Reports.

2021-09-14 05:30:002021-09-14 06:45:00SphinxView In Your Timezone
Azure Database for MYSQL – Flexible Server

Sravani Saluru

Data Administration

Azure Database for MySQL – Flexible Server is a fully managed MySQL database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. In this session we will cover

Overview of Single and Flexible Server for MYSQL Azure DB

Performance

Monitoring & Security

High Availability & Disaster Recovery

Migration strategies

Q&A

2021-09-14 05:30:002021-09-14 06:45:00ShilohView In Your Timezone
Protect your SQL assets anywhere with Azure Defender for SQLDavid Trigano & Michael MakhlevichData AdministrationSQL assets are critical resources and contain the most precious information a company owns, which makes them one of the preferred target for attackers. Protecting them across the environments can be challenging and requires multiple skills to deploy, manage, and remediate those precious resources. In this session, you will learn how Azure Defender for SQL protects your SQL anywhere, and offers capabilities to discover misconfigurations and raise alerts in case of usual activities across every flavor or SQL you are using today, in any environment.2021-09-14 07:00:002021-09-14 08:15:00HydraView In Your Timezone
Tips & Tricks for creating Paginated Reports based on Power BI datasetsFerenc CsonkaBusiness Intelligence & Advanced AnalyticsPower BI is a world-class BI and data analytics tool with stunning interactive data visualization features, but in many business use cases companies need to produce multi-page printouts from their Power BI reports on paper and/or send them in PDF/Excel format to their customers. Power BI Paginated Reports based on the matured and well-known SSRS (SQL Server Reporting Services) technologies can be created from existing Power BI datasets using the Power BI Report Builder tool and can be published to Power BI Service. The recently released PPU (Premium Per User) license and Power BI Embedded Gen2 will also help to have an increasing number of paginated reports in the Power BI ecosystem. Moreover, Paginated Reports visual in Power BI also helps and accelerates the implementation of paginated reports based on existing Power BI datasets.

Therefore, in this session, we will present several tips & tricks how to create paginated reports using existing Power BI datasets available in the Power BI Service and also from your Power BI Desktop, how to reproduce the different Power BI visuals in a paginated report, how to create analytical lines in a paginated report, how to handle parameters, especially multi-value parameters in DAX queries, how to enable for the end-users to select which Power BI report pages should be included in the final printout, how to create printouts with portrait and landscape pages, etc.

2021-09-14 07:00:002021-09-14 08:15:00SphinxView In Your Timezone
How to do Real-Time Analytics Using Apache Kafka and Azure Data ExplorerNeils BerglundDevelopmentThe de facto standard for real-time event streaming is Apache Kafka, and a lot of businesses are streaming tons of data; business events, IoT/telemetry events, etc. The problem is how we can perform analytics and get business insight into the data we are streaming over Kafka.

The answer to this is Azure Data Explorer (ADX). 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. It is a big-data analytics database that allows ingestion of event streams from, among others, Apache Kafka.

In this “demo-heavy” session, we see how we stream event data from Apache Kafka (running on Confluent Cloud in Azure) into Azure Data Explorer.

Some of the topics we cover:

* Overview of Apache Kafka and Confluent Cloud.

* Introduction to Azure Data Explorer.

* Ingestion of data from Kafka into ADX.

* Analyse ingested data in ADX.

2021-09-14 07:00:002021-09-14 08:15:00ShilohView In Your Timezone
How to achieve the best performance and scalability on your Azure SQL Database using the HyperscaleVitor FavaArchitectureIn this session let’s discuss Hyperscale, an Azure SQL Database tier that allows us to create a high-performance environment for OLTP intensive workload scenarios.

We’ll understand the architecture of Hyperscale and how we can create and configure the replicas to redirect any intensive report to avoid any issues on your production environment

2021-09-14 07:00:002021-09-14 08:15:00YukonView In Your Timezone
Delta Lake with Azure Databricks – Let’s build a reliable Data Lake!

Mohit Batra

Business Intelligence & Advanced Analytics

While Data Lakes allow us to store massive amounts of data, there are many challenges that come along – maintaining data and multiple files, providing consistency to downstream applications, handling updates, data recovery in case of failures, slower transactional query performance, consolidation of streaming data and much more. On the other hand, Data Warehouses based on relational databases, handle many of these challenges, but they do not scale well and are expensive to maintain.

Are you interested to build a large-scale, reliable Data Lake?

This session will take you through Delta Lake – an open-source storage layer that brings ACID transactions and reliability to your data lakes. It can scale to handle TBs and PBs of data, handle updates, combine and store batch and streaming data, as well as data and metadata management. And this is what we will look into, via demos:

1. What is Delta Lake, and its features

2. How to get started with Delta Lake using Azure Databricks

3. How to handle Inserts, Updates, Deletes and Merge for the records

4. How it provides ACID guarantees, using transactional logs

5. How Time Travel works

6. How schema enforcement and schema evolution works

7. How data clustering, and clean up works

8. And compare it with Parquet format in terms of features and performance

These features of Delta Lake can truly help you build large-scale data warehouses in your Data Lake.

2021-09-14 08:30:002021-09-14 09:45:00SphinxView In Your Timezone
Build your first recommendation engine using AWS Personalize with Zero ML experienceSandip PaniData Science (AI/ML)

Recommendation Engine is one of the demanding feature now almost everyone wanted to build. In this session we will learn how to design the recommnedation engine from scratch. If you are new to ML world or no prior knowledge about Data science no worries, We will learn together what is a recommnedation engine , what are the things you need to consider to build your own recommendation engine. In this rapid development world we need to first build with minimal time and validate your MVP. Come join with me to learn how to build recommendation engine step by step using AWS personalize.2021-09-14 08:30:002021-09-14 09:45:00ShilohView In Your Timezone
Simplify data management with partitioningUwe RickenDevelopmentThe times of small database systems are now over. Even “small” systems already provide databases with several 100 GB data volume. It can be a real challenge for the DBA to complete the daily maintenance tasks, data backup, consistency checks, … in a reasonable time frame.

With the help of partitioning (also a feature of the Standard Edition since SQL 2016), considerable advantages in ETL processes, maintenance and backup / recovery can be achieved.

The main area of application for partitioning is the optimization of the load paths for complex DWH solutions and the maintenance of large databases (statistics, indexes, backups, restores). The very strongly demo-based session shows partitioning scenarios that let the DBA do alternative things again and encourage ETL developers to dance the joys.

2021-09-14 08:30:002021-09-14 09:45:00HydraView In Your Timezone
Why Data Governance is important and how you can start immediately with Azure PurviewWolfgang StrasserArchitectureCollecting data is one part of the story. To know your data estate is another part. Let’s see how Azure Purview can help you to manage and govern your data estate and bring it to another level.

No matter if the data resides in a database, SAP, Power BI or a datalake – Azure Purview can scan and help you classify your data estate.

Join this session if you want to know how Azure Purview can be a solid part of your data cataloging strategy and how easy it is to start with your Azure Purview environment.

2021-09-14 08:30:002021-09-14 09:45:00YukonView In Your Timezone
SQL Stateful Containers on Kubernetes with Helm!Amit KhandelwalData AdministrationSQL Server is a stateful application and hence should be deployed as a stateful set. In this session, we look at the helm method of installing multiple instances of SQL Server as stateful deployments, look at the recommendations and best practices when running SQL Server on containers for production environment. After this session, you can go ahead and look to take the next step towards modernization of your data estate via SQL containers!2021-09-14 10:00:002021-09-14 11:15:00HydraView In Your Timezone
Insight Discovery – how to define business requirements for a successful cloud data & analytics projectJames BroomeBusiness Intelligence & Advanced AnalyticsMany data projects fail to deliver the impact they should for a simple reason – they focus on the data. In this session, James explains a different way of thinking that will set up your data & analytics projects for success. Using an iterative, action-oriented, insight discovery process, he will demonstrate tools and techniques that will help you to identify, define and prioritize requirements in your own projects so that they deliver maximum value. He’ll also explore the synergy with modern cloud analytics platforms like Azure Synapse, explaining how the process and the architecture actively support each other for fast, impactful delivery.2021-09-14 10:00:002021-09-14 11:15:00YukonView In Your Timezone
Enough of the Azure Pipeline GUI demos for Data Platform deploymentsKevin Chant & Sander StadDevelopmentI’m sure plenty of you have being there before. Hoping to see some YAML being used for real-life scenarios CI/CD deployments in Azure DevOps, only for the demos shown to be GUI based using the Classic Editor.

Well fear not, for in this session we will cover how to use YAML in Azure DevOps for your CI/CD deployments. In this advanced session we will show you how to use YAML for Microsoft Data Platform deployments. Aimed mostly at SQL Server related services, including SQL Server and Azure Synapse SQL Pools. Along the way well also cover other topics like PowerShell and Containers.

You will see a reasonable amount of YAML in this session, which is why we class this session as a borderline expert/brain-hurting one. You might want to bring along pen and paper to take down some notes and help with muscle memory, or at least bring something electronic to enter notes in.

We will show you demos for some real-life scenarios, including Unit Testing for both SQL Server and Azure Synapse SQL Pools.

2021-09-14 10:00:002021-09-14 11:15:00ShilohView In Your Timezone
Power BI Performance – 7 deadly sins!Nikola IlicBusiness Intelligence & Advanced AnalyticsCongratulations! You’ve built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever…Or, your report is utterly slow when interacting with visuals…You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more…

And, if you feel lost, I don’t blame you – I’ve also been there!

That’s why this session is for you: we will examine potential bottlenecks in your Power BI report – starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.

2021-09-14 10:00:002021-09-14 11:15:00SphinxView In Your Timezone
Starting with Azure SQL Edge on Raspberry PiHasan SavranIndustry SolutionAzure SQL Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on resource-constrained interactive devices such as cameras, scanners, IoT gateways, and light-weight edge servers.

You need to be familiar with many different technologies to make Azure SQL Edge work. We will start with the history of IOT and continue with available Azure IOT features you need to use to install Azure SQL Edge into an IOT device. We will explore Linux tools and command that you need to know to enable IOT functionalities of your device.

Hasan will share his experience with installing and connecting Azure SQL Database Edge to Raspberry Pi.

2021-09-14 11:30:002021-09-14 12:45:00YukonView In Your Timezone
From Report to Interactive Data Application with Power BIMarkus Ehrenmueller-JensenBusiness Intelligence & Advanced AnalyticsReports were yesterday – data applications own the future! In this demo rich session you will learn how to leverage Power BI Desktop’s interactive features to transform your existing reports into highly interactive applications which allow the report user to discover the data in an easy way.

You will learn about: Bookmarks, Drilling, Drill-through, Tooltips, What-if parameters and more!

2021-09-14 11:30:002021-09-14 12:45:00HydraView In Your Timezone
Help!! My SQL Server database is not performing well!Michelle GutzaitDevelopmentToo often you see database issues, especially as your databases grow.

In this session, Michelle will talk about the main SQL Server Development Best Practices for optimized performance as well as remedies to resolve performance bottlenecks due to data growth.

2021-09-14 11:30:002021-09-14 12:45:00ShilohView In Your Timezone
New Enterprise-Friendly Features for SSIS in Azure Data FactorySandy WinarkoBusiness Intelligence & Advanced AnalyticsThis session will cover new enterprise-friendly features for SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), such as express virtual network (VNet) injection, dual standby SSIS integration runtime (IR) pair for business continuity & disaster recovery (BCDR), Azure Monitor/Purview integrations, SSIS DevOps tools for continuous integration & continuous delivery (CI/CD), Azure-enabled SQL Server Data Tools (SSDT) to assess/test/migrate SSIS packages, ADF templates to run SQL/any process anywhere in 3 easy steps, etc.2021-09-14 11:30:002021-09-14 12:45:00SphinxView In Your Timezone
Knowing and Controlling Your Azure Spend

Dustin Dorsey

Industry Solution

Cloud technologies provide us so many benefits to get us what we need very quickly with its extensive library of services, easy to deploy infrastructure, and flexibility to scale. However, without proper planning, control and monitoring you can end up with some unexpected surprises when your bill arrives that can jeopardize your project. As technical professionals it is easy to get focused on the technology and not consider items such as cost management, but you are essential to successfully creating a cost efficient system. In this session, we will review the primary components of budgeting and cost management, review the tools and programs in place to assist you, and provide several tips based on years of experience to help get you started.2021-09-14 13:00:002021-09-14 14:15:00YukonView In Your Timezone
Monitoring SQL Server on Linux performance with Performance Co-Pilot and GrafanaLouis ImersheinData AdministrationRecent advancements in open source projects make it easier than ever to do much more than just basic performance monitoring of SQL Server on modern Linux systems. In this talk we’ll look into two tools which have recently been enhanced to support SQL Server on Linux: Performance Co-Pilot (PCP), and Grafana.

PCP is a lightweight system performance analysis toolkit. Metrics are provided to PCP through Performance Metric Domain Agents (PMDAs). The PMDAs provide special-purpose modules that allow PCP to collect a wide range of specialized metrics. Recently, a PMDA for SQL Server was introduced as well as an ansible playbook to deploy and configure the PMDA across multi-server Linux environments. While PCP is used to collect metrics, Grafana is the web-based open source tool to display performance graphs and notify you of the unexpected. The new SQL Server Performance Dashboard for Grafana displays not only SQL Server data, but also important Linux system graphs that you can use to identify trouble spots. By the time youÂ’re done with this talk youÂ’ll understand: how to use PCP and Grafana to identify SQL Server on Linux performance problems and track down solutions.

2021-09-14 13:00:002021-09-14 14:15:00ShilohView In Your Timezone
The Data Talks Back: Speech & Language AI for the Data ProfessionalMatt GordonData Science (AI/ML)AI is, was, and will be a part of our world for a long time to come. The Speech and Language areas of Azure Cognitive Services provide powerful opportunities for data professionals to enable richer reporting, create chatbots to answer repetitive questions, or just bolster their resume for their next job. Even though my day-to-day job is a DBA/Data Architect, I’ve worked with these AI technologies for years to provide instant information to my employees, enable richer interactions on internal and external websites, and easily localize apps and documentation to local languages. Want to know more about AI and how it can help you? Attend this session. Want to know more about AI and how it can help you level up in your career? Attend this session. Want to know more about how much fun it is to play with Language and Speech in Cognitive Services? Attend this session. Let’s kickoff your AI journey together!2021-09-14 13:00:002021-09-14 14:15:00SphinxView In Your Timezone
SQL Server on Azure Virtual Machines Reimagined: Sizing Deep DivePam Lahoud, David Pless & Aditya BadramrajuData AdministrationTypically, you choose a VM when your application requires more control over the computing environment than the other platform-as-a-service options offer. This can be due to vendor requirements, familiarity with virtualization, ease of migration and other scenarios. 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. In this session, we will cover topics such as the different virtual machine types that are most appropriate for SQL Server workloads, optimal memory-to-core ratios for various workload types, and features unique to Azure such as write acceleration that can help boost your performance without breaking the bank. We will also cover the Azure Virtual Machine naming conventions and how you can quickly identify a given machines capabilities from the virtual machine series name. We will close out the discussion with a review of virtual machine disks and storage limits that will be a precursor to the next deep dive session on Azure SQL VM storage.2021-09-14 13:00:002021-09-14 14:15:00HydraView In Your Timezone
Getting more realistic testing into your database DevOps process with Flyway and SpawnGrant Fritchey & Santiago AriasIndustry SolutionRedgate DevOps Advocate Grant Fritchey and Tech Lead Santiago discuss how to get more realistic testing into your database DevOps process.2021-09-14 14:30:002021-09-14 15:45:00HydraView In Your Timezone
DBAmp: Integrate Salesforce and SQL Server with Real-Time Bidirectional ConnectivityJerod JohnsonData AdministrationDBAmp is the ultimate Salesforce integration solution for any SQL DBA. With DBAmp, you can easily access all your Salesforce data through SQL Server, using standard SQL.

Use SQL to select and modify objects in Salesforce without programming

Run reports that join local tables with Salesforce

Write stored procedures for bidirectional integration from SQL Server to Salesforce

Replicate all your Salesforce data into SQL Server with one command

Bulk insert and update data from SQL Server tables into Salesforce

In this session, you’ll learn how DBAmp provides real-time integration between SQL Server and Salesforce, including a demo showcasing some of the available functionality.

2021-09-14 14:30:002021-09-14 15:45:00SphinxView In Your Timezone
Power Up Copy Data Management for SQL Server with New IntegrationsRobert QuimbyProduct Showcase (For Sponsors)2021-09-14 14:30:002021-09-14 15:45:00ShilohView In Your Timezone
Azure Databricks for AI and AnalyticsBhanu PrakashBusiness Intelligence & Advanced AnalyticsAzure Databricks brings a premium Spark Engine to unlock insights go enterprises. In this session, we’ll provide an overview of Azure Databricks and some of the latest developments in Spark that will accelerate your analytics workloads and time to insight.2021-09-14 16:00:002021-09-14 17:15:00SphinxView In Your Timezone
Inside Serverless SQL pools in Azure Synapse AnalyticsBob Ward &

Anshul Rampal

ArchitectureAzure Synapse Analytics is the first unified, cloud native platform for converged analytics. As a cloud data warehouse, Synapse provides traditional warehouse capabilities but evolves this feature set to include big data processing and data integration in a single cloud service. Synapse SQL is the ability to do T-SQL based analytics in Synapse workspace. As part of this capability, Synapse supports serverless SQL pools. In this session, we will dive into how Serverless SQL pools let you use SQL without having to reserve capacity.  You will learn how Serverless SQL pools work, how you can use the familiar T-SQL language to query data lake assets, and Serverless SQL pools use a distributed data processing system, built for large-scale data and computational functions.2021-09-14 16:00:002021-09-14 17:15:00YukonView In Your Timezone
What’s New in SQL Tools for DevelopersDrew Skwiers-Koballa & Alan YuDevelopmentWith the growth of cross platform environments and DevOps for databases, now is a great time to learn about database development in Azure Data Studio and VS Code. Learn the latest updates to the tooling features for developers working with SQL Server in this demo-heavy session presented by the team that is creating these features, covering SQL Projects, Azure Data Studio, SqlPackage, VSCode and more.2021-09-14 16:00:002021-09-14 17:15:00ShilohView In Your Timezone
Getting started with Query StoreDeepthi GoguriData AdministrationDo you face performance problems with queries generating multiple query plans? Identifying the optimal plan for these queries becomes difficult if you only depend on the plan cache. You need a history of the query plans over time to identify performance degradation, and this is where Query Store can help!

If you are not familiar with Query Store and its benefits, this session is right for you! You will learn about Query Store fundamentals, monitoring performance using Query Store, how to manually force and unforce plans, automatic plan correction, things to remember while using Query Store, and the new query hint feature added recently to Azure SQL Database and available for preview.

The demos will show you how to readily test and implement Query Store and take advantage of this amazing feature SQL Server has to offer!

2021-09-15 12:30:002021-09-15 13:45:00HydraView In Your Timezone
Getting Beyond the Basics with Azure Machine LearningKevin FeaselData Science (AI/ML)Azure Machine Learning offers a low-code approach to performing machine learning tasks, but what happens when you need to do something a little more complex? In this talk, we will go beyond the Azure Machine Learning designer and show how to use Azure Machine Learning in a code-first environment. We will understand how the Pipeline metaphor works within code and use that to generate and deploy models, as well as writing outputs to locations such as an Azure SQL Database. For deployment, we will see the differences between batch and real-time inference. We will also review how Azure Machine Learning handles model registration and versioning. This talk assumes some basic familiarity with Azure Machine Learning and the Python language.2021-09-15 12:30:002021-09-15 13:45:00SphinxView In Your Timezone
Querying Azure Log Analytics with KustoPaul Ou YangData AdministrationTo detect performance anomalies, suspicious activity, or error patterns of your Azure resources such as Azure SQL, you donÂ’t need to be a Data Scientist, all you need is Azure Log Analytics and Kusto. In this session, you will learn how to configure your Azure resources to send data to an Azure Log Analytics workspace and leverage the built-in time-series and machine learning Kusto functions to detect changes in the behavior of your resources.2021-09-15 12:30:002021-09-15 13:45:00ShilohView In Your Timezone
Power BI Universe – Mapping the hiveTom MartensBusiness Intelligence & Advanced AnalyticsIn this session, an Azure-based solution will be created that maps your Power BI tenant. This solution, of course, also contains a Power BI report that is part of this solution, allows you to see the data sources that are fueling your datasets, how many workspaces exist, and a lot more.

This solution uses Power Shell, Azure Automation, Power BI Rest APIs, and some Azure-based storage.

2021-09-15 12:30:002021-09-15 13:45:00SphinxView In Your Timezone
What’s new in Azure SQLAnna HoffmanData AdministrationJoin this session to get all the updates on what’s new in Azure SQL in 2021. You’ll learn about updates containing all things SQL Server and Azure SQL. This not-to-miss session will include demos and a sneak peak at the future!2021-09-15 14:00:002021-09-15 15:15:00ShilohView In Your Timezone
Inside Azure SQL Managed InstanceBob Ward & Niko NeugebauerData AdministrationSQL Server professionals are looking to modernize all aspects of their data platform. Azure SQL Managed Instance is a fully managed database service for those looking to modernize SQL Server in the cloud. Azure SQL Managed Instance includes almost the complete surface area of a SQL Server instance but saves you time and effort with a versionless server and powerful built-in HADR capabilities.2021-09-15 14:00:002021-09-15 15:15:00HydraView In Your Timezone
Salesforce & QuickBooks Integration to SQL Server via SSISJerod JohnsonBusiness Intelligence & Advanced AnalyticsThe vast majority of companies today have data stored in multiple systems that reside in the cloud. Consolidating this data into a single data store provides a single source of truth for corporate reporting. In this session, you’ll see how to build a data flow in SQL Server Integration Services to consolidate data from Salesforce and QuickBooks Online into a SQL Server database for reporting, analytics, and more.2021-09-15 14:00:002021-09-15 15:15:00YukonView In Your Timezone
Building a Data Lake with Azure Synapse AnalyticsWarner ChavesBusiness Intelligence & Advanced AnalyticsSynapse Analytics is Microsoft Azure’s premier data analytics service, combining the power of MPP warehousing, serverless execution, Spark and pipelines.

With tight storage integration, flexible compute and massive scale, Synapse is a great platform to build an enterprise data lake and unlock the value of both structured and unstructured data.

In this session we will focus on Synapse’s capabilities to read and analyze raw data sitting in Azure Data Lake storage. We will cover best practices on how to organize your data lake, how to process the data and ways to expose this data to outside tools and consumers.

2021-09-15 14:00:002021-09-15 15:15:00SphinxView In Your Timezone
Latest Access Control enhancements in Azure SQLAndreas WolterData AdministrationLearn about the latest enhancements in the authentication and authorization space for Azure SQL that help you adhere to the Principle of Least Privilege when granting access to Database resources, and how to do it in a scalable way.2021-09-15 15:30:002021-09-15 16:45:00ShilohView In Your Timezone
Intro to Azure Data Service and Azure Synapse Analytics

Balram Prasad

Development

In this talk i will present a slide where i will talk about different data services offered by azure and then how we can use azure synapse for different purpose and in the end i will have demo about how we can create notebook and run sql script in azure synapse2021-09-15 15:30:002021-09-15 16:45:00YukonView In Your Timezone
Unified Data Governance with Azure PurviewGaurav MalhotraBusiness Intelligence & Advanced AnalyticsAzure Purview is a unified data governance service that helps you manage and govern your on-premises, multicloud, and software-as-a-service (SaaS) data. Easily create a holistic, up-to-date map of your data landscape with automated data discovery, sensitive data classification, and end-to-end data lineage. Empower data consumers to find valuable, trustworthy data. During this we will showcase the power of Azure Purview as a unified data governance service. Both existing capabilities and roadmap items will be discussed.2021-09-15 15:30:002021-09-15 16:45:00SphinxView In Your Timezone
Power BI: Using streaming for real-time data

Dennes Oliveira

Business Intelligence & Advanced Analytics

There are many scenarios of data ingestion when we would like to see our real time data. Come to this session to learn how to build reports over real time data using power bi2021-09-15 17:00:002021-09-15 18:15:00ShilohView In Your Timezone
Azure Synapse Analytics: AI, Synapse Link, and Microsoft Business ApplicationsJosh CaplanBusiness Intelligence & Advanced AnalyticsAzure Synapse Analytics is meant to help data engineers and data scientists work with data to transform their businesses. In this session you’ll see the latest in how Synapse gives superpowers to these users to work with the data in their enterprise and use Synapse to operationalize machine learning at scale.2021-09-15 17:00:002021-09-15 18:15:00SphinxView In Your Timezone
SQL Server on Azure Virtual Machines Reimagined: Storage Deep DivePam Lahoud, David Pless & Aditya BadramrajuData AdministrationOptimizing Virtual Machine storage is one of the most critical areas to master when considering a migration to Azure SQL Virtual Machine. Azure virtual machines have input/output operations per second (IOPS) and throughput performance limits based on the virtual machine type and size. Additionally, OS disks and data disks will have their own IOPS and throughput limits. Workloads can be limited at either the virtual machine or the disk level. In this session we demystify storage and how VM sizing will impact performance limits. We will cover what you should consider when choosing Azure disks and storage pool configurations. We will discuss Storage Spaces and Storage Pools. We will also simplify the correct block level, interleave, and the NumberofColumns settings necessary for an optimized storage configuration. Finally, we will review how to monitor IOPs and throughput limits of your virtual machine, the underlying disks, and the caching capabilities of the ephemeral disks and the storage cache.

Get ready, this is one of the most important sessions to get the best performance out of your Azure virtual machine deployment!

2021-09-15 17:00:002021-09-15 18:15:00HydraView In Your Timezone
Bad Decisions Revealed: How our Emotional Brain Wins Over our Thinking Brain Every Single Time!Tammy GunsProfessional DevelopmentDo you ever wonder why supposedly “smart” people seem to make “not so smart” decisions? We are far more controlled by our emotional brain than our thinking brain. We all KNOW how to be at our ideal weight and yet few of us are able to maintain that goal. We all KNOW how to engage in behaviors that are supportive of our health and yet we fail to do so on a consistent basis. We all KNOW what to do in many areas of our life and how it benefits us, but we fail to take action. Why? We are actually incentivized to make “bad decisions” in the immediate time frame. This presentation will help uncover and demystify our curious behaviors that seem to be counterproductive to our desired goals. You won’t want to miss out on these simple tips and tricks for a better future starting NOW!2021-09-15 17:00:002021-09-15 18:15:00YukonView In Your Timezone
DBAs getting more done in less time with PowerShell

Ben Miller

Data Administration

Have you thought about how you would use PowerShell to do your Administrative work with SQL Server? This session is all about practical use of the PowerShell to actually do DBA work on a daily basis. In this session I will cover using DbaTools module, SqlServer module and combine that with PowerShell Notebooks in Azure Data Studio. You will learn different ways to backup databases and to restore databases as well as quickly find out when each database was backed up. I will also cover how you can use TSQL in PowerShell to get information to store for trending. From AdHoc backups and restores, to automated tasks to gather data for trending and combining these concepts in a PowerShell Notebook to create habits and transportable insights into your environment, this session is a great way to take the PowerShell you know and use it to do actual work. This session is not meant to teach you PowerShell, but to show you how you can use it more effectively.2021-09-15 18:30:002021-09-15 19:45:00YukonView In Your Timezone
Best Practices Using Power BI datasets in Paginated Reports –

Parvinder Chana

Business Intelligence & Advanced Analytics

Paginated reports aka pixel-perfect reports are designed to provide output that can be printed or exported as PDF. They’re called paginated because they’re formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. They’re also called pixel perfect because you can control the report page layout exactly the way you want.

With the Power BI dataset is in the center and used as a single data source for analytical and operational reporting, in this meetup, you will learn how to effectively use the Power BI dataset in Paginated Reports. We will talk about how to create cascaded parameters, date parameters, use Paginated Reports to export large data from Power BI reports, and many other tips and tricks.

2021-09-15 18:30:002021-09-15 19:45:00SphinxView In Your Timezone
Discover, assess Azure SQL readiness of SQL Server data estate at scale using Azure Migrate serviceRaj Pochiraju & Ajay JagannadhanData AdministrationCome and join our latest Azure Migrate innovations, a seamless discovery and assessment of your SQL Server data estate at scale. Learn how Microsoft makes your migration and modernization decision making easy by providing the target Azure SQL deployment option and sizing recommendations using Azure Migrate. You can also get the monthly pricing estimates migrating to Azure SQL.2021-09-15 18:30:002021-09-15 19:45:00HydraView In Your Timezone
Protecting Data from Disasters and RansomwareAnthony Nocention & Argenis FernandezData AdministrationBackups are core to a recovery strategy for SQL Server. In this session, you will learn how to tune backups to make them go as fast as your infrastructure supports so that you can backup and restore data quickly! We will then combine backups with snapshots which give you nearly instantaneous recovery of your volumes and databases to help protect your workloads from disasters, corruptions, and ransomware. By the end of this session, you will learn SQL Server’s backup architecture, how to configure and tune it for speed and how to leverage storage based snapshots for nearly instantaneous recovery.2021-09-15 18:30:002021-09-15 19:45:00ShilohView In Your Timezone
Data Replication in Azure SQL and BeyondAlain Dormehl &

Mara Steiu

Data AdministrationThis session will cover data replication technologies such as CDC (with a focus on CDC in 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.2021-09-15 20:00:002021-09-15 21:15:00YukonView In Your Timezone
Scaling database workloads with Azure SQL HyperscaleDenzil RibeiroData AdministrationAzure 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.2021-09-15 20:00:002021-09-15 21:15:00HydraView In Your Timezone
Azure Synapse Analytics: Overview, Updates, & RoadmapSaveen ReddyBusiness Intelligence & Advanced AnalyticsAzure Synapse Analytics become generally available in December 2020. Since then we’ve seen tremendous growth in usage and interest in using it to deliver enterprise analytics. At the same time, Azure Synapse is delivering more and more capabilities that help make it a one-stop solution for analytics. The volume of the service, dive deep into the latest key capabilities, and explore the roadmap of what’s coming and what is top-of-mind for the Synapse engineering team.2021-09-15 20:00:002021-09-15 21:15:00SphinxView In Your Timezone
Using clustered columnstore indexes efficentlyThomas GrohserData AdministrationClustered column stores are a great feature that if used correctly can save a lot of space and increase the performance of your reporting and analytical queries. But it needs do be designed and configured correctly and the data needs to be loaded in a certain way to make if effective. This session will demonstrate how to partition, model, select data types and insert data into a clustered column store and how to write queries to get the data out as efficient and quickly as possible.

It will also tell you all the things you unfortunately can not (or should not) do with a clustered column store index.

2021-09-15 20:00:002021-09-15 21:15:00ShilohView In Your Timezone
Migrate Your MySQL and PostgreSQL Databases to AzureArun ThiagarajanData AdministrationEver wondered what it takes to migrate your existing Open-Source Database workloads to Azure? Azure offers a fully managed PostgreSQL, MySQL which provides maximum flexibility including, zone redundant high availability, AI powered performance optimization and enterprise-grade security and compliance. In this session, we will cover – 1. The benefits of migrating your MySQL and PostgreSQL databases to Azure; and 2. The benefits of migrating your Oracle workloads to Azure Database for PostgreSQL. We will show you various migration tools to make this journey easy, discuss tip/tricks we have learnt from helping customers migrate 1000s of workloads into Azure and showcase some technical demos to visualize the migration journey.2021-09-15 21:30:002021-09-15 22:45:00HydraView In Your Timezone
Azure Arc enabled data servicesDinakar NethiData AdministrationThis session will cover Microsoft’s latest offering in the Hybrid space – Azure Arc. Come find out what is Azure Arc enabled data services, what is the value proposition, what is the benefit for customers, what does the architecture look like, etc. There will be demos!2021-09-15 21:30:002021-09-15 22:45:00ShilohView In Your Timezone
What’s new in Azure’s path to an Intelligent DatabasePedro LopesDevelopmentAzure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years.

These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data!

Now join us to find about what’s coming in this new intelligent database world!

2021-09-15 21:30:002021-09-15 22:45:00YukonView In Your Timezone
Near Real Time Data Analytics with ADFSunil SabatBusiness Intelligence & Advanced AnalyticsThis session will cover how ADF can be used to orchestrate twitter data ingestion with EventHubs and perform PoweBI lead analytics in realtime. We will also cover how Tweeter data can be shaped with Synapse Warehouse to deliver enterprise analytics at scale, all on the foundation of Azure Data Factory.2021-09-15 21:30:002021-09-15 22:45:00SphinxView In Your Timezone
Develop serverless, full stack apps with Azure SQLAnna HoffmanDevelopmentLearn how to create, build, and deploy modern full stack applications in Azure by using the language of your choice (Python, Node.js, or .NET) and with a Vue.js frontend. Topics covered include modern database capabilities, CI/CD and DevOps, backend API development, REST, and more. Using a real-world scenario of trying to catch the bus, you will learn how to build and architect solutions that use Azure SQL Database, Azure Functions, Azure Static Web Apps, Logic Apps, Visual Studio Code, and GitHub Actions.2021-09-15 23:00:002021-09-16 00:15:00ShilohView In Your Timezone
Backup Options for SQL Server in Azure

Frank Gill

Data Administration

Database backups are the foundation of data protection in SQL Server. In Azure, backups for Azure SQL Database are managed, but there are options for both short- and long-term retention. Backups for SQL Server databases running on Azure VMs can be backed up using SQL Server Agent jobs. Alternately, these databases can be backed up using Azure Recovery Vault. Join me for this session to learn about these options, including demonstrations of set up and administration.2021-09-15 23:00:002021-09-16 00:15:00YukonView In Your Timezone
Understanding and designing HA/DR solutions in SQL ServerKevin FarleeData AdministrationLearn the fundamentals of HA/DR in SQL Server. Understand what solutions work best where, and what the tradeoffs are. Understanding how the HA/DR solutions work will enable you to make better choices for your systems, both in terms of protecting your data and in terms of protecting your bottom line by not paying for solutions that don’t help your situation.2021-09-15 23:00:002021-09-16 00:15:00HydraView In Your Timezone
Designing for high performance in Power BISiva Harinath &

Philip Seamark

Business Intelligence & Advanced AnalyticsIt’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.2021-09-15 23:00:002021-09-16 00:15:00SphinxView In Your Timezone
Serverless SQL Pool in Azure Synapse AnalyticsArmando LacerdaBusiness Intelligence & Advanced AnalyticsAzure Synapse Analytics is a collection of data processing engines. In this session Armando Lacerda will demo how the Serverless SQL pool, which is part of Synapse Analytics, can be used with Power BI to implement data exploration on top of a data lake.2021-09-16 12:30:002021-09-16 13:45:00ShilohView In Your Timezone
Feeding the Modern Data Warehouse

Christian Cote

Business Intelligence & Advanced Analytics

When it comes to feed the modern data warehouse in Azure, we’re facing new challenges. This session will explain what id the modern data warehouse and how it can be fed using ETL 2.0 methodologies. Topics like Common Data Model and services will also be talked and demonstrated.2021-09-16 12:30:002021-09-16 13:45:00SphinxView In Your Timezone
Azure DevOps and Database Deployment AutomationGrant FritcheyData AdministrationAutomation is a fundamental aspect when adopting a DevOps-style deployment process. Learn how you can use Azure DevOps tools to automate your database deployments successfully. Topics include the challenge of supporting more than one database system, deployments in Azure SQL Database, Postgres and Maria DB. We’ll also show how you can use Azure DevOps to deploy to an on-premises database. All the databases you have under management can have their deployments automated. Come to this session to learn how.2021-09-16 12:30:002021-09-16 13:45:00HydraView In Your Timezone
Becoming a Person of InfluenceJason HuntProfessional DevelopmentWe all want to live lives that matter, but just how do we make a positive difference? Some believe that you must have an impressive title to do so, but that is a mistake. The best leaders recognize that no matter where you are in the organization, you have influence – and intentionally using that influence to make a positive difference makes you a leader. This is a highly engaging and powerful session on leadership, breaking this complicated subject down into four simple components: A heart that cares, a head that connects, hands that collaborate, and feet that show courage. Whatever your vocation or aspiration, master these four and watch your influence lead to a greater positive impact in the lives of others – at home, at work, and in every other area of life.2021-09-16 12:30:002021-09-16 13:45:00YukonView In Your Timezone
Let’s talk Monitoring !Alain Dormehl;

Anna Hoffman

ArchitectureCome and learn from Anna and Alain, and maybe some special guests, about the latest Microsoft monitoring features for SQL. We will walk through the current product landscape, explain the current options, talk about the best options for customers, current industry trends and even look at some of the roadmap items for monitoring. This will be a session jam packed with demos and some really great features !2021-09-16 14:00:002021-09-16 15:15:00YukonView In Your Timezone
NoSQL For The SQL DBAs & Developers

Jean Joseph

Data Administration

Businesses are quickly moving to NoSQL databases to power their modern applications. Reason is that they are looking for a way to host a relatively unmodified RDBMS schema on a NoSQL database, then optimize it over time.

This presentation will show DBAs and SQL developers how to achieve the benefits of NoSQL within their environments. You’ll learn how to migrate a table-based data model to JSON documents, tweak your queries for relational JSON data, and create indexes to support fast query performance moreover the risk involved when using NoSQL.

2021-09-16 14:00:002021-09-16 15:15:00ShilohView In Your Timezone
Azure SQL readiness assessment and migration from Azure Data StudioMohamed Kabiruddin &

Rajesh Setlem

Data AdministrationIn this session we will walk you through database assessment and migration using Azure Data Studio 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 using Azure Data Studio.2021-09-16 14:00:002021-09-16 15:15:00HydraView In Your Timezone
What’s new with Azure Data FactoryWee Hyong Tok

Linda Wang

Business Intelligence & Advanced AnalyticsAzure 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. You can also lift and shift existing SSIS packages to Azure and run them with full compatibility in ADF. In this session, you’ll learn what’s news with Azure Data Factory, and resources to help you get started, and be productive with ADF.2021-09-16 14:00:002021-09-16 15:15:00SphinxView In Your Timezone
Protecting your data from tampering with Azure SQL Database ledgerJason AndersonData AdministrationHow can you rely on your business critical data if you can’t ensure that it has not been tampered with? Blockchain has been a destination for many customers who want data immutability, but blockchain is targeted at decentralized multi-party business processes. How do you get the immutability benefits blockchain offers if your system is centralized?

Azure SQL Database ledger is a new capability that uses the same cryptographic patterns employed in blockchains to protect your data from tampering. Join this session to understand how the ledger feature works, and how you can use it to build the digital trust you need in your data.

2021-09-16 15:30:002021-09-16 16:45:00HydraView In Your Timezone
An IoT application built on Azure Platform services, what to use and where to use it – an architectural guideBenjamin KettnerArchitectureWhen designing an IoT application, you have many services to chose from. But which service works how and when to choose which service? These questions need to be answered.

After implementing multiple successful IoT projects that process large volumes of data and offer the results of analytics workloads as well as monitoring of assets to customers, certain usage patterns have proven to be useful. In this session, we will dive into an architecture that has proven to be useful for many use cases, we will discuss the services used and alternatives available.

2021-09-16 15:30:002021-09-16 16:45:00SphinxView In Your Timezone
Database Modernization Best Practices & Lessons Harvested from Customer EngagementsRaj Pochiraju

Mukesh Kumar

Data AdministrationIn this session you’ll learn the real-world ins-and-outs of how we successfully migrate customers to Azure data platform. You learn, customer migration patterns, FUDs, IP & migration tools that worked in our customer migrations and modernization engagements. We also share few recent customer evidence, what worked and not.2021-09-16 15:30:002021-09-16 16:45:00YukonView In Your Timezone
Analyze Live Snowflake Data with SQL Server Analysis ServicesJerod JohnsonBusiness Intelligence & Advanced AnalyticsSQL Server Analysis Services often acts as a semantic model between SQL Server and front-end tooling for business intelligence. However, more data is moving to the cloud than ever before and that data is often too big to be imported into a model. In this session, you’ll see how to build a semantic layer using SSAS to provide real-time access to Snowflake data from any tool or platform that supports connecting to SSAS.2021-09-16 17:00:002021-09-16 18:15:00SphinxView In Your Timezone
How to Audit SQL Server for FreeJosephine BushData AdministrationAre you tired of not knowing who’s changing what on your SQL Servers? Maybe your company canÂ’t afford to buy third-party auditing tools, but there’s no need to buy expensive auditing tools if you can’t afford them or don’t want to use them. You can know about everything changing on your SQL Servers without having to pay for a tool. By auditing with the built-in features of SQL Server Audit, you can report on usage to auditors, change user permissions or passwords without breaking functionality, and/or understand your workload to migrate parts or all of your database to the cloud or other database technologies. This session will help you understand how to use SQL Server Audit. You will also learn how to compile the results in a central location for easy reporting and learn how to email audit findings with a SQL Agent job.2021-09-16 17:00:002021-09-16 18:15:00YukonView In Your Timezone
Azure Data Factory for Beginners: Let’s Make some DataLeslie AndrewsDevelopment

Does Azure Data Factory really make data? Of course not, but what it does is allow you to make your data into something new and different! In this presentation you will learn the basics of Azure Data Factory, what it DOES do, the sections of the “factory”, and how to build a basic factory output. You will learn the basic skills of a Data Factory “machinist” and how to rebuild your data.2021-09-16 17:00:002021-09-16 18:15:00ShilohView In Your Timezone
Modernize your open-source database workloads with Flexible Server for the Azure Database for Postgres and MySQLSridhar Ranganathan &

Bashar Hussein

Data AdministrationYour feedback shaped the new Flexible Server for Azure Database for PostgreSQL and MySQL managed service. Flexible Server allows you to gain operational efficiency, and yet more importantly, not give up control of your database. In this session you will learn how the new Flexible Server gives you full control of choosing your configuration, reduces cost, automates maintenance – all with flexible high availability options for your databases. You will also learn about the migration tools that can transition your data to cloud with minimal downtime.  2021-09-16 17:00:002021-09-16 18:15:00HydraView In Your Timezone
Azure SQL Database High availability & Disaster recoveryRoberto Bustos

Emily Lisa

Data AdministrationThis session will dive into Azure SQL Database High Availability and Disaster Recovery features including zone redundancy and geo replication. Come and share your expertise and feedback directly with the engineering team while also learning about the latest in HA/DR for Azure SQL Database.2021-09-16 18:30:002021-09-16 19:45:00HydraView In Your Timezone
How Storage Systems Work With SQL ServerAnthony Nocention & Argenis FernandezData AdministrationEver wonder what happens between your databae and the storage where it sits? What makes it fast? Why it may be slow? In this session you will discover how SQL Server interacts with storage devices for the different operations that it performs. You will explore the concepts of storage, Perfmon counters, understand how storage metrics directly correlate with database performance, and an overview the storage stacks in virtualization environments.2021-09-16 18:30:002021-09-16 19:45:00SphinxView In Your Timezone
Inside the Memory of SQLBob WardData AdministrationThis will be the brain melting session for the event. In this session I’ll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I’ll also describe differences in memory management for SQL Server on Linux and Azure SQL.2021-09-16 20:00:002021-09-16 21:15:00HydraView In Your Timezone
Govern Power BI and the rest of your data estate with Azure PurviewCraig BrydenArchitectureA modern data estate will consist of many different components. You could have a wide range a data services which may be Databases, Data Lakes, Power BI, and many more. Keeping track of what assets your organization has and exposing that to your stakeholders is not easy. Azure Purview is Microsoft’s latest Data Catalog product that is going to help you discover, manage, and expose these assets to your users. Join Craig for a discussion on what Data Catalogs are, how Purview works, and how it will help you.2021-09-16 21:30:002021-09-16 22:45:00SphinxView In Your Timezone
Notebooks deep dive sessionJulie Koesmarno &

Alan Yu

Data AdministrationIn this session, we will cover lessons learned during our journey in using Azure Data Studio Notebooks internally in SQL org and what it means for external customers. We’ll cover executable and automatable Troubleshooting Guides (TSGs aka. Playbook/Run Book) for external customers and internal customers. Finally, we’ll show you recent Notebook features/improvements in Azure Data Studio based on these lessons learned. 2021-09-16 21:30:002021-09-16 22:45:00HydraView In Your Timezone

Deep-Dives – 120 mins (105 mins + 15 mins Q&A) – Slides + Demos
Room for all Demo-Only Sessions: KILIMANJARO

SessionTitleSpeakerNameTrackAbstractStart_Time (UTC)End_Time(UTC)View In Your Timezone
All You Wanted to Know About CollationsErland SommarskogDevelopmentCollations is a topic that tends to confuse SQL Server professionals. It is not that the implementation of collations in SQL Server is extremely confusing, but computer people are not always well versed in human languages and character encodings, and therefore it can be a big surprise that V and W could be considered equal or that i and I could be different in a case-insensitive comparison.

In this light-minded presentation I cover what a collation controls and I explain what all the funny components in a collation name like Latin1_General_100_CI_AS_KS_WS_SC_UTF8 actually mean. I illustrate this by giving examples of how they work with different languages. I provide some tricks you can apply to overcome some traps related to collations. I give particular attention to the UTF-8 collations added in SQL 2019. Finally, I discuss how the choice of collations can affect performance.

2021-09-13 10:00:002021-09-13 12:00:00View In Your Timezone
Visualization Magic in the Age of Numbers & ScienceReid HavensBusiness Intelligence & Advanced AnalyticsPower BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations and features can be created a number of ways including: layering visuals, customizing visual formatting, and/or utilizing DAX measures. The session will include a series of visualization and reporting techniques that you’ll be able to leverage in your company’s reports to take them to the next level.2021-09-14 16:00:002021-09-14 18:00:00View In Your Timezone
Business Analysis with T-SQLDejan SarkaDevelopmentNo matter if you use SQL Server on premises, Azure SQL Database, or Azure Synapse Analytics, you might have a feeling that the main language for these services, the T-SQL language, is somehow obsolete and not capable enough for the need of the modern analytics. This session will show you the opposite. You can make advanced business analytics also with T-SQL, you do not need to use R, Python, or some other currently fashionable language for every single in-depth view in your data. In addition, you can get magnitudes better performance inside a database management system when in statistical languages and engines. You will learn how to use T-SQL for queries that you might already be familiar with, for aggregating queries. But this is only to warm you up. Then you will learn how to do hazard and survival analysis, market basket analysis with association rules using different measures like support and confidence, and even sequential market basket analysis, when there is a sequence in the basket. Then the session introduces the look-alike model, which is a mixture of k-nearest neighbor and decision trees algorithms. The session finishes with Bayesian inference implemented with T-SQL.2021-09-15 18:30:002021-09-15 20:30:00View In Your Timezone
10 superb tips about Azure Data FactoryAbhishek NarainBusiness Intelligence & Advanced AnalyticsLearn how to build enterprise-grade data pipelines using Azure Data Factory. We will run through 10 data engineering best practices which will help you build scalable and secure data pipelines. Some of the areas that we will cover are – pipeline architecture patterns, pipeline deployments, performance, governance, security, collaboration, logging and monitoring.2021-09-16 12:30:002021-09-16 14:30:00View In Your Timezone
Now where did THAT estimate come from?Hugo KornelisDevelopmentThe SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And thereÂ’s nothing you can do about it. Or is there?

In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.

Though the focus of this session is on understanding the causes of bad estimates, you will also learn ways to fix the problems and get better estimates – and hence, better performing queries.

2021-09-16 15:30:002021-09-16 17:30:00View In Your Timezone

Demo-Only – 60 mins (45 mins + 15 mins Q&A) – Demos Only (max one slide)
Room for all Demo-Only Sessions: KILIMANJARO

SessionTitleSpeakerNameTrackAbstractStart_Time(UTC)End_Time(UTC)View In Your Timezone
Docker Deep DiveAndrew PruskiData AdministrationRunning SQL Server in a Docker container has many benefits (and drawbacks!) that we as SQL professionals should be aware of.

In this demo heavy session we’ll dive deeper into running SQL Server in Docker containers. We’ll cover: –

What exactly is container isolation?

Container networking

Persisting data for SQL Server in Docker containers

Building custom SQL Docker images

Running SQL containers with Docker Compose

This session is for anyone who has run SQL Server in a container and wants to learn more about the platform

2021-09-13 16:15:002021-09-13 17:15:00View In Your Timezone
Data Lakehouse Architecture with Azure Synapse AnalyticsDavid AlzamendiArchitectureWhat are Data Lakehouses? When and why should you use this design pattern? How are they different from Data Warehouses?

This session will answer these questions and expand on how new architecture design patterns can help you solve some of your business problems and prepare for the future.

You may have heard about Data Lakes and data warehouses, but as technology evolves, there are new design patterns like Data Lakehouses that you should take into account when building data solutions.

2021-09-14 05:30:002021-09-14 06:30:00View In Your Timezone
Serverless Azure data handlingBenjamin KettnerDevelopmentHow can serverless services help you when building a data application in Azure? What serverless services exist and how do they align with the requirements of data applications? How can you use them and how do they interact?

In this all-demo-session (1 slide only) we will show you how to build a data processing pipeline using serverless services. you will learn some details that will help you to build a modern datawarehouse in Azure or any other application that handles volumes of data.

2021-09-14 10:00:002021-09-14 11:00:00View In Your Timezone
EDW Automation and Design Best PracticesBob DuffyBusiness Intelligence & Advanced AnalyticsStar schema can be very slow to develop an expensive to maintain. You need to add a column to a dimension or a new Fact table. Does that take hours, weeks, an entire development sprint, or is this just too expensive to even think about ?

In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too.

Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility.

2021-09-14 11:30:002021-09-14 12:30:00View In Your Timezone
An Hour of SQL Server Big Data Clusters DemosBob PusateriData AdministrationAttend this session and gain a better understanding of the capabilities and use cases of SQL Server Big Data Clusters, a new feature in SQL Server 2019 that combines the SQL Server relational engine with HDFS and Spark. Through this all-demo session, you will see how to work with a SQL Server Big Data Cluster, and a variety of the tasks that can be easily performed on one. If you like to learn by observing instead of just looking at slides, this is the session for you!2021-09-14 13:00:002021-09-14 14:00:00View In Your Timezone
Get to know the latest & coolest features in “Azure SQL Database Hyperscale”Pooja Kamath Balmukund LakhaniIn this session we will demo the latest and newly released features from Azure SQLDB ‘Hyperscale’- the architectural evolution of Azure SQL, which has been natively designed to take advantage of the cloud.

One of the main key features of this new architecture is the complete separation of Compute Nodes and Storage Nodes. Because of this Hyperscale service tier removes many of the practical limits traditionally seen in cloud databases

While the most common notion is that Hyperscale tier is intended for customers whose requirements encompass very large databases, we will see why it is a great fit for most business workloads that even have smaller databases, but require fast vertical and horizontal compute scaling, high performance, instant backup, fast database restore & have significant read-only workloads.

We will look at some interesting use cases from recently released features that makes Azure SQL DB Hyperscale unique & how it compares with other offerings.

Don’t worry if you are new to Azure SQL DB Hyperscale! Our session will also look at the brief overview of the revolutionary Hyperscale architecture before we dive into the demos

2021-09-15 12:30:002021-09-15 13:30:00View In Your Timezone
Parallelism in Microsoft SQL ServerTorsten StraussProfessional DevelopmentSQL Server can execute queries in parallel which can sometimes improve the performance of your queries. However, parallelism has its own challenges; therefore, we will look at the concept of parallel executions to understand when it makes sense to run a query on more than one thread. We deal with topics such as CXPacket, threads, workers, execution context, branches, MAXDOP, Cost threshold for parallelism, NUMA nodes and the iterators that SQL Server can implement in the execution plan to enable parallelism.2021-09-15 17:00:002021-09-15 18:00:00View In Your Timezone
Azure SQL Edge : Real-time analysis of IoT DataSourabh Agarwal, Vasiya KrishnanData AdministrationIn this session, we will be designing an end to end IoT solution for real time data analysis. This is a demo-only session where we will take you from

1. Setting up the sensors

2. Streaming the data from sensors to the Azure SQL Edge module

3. Conducting real-time analysis using the Time-series/AI/ML features in Azure SQL Edge

4.Data visualization and managing Azure SQL Edge across multiple devices

2021-09-15 23:00:002021-09-16 00:00:00View In Your Timezone
Conditional Formatting Tricks in Power BI

Pragati JainBusiness Intelligence & Advanced Analytics

In this session we will see different ways of applying conditional formatting to a Power BI reports at data level and visual level.

The session will cover the following details:

 Data Level Conditional Formatting

• Explore default conditional formatting options on data in Power BI:

a. Background Colour

b. Font Colour

c. Data Bars

d. Icons

• Using a calculated measure to create conditional formatting

• Use custom icons for conditional formatting

 Visual Level Conditional Formatting

• Conditional titles on the visuals based on the Slicer Selection

• Conditional Background colour to the visuals using a measure calculation

2021-09-16 18:30:002021-09-16 19:30:00View In Your Timezone
No Code Custom Visuals in CharticulatorMike CarloBusiness Intelligence & Advanced AnalyticsLearn how to use the most advanced custom visual from the Microsoft team – Charticulator. A Long time fan and massive advocate for the Charticulator app Mike Carlo will guide you through how to use and build visuals within the Charticulator app. Learn how to make simple visuals all the way to highly complex and stylized versions.2021-09-16 20:00:002021-09-16 21:00:00View In Your Timezone
SQL Assessment – Microsoft’s Best Practices CheckerTaiob AliData AdministrationDo you want to get the current 204 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud.

In this all demo session (Yes, no slides), I will show you both the “what” and “how” to use the SQL assessment API. You will learn if a setting is changed after your initial check. How to customize your checks and create your own rules that fit your environments? The demo will use SQL assessment API, PowerShell cmdlets, and the new ‘SQL Assessment’ extension in Azure Data Studio to export assessment results in a SQL table and create an HTML report.

At the end of this session, you will be equipped with the toolset to set up and run your own assessment, create customized rules, and determine your compliance score against suggested best practices.

2021-09-16 21:30:002021-09-16 22:30:00View In Your Timezone

Short Drive – 30 mins (25 mins + 5 mins Q&A) – Slides + Demos
Room for all Demo-Only Sessions: KILIMANJARO

SessionTitleSpeakerNameTrackAbstractStart_Time (UTC)End_Time (UTC)View In Your Timezone
Azure Function for Everyone.

Alpa Buddhabhatti

Development

In this session, we will provide you with an overview of Azure Function. Azure Function is a fully managed serverless integration service. A use case with Azure Function and Azure Blob Storage and Azure Key Vault will be used for a demo. You’ll also learn about Continuous Integration and Continuous Delivery of Azure Function objects using Azure DevOps Pipelines.

At the end of this session, you’ll have a basic understanding of both Azure Function and Azure DevOps. You can apply these ideas to event driven scenarios and the automation of Azure Function pipelines.

2021-09-13 07:00:002021-09-13 07:30:00View In Your Timezone
Run Microsoft Azure Arc enabled data services anywhereBapi ChakrabortyArchitectureThis lightening talk (with a short demo) will focus on Architecture and solutions made possible by Azure Arc enabled data services anywhere. With latest innovation, we are now able to run always updated, scalable, Azure data services on any infrastructure. With Azure Arc, any enterprise can deploy Azure SQL Managed Instance or PostgreSQL (with hyperscale) to supported Kubernetes infrastructure whether on-premises, on any cloud or at the edge. This also includes unified & at scale management and always updated services.2021-09-13 07:45:002021-09-13 08:15:00View In Your Timezone
Benefits of Installing IaaS Agent Extension on Azure SQL VMAmeena Lalani

Data AdministrationSQL Server IaaS Agent Extension, formerly known as Resource Provider, enables additional management capabilities for self-installed SQL Server on Azure VMs. It provides PaaS-like capabilities to IaaS-based SQL for customers who adopt it. During this session, I will demonstrate some of the unique benefits of the SQL IaaS extension that will help you discover, manage and administer your SQL Servers in Azure VM.

This is what you are going to learn in this session.

1. What is IaaS?

2. What is IaaS Agent Extension?

3. What are the Benefits of enabling this extension?

4. How to enable and disable this extension?

2021-09-13 13:00:002021-09-13 13:30:00View In Your Timezone
Machine Translation – Empowering users and organization to be more productive by minimizing the language barrier

Charan Mohan

Data Science (AI/ML)

As businesses and supply chains have globalized, organizations need to continue to remain productive ensuring language is not a barrier for communication. Not only large organizations but large populations of multi-lingual societies are now trickling into the digital world for the very first time. Businesses are now looking to tap into this underserved user populace which represents a significant opportunity (The next billion users). Microsoft, through our Translation API (as part of azure cognitive services) provides developers and users with the ability to embed machine translation into their services and platforms thus enabling translation of text in real time or in batch across 90 languages and dialects. The translation service is built atop the latest advancements in neural machine translation (NMT) with built in data security. In this talk, I will walk through the various capabilities offered by the Azure cognitive- Translation service and how these services are being employed to reduce barriers to adoption across products and services both within Microsoft and by other customers.

We will dive deep into aspects of Text translation, language detection, transliteration, document translation and the ability for organizations to train and deploy custom translation models via the custom translator API.

2021-09-13 13:45:002021-09-13 14:15:00View In Your Timezone
Microsoft latest Web UI technology, Blazor, working with Azure SQL Azure database in cloud

Ming Man Chan

Development

The topic is targeted at startup organizations that have limited resources to develop coding and maintain the infrastructure. ASP.NET has been using many JavaScript and proven hard to maintain. Thus, Microsoft has emerged a new platform to do all the necessary code in C#, Blazor. Blazor uses open web standards without plug-ins or code transpilation. Blazor is able to work in all modern web browsers, including mobile browsers. In order to setup servers and maintain databases is not cost efficient for the startup company. By using SQL Azure Database organization can mitigate the infrastructure cost and focus on the business core competency. In this short session you will learn how to get started with Blazor UI as a frontend and SQL Azure as a backend for your solution.2021-09-14 07:00:002021-09-14 07:30:00View In Your Timezone
Remote Work and Certifications

Oluwaseyi Oluwawumiju

Professional Development

The session will take a dive into the new Role base certification and its effect and how we can align it with remote jobs.2021-09-14 07:45:002021-09-14 08:15:00View In Your Timezone
Top 13 best security practices for Azure

Radu Vunvulea

Architecture

Security nowadays is just a buzzword. Even so, by joining this session, we discover together what are the most important security best practices that you need to have in mind when you work inside the cloud – inside Microsoft Azure.

2021-09-14 08:30:002021-09-14 09:00:00View In Your Timezone
AI: Powering New Possibilities with Indian Languages

Shaily Goel

Data Science (AI/ML)

AI growth in India is happening at exponential level. As per the Accenture report, AI will add $957million to Indian Economy by 2035. Today more and more Indian users are using internet. Phone growth is massive. 9 out of every 10 users uses phone to communicate. However Large portion of this population still cannot read and write. Voice is the important communication media for all these users. These users will harness the power of internet eventually in their own vernacular language. Hence Government is pushing hard enterprises to enable AI for barrier free communications. Initiatives like NLTM are steps towards it. Multiple Indian startups are funded that taps into regional language. Voice, vernacular and video will be important pillars of the India AI growth. . This talk aims to showcase the work Microsoft is doing in this space for India market, showcasing use cases that are powered by these AI services for India.

2021-09-14 09:15:002021-09-14 09:45:00View In Your Timezone
NLP Capabilities with Azure Cognitive Services.

Disha Agarwal

Data Science (AI/ML)

With Language cognitive services, we bring multiple cloud-based NLP Capabilities such as language understanding, entity extraction, question answering, sentiment analysis, language detection etc, within the reach of every developer – without requiring machine-learning expertise. These capabilities enable developers to easily build NLP capabilities into their apps to power business solutions. For instance, Language understanding and Question Answering capabilities are leveraged to build conversational bots. Sentiment analysis and opinion mining capabilities are leveraged for use cases such as analyzing surveys, social media feedback on products and even customer support calls. Many of these applications can be integrated with other cognitive services such as Speech and Translation to power more sophisticated use cases such as voice assistants across multiple languages. Through the course of the presentation, I will be talking about some of these NLP capabilities and how enterprises are building business solutions with these capabilities.

2021-09-15 14:00:002021-09-15 14:30:00View In Your Timezone
Fast GDPR compliance

Yuli Stremovsky

Industry Solution

Privacy by design compliance is a challenging task for most startups. It is better to build it from the first steps of the product. Otherwise, you will have to add privacy to an already developed product. It is much more complicated and much more expensive. In this session, I am going to deep dive into a Databunker. Databunker is a Swiss army knife tool for storing personal records or PII. Databunker is an open-source, network-based, self-hosted, GDPR compliant, secure storage for personal data. This product can streamline GDPR compliance.

2021-09-15 14:45:002021-09-15 15:15:00View In Your Timezone
Power BI Tips to increase your productivity

Mohammed Adnan

Development

All about short cuts and tips to increase the Power BI development and some of the Industry best practices which we need to follow2021-09-15 15:30:002021-09-15 16:00:00View In Your Timezone
IoT Data: From Edge to Cloud – OPC/UA data Journey using Azure IoT EnvironmentJorge MaiaProfessional DevelopementCome to a journey of the data from sensors, PLCs, and industrial hardware with OPC/UA, passing through transformation and filtering on the Edge, Its ingestion on the cloud, and finally presenting a Time Series model. In this session, you will see how to connect an Azure IoT Edge device to an OPC/UA server, subscribe to data, transform the payload to have a smooth path on IoT services in the cloud, and then present data as a Time Series on the Time Series Insights. After this presentation, you will understand the architecture of the solution that you will need to reproduce with a clear understanding of pitfalls and challenges.2021-09-15 16:15:002021-09-15 16:45:00View In Your Timezone
Power BI: Modernizing Obsolete Semantic ModelsThimantha VidanagamageBusiness Intelligence & Advanced AnalyticsAre you an owner of a semantic model which was developed before Power BI dataflows were introduced? It is time to modernize your semantic model by integrating dataflows. In this lightning talk, I will take you through the process of integrating dataflows into your existing Power BI semantic models. By the end of the session, you will have an understanding on how to modernize your existing semantic models in Power BI by integrating dataflows.2021-09-15 20:45:002021-09-15 21:15:00View In Your Timezone
See how Decision AI can boost decision Intelligence organizations for better business outcomes

Neta Hiaby

Data Science (AI/ML)

Decision AI can be used to personalize your customer experience, improve your supply chain management, detect anomalies in your business or equipment and more. In this session we will see how Azure Decision AI can improve business processes and assist with decision in organizations. Data is everywhere and effective decision making keeps getting more difficult. Azure Decision AI enables you to make ever-faster decisions based on data analysis such as anomaly detections and personalization. See how you can use Azure Decision AI in your organization to instill better decision intelligence and make more impactful data-driven decisions.

2021-09-15 21:30:002021-09-15 22:00:00View In Your Timezone
Microsoft Azure AI – Computer Vision

Varsha Parthasarathy

Data Science (AI/ML)

Learn what’s new in Azure Vision AI and build new capabilities with Azure Cognitive Services APIs.

2021-09-15 22:15:002021-09-15 22:45:00View In Your Timezone
Working with Azure SQL DB Serverless

Carlos Lopez

Data Administration

Abstract:

Summary: In this session we will be working with Azure SQL DB, we will be exploring

the use of the compute model serverless. Using the Azure CLI, and the declarative mode we will be

creating, deleting and altering the server and databases. All of this with the help of Visual Studio Code

integrating with different technologies to make SQL Server better.

Goal 1: Provisioning the server with the serverless compute model

Goal 2: Creating and altering db using declarative model through Azure CLI

2021-09-16 14:45:002021-09-16 15:15:00View In Your Timezone
Analysing text with Azure Cognitive Services for Language

Parashar Shah

Data Science (AI/ML)

With Azure Cognitive services for Language, we bring multiple cloud-based NLP Capabilities such as Text Analytics for health, entity extraction, question answering, sentiment analysis, summarization, etc, within the reach of every developer – without requiring machine-learning expertise. In this session, I will give an overview of Text Analytics pre-built AI models and then do a deep dive in to Text Analytics for health. Text Analytics for health is a feature of the Text Analytics (Language) service that extracts and labels relevant medical information from unstructured texts such as doctor’s notes, discharge summaries, clinical documents, and electronic health records. I will also talk about integration available with Power Platform and Azure Search to easily consume our pre-built AI models in your end to end enterprise scenario.

2021-09-16 23:00:002021-09-16 23:30:00View In Your Timezone
Speaker NameTopicStart_Time (UTC)End_Time (UTC)RoomView In Your Timezone
Tom MartensPower BI2021-09-13 05:30:002021-09-13 06:45:00HekatonView In Your Timezone
David AlzamendiAzure Synapse Analytics2021-09-13 05:30:002021-09-13 06:45:00KatmaiView In Your Timezone
Nikola IlicPower BI2021-09-13 07:00:002021-09-13 08:15:00HekatonView In Your Timezone
Taiob AliMonitor Azure SQL Database2021-09-13 10:00:002021-09-13 11:15:00HekatonView In Your Timezone
Andrea Martorana TusaPower BI Reports Embedded in Sharepoing2021-09-13 10:00:002021-09-13 11:15:00KatmaiView In Your Timezone
Ameena LalaniAzure SQL DB, MI and VM2021-09-13 11:30:002021-09-13 12:45:00KatmaiView In Your Timezone
Sandy WinarkoSSIS in ADF2021-09-13 11:30:002021-09-13 12:45:00HekatonView In Your Timezone
Michelle GutzaitSQL Server on-prem or in the Cloud2021-09-13 13:00:002021-09-13 14:15:00HekatonView In Your Timezone
Markus Ehrenmueller-JensenPower BI2021-09-14 05:30:002021-09-14 06:45:00KatmaiView In Your Timezone
Mohammed AdnanPower BI2021-09-14 07:00:002021-09-14 08:15:00KatmaiView In Your Timezone
Daron YondemServerless AI  2021-09-14 07:00:002021-09-14 08:15:00HekatonView In Your Timezone
Amit KhandelwalSQL Server on Linux/Containers and Kubernetes2021-09-14 08:30:002021-09-14 09:45:00KatmaiView In Your Timezone
Neil HamblyAzure Machine Learning2021-09-14 08:30:002021-09-14 09:45:00HekatonView In Your Timezone
Augustin Dokoza BukvicPower BI Governance2021-09-14 10:00:002021-09-14 11:15:00KatmaiView In Your Timezone
Alexandra CiorteaModernize Your Oracle Workloads to Azure SQL2021-09-14 11:30:002021-09-14 12:45:00KatmaiView In Your Timezone
Mohit BatraAzure Synapse Analytics2021-09-14 13:00:002021-09-14 14:15:00HekatonView In Your Timezone
Leslie AndrewsData Modeling2021-09-14 13:00:002021-09-14 14:15:00KatmaiView In Your Timezone
Warner ChavesCloud Data Platforms2021-09-14 16:00:002021-09-14 17:15:00KatmaiView In Your Timezone
Sridhar Ranganathan/Bashar HusseinAzure Database for PostgreSQL & MySQL – Flexible Server2021-09-14 16:00:002021-09-14 17:15:00HekatonView In Your Timezone
Ming Man ChanMicrosoft latest Web UI technology, Blazor, working with Azure SQL Database2021-09-15 12:30:002021-09-15 13:45:00HekatonView In Your Timezone
James BroomeAzure Synapse Analytics2021-09-15 12:30:002021-09-15 13:45:00KatmaiView In Your Timezone
Gaurav MalhotraUnified Data Governance with Azure Purview2021-09-15 14:00:002021-09-15 15:15:00KatmaiView In Your Timezone
Kathi KellenbergerT-SQL 2021-09-15 17:00:002021-09-15 18:15:00HekatonView In Your Timezone
Hariharan RajendranPower BI 2021-09-15 17:00:002021-09-15 18:15:00KatmaiView In Your Timezone
Kevin FeaselTBD2021-09-15 18:30:002021-09-15 19:45:00HekatonView In Your Timezone
Bob PusateriSQL Server Big Data Clusters2021-09-15 18:30:002021-09-15 19:45:00KatmaiView In Your Timezone
Alpa BuddhabhattiAzure Data Factory2021-09-15 20:00:002021-09-15 21:15:00KatmaiView In Your Timezone
Pam Lahoud

David Pless

Aditya Badramraju

SQL Server on Azure Virtual Machines2021-09-15 20:00:002021-09-15 21:15:00HekatonView In Your Timezone
Parv ChanaAnything Power BI2021-09-15 21:30:002021-09-15 22:45:00HekatonView In Your Timezone
Dustin DorseyAzure Cost Management/ Azure Data2021-09-15 21:30:002021-09-15 22:45:00KatmaiView In Your Timezone
Kay SauterSQL Server2021-09-16 12:30:002021-09-16 13:45:00KatmaiView In Your Timezone
Bob WardEverything SQL2021-09-16 15:30:002021-09-16 16:45:00KatmaiView In Your Timezone
Dejan SarkaSQL Server Security2021-09-16 17:00:002021-09-16 18:15:00KatmaiView In Your Timezone
Matt GordonAzure Cognitive Services Speech and Language2021-09-16 17:00:002021-09-16 18:15:00HekatonView In Your Timezone
Erland SommarskogProgramming and systems development with T-SQL2021-09-16 18:30:002021-09-16 19:45:00KatmaiView In Your Timezone
Josephine BushSQL Server Auditing2021-09-16 20:00:002021-09-16 21:15:00KatmaiView In Your Timezone
SQL Server HA/DRKevin Farlee2021-09-16 20:00:002021-09-16 21:15:00HekatonView In Your Timezone
Sunil SabatAzure Data Factory2021-09-16 21:30:002021-09-16 22:45:00HekatonView In Your Timezone
Dinakar NethiAzure Arc Enabled Services2021-09-16 21:30:002021-09-16 22:45:00KatmaiView In Your Timezone