Session Recordings (DPS 2020 & 2021)

Training Class Recordings

Here you can access the recordings of DPS 2021 & 2020 general sessions. Browse from 300+ amazing content items. All are free for the worldwide data community. Use the Search box to filter the content on any keyword you like. Happy Learning 🙂

Wish to download session resources from the last 7 years? Click Here

DPS 2021

DPS 2020

Speaker Name Track SessionType Session Title Abstract Recordings
Anna Hoffman, Bob Ward, Buck Woody NA Keynote Keynote SQL is everywhere you need it from the IoT Edge to your data center to public clouds. With all of these options, it can be difficult to know which to choose and why each option may be right for your data needs. In this presentation, we’ll review with you all the current released and preview versions of SQL from the edge to the cloud. We’ll compare each of them and discuss why you want to get ahead of the curve by understanding what is possible with the modern SQL data platform. We’ll discuss the technical details of some of these options so you can understand what SQL “flavor” fits your company’s needs. This session will include some demos to highlight key innovations with SQL. Watch Now
Anna Hoffman, Lindsey Allen, Marisa Brasile, Vicky Harp, Nikita Takru, Mara-Florina Steiu NA Panel Discussion WIT Panel Discussion NA Watch Now
Jennifer Stirrup, Sandip Pani, Sangeetha Gupta, Deepthi Goguri, Kay Sauter NA Panel Discussion DEI Panel Discussion NA Watch Now
Kevin Feasel Data Science (AI/ML) Breakouts Getting Beyond the Basics with Azure Machine Learning 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. Watch Now
Leonard Lobel Development Breakouts Building Event-Driven Microservices with the Azure Cosmos DB Change Feed The 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. Watch Now
Uwe Ricken Development Breakouts Simplify data management with partitioning The 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.

Watch Now
Louis Imershein Data Administration Breakouts Monitoring SQL Server on Linux performance with Performance Co-Pilot and Grafana Recent 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.

Watch Now
Alex Yates Development Breakouts Zero downtime database deployments You 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.

Watch Now
Dejan Sarka Development Deep-Dives Business Analysis with T-SQL No 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. Watch Now
Pragati Jain Business Intelligence & Advanced Analytics Demo-Only Conditional Formatting Tricks in Power BI 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

Watch Now
Josephine Bush Data Administration Breakouts How to Audit SQL Server for Free Are 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. Watch Now
Vitor Fava Architecture Breakouts How to achieve the best performance and scalability on your Azure SQL Database using the Hyperscale In 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

Watch Now
James Broome Business Intelligence & Advanced Analytics Short Drive Insight Discovery – how to define business requirements for a successful cloud data & analytics project Many 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. Watch Now
Daron Yondem Data Science (AI/ML) Breakouts The ML Hero’s Secret Weapon: AutoML 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. Watch Now
Paul Ou Yang Data Administration Breakouts Querying Azure Log Analytics with Kusto To 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. Watch Now
Nikola Ilic Business Intelligence & Advanced Analytics Breakouts Power BI Performance – 7 deadly sins! Congratulations! 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.

Watch Now
Bob Pusateri Data Administration Demo-Only An Hour of SQL Server Big Data Clusters Demos Attend 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! Watch Now
Jason Hunt Professional Development Breakouts Becoming a Person of Influence We 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. Watch Now
Ferenc Csonka Business Intelligence & Advanced Analytics Breakouts Tips & Tricks for creating Paginated Reports based on Power BI datasets Power 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.

Watch Now
Chris ADKIN Data Administration Breakouts Building a Production Environment for Azure Arc enabled Data Services Thinking 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. Watch Now
Grant Fritchey Data Administration Breakouts Azure DevOps and Database Deployment Automation Automation 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. Watch Now
Mike Carlo Business Intelligence & Advanced Analytics Demo-Only No Code Custom Visuals in Charticulator Learn 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. Watch Now
Thomas Grohser Data Administration Breakouts Using clustered columnstore indexes efficently Clustered 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.

Watch Now
Craig Bryden Architecture Breakouts Govern Power BI and the rest of your data estate with Azure Purview A 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. Watch Now
Hugo Kornelis Development Deep-Dives Now where did THAT estimate come from? The 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.

Watch Now
Tammy Guns Professional Development Breakouts Bad Decisions Revealed: How our Emotional Brain Wins Over our Thinking Brain Every Single Time! Do 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! Watch Now
Michelle Gutzait Development Breakouts Help!! My SQL Server database is not performing well! Too 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.

Watch Now
Torsten Strauss Professional Development Demo-Only Parallelism in Microsoft SQL Server SQL 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. Watch Now
Warner Chaves Business Intelligence & Advanced Analytics Breakouts Building a Data Lake with Azure Synapse Analytics Synapse 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.

Watch Now
Erland Sommarskog Development Deep-Dives All You Wanted to Know About Collations Collations 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.

Watch Now
Hasan Savran Industry Solution Breakouts Starting with Azure SQL Edge on Raspberry Pi Azure 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.

Watch Now
Kathi Kellenberger Data Administration Breakouts Getting Started with Extended Events Over 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. Watch Now
Deepthi Goguri Data Administration Breakouts Getting started with Query Store Do 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!

Watch Now
Andrew Pruski Data Administration Demo-Only Docker Deep Dive Running 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

Watch Now
Gilbert Quevauvilliers Business Intelligence & Advanced Analytics Breakouts Quicker, faster and easier Power BI datasets using Power BI Premium Per User/Premium ○ 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…

Watch Now
Benjamin Kettner Development Demo-Only Serverless Azure data handling How 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.

Watch Now
Taiob Ali Data Administration Demo-Only SQL Assessment – Microsoft’s Best Practices Checker Do 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.

Watch Now
Jorge Maia Professional Developement Demo-Only IoT Data: From Edge to Cloud – OPC/UA data Journey using Azure IoT Environment Come 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. Watch Now
Will Velida Development Breakouts Data Modelling in Azure Cosmos DB Modelling 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.

Watch Now
Bob Duffy Business Intelligence & Advanced Analytics Demo-Only EDW Automation and Design Best Practices Star 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.

Watch Now
Markus Ehrenmueller-Jensen Business Intelligence & Advanced Analytics Demo-Only From Report to Interactive Data Application with Power BI Reports 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!

Watch Now
Niels Berglund Development Breakouts How to do Real-Time Analytics Using Apache Kafka and Azure Data Explorer The 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.

Watch Now
Matt Gordon Data Science (AI/ML) Breakouts The Data Talks Back: Speech & Language AI for the Data Professional 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! Watch Now
David Alzamendi Architecture Demo-Only Data Lakehouse Architecture with Azure Synapse Analytics What 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.

Watch Now
Thimantha Vidanagamage Business Intelligence & Advanced Analytics Short Drive Power BI: Modernizing Obsolete Semantic Models Are 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. Watch Now
Tom Martens Business Intelligence & Advanced Analytics Breakouts Power BI Universe – Mapping the hive In 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.

Watch Now
Wolfgang Strasser Architecture Breakouts Why Data Governance is important and how you can start immediately with Azure Purview Collecting 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.

Watch Now
Kevin Chant

Sander Stad

Development Breakouts Enough of the Azure Pipeline GUI demos for Data Platform deployments I’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.

Watch Now
Andreas Erben Data Science (AI/ML) Breakouts Vision in Microsoft Azure Cognitive Services 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.

Watch Now
Alpa Buddhabhatti Development Short Drive Azure Function for Everyone. 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.

I tried to make it more personal by using “you” instead of attendee. I also explained what ADF is in one sentence, so that readers who’ve never heard of ADF have some idea what it does.

Watch Now
Leslie Andrews Development Breakouts Azure Data Factory for Beginners: Let’s Make some Data 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. Watch Now
Kay Sauter Development Breakouts Automated provisioning of SQL Server VMs on Azure 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. Watch Now
Ameena Lalani Data Administration Short Drive Benefits of Installing IaaS Agent Extension on Azure SQL VM SQL 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?

Watch Now
Dinakar Nethi Data Administration Breakouts Azure Arc enabled data services This 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! Watch Now
Alain Dormehl

Mara Steiu

Data Administration Breakouts Data Replication in Azure SQL and Beyond This 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. Watch Now
Alain Dormehl

Anna Hoffman

Architecture Breakouts Let’s talk Monitoring ! Come 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 ! Watch Now
Andreas Wolter Data Administration Breakouts Latest Access Control enhancements in Azure SQL Learn 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. Watch Now
Roberto Bustos

Emily Lisa

Data Administration Breakouts Azure SQL Database High availability & Disaster recovery This 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. Watch Now
Pedro Lopes Development Breakouts What’s new in Azure’s path to an Intelligent Database Azure 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!

Watch Now
Jason Anderson Data Administration Breakouts Protecting your data from tampering with Azure SQL Database ledger How 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.

Watch Now
Pam Lahoud

David Pless

Aditya Badramraju

Rajesh Setlem

Data Administration Breakouts SQL Server on Azure Virtual Machines Reimagined: Overview Running 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. Watch Now
Pam Lahoud

David Pless

Aditya Badramraju

Data Administration Breakouts SQL Server on Azure Virtual Machines Reimagined: Sizing Deep Dive Typically, 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. Watch Now
Pam Lahoud

David Pless

Aditya Badramraju

Data Administration Breakouts SQL Server on Azure Virtual Machines Reimagined: Storage Deep Dive Optimizing 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!

Watch Now
Julie Koesmarno

Alan Yu

Data Administration Breakouts Notebooks deep dive session In 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.  Watch Now
David Trigano

Michael Makhlevich

Data Administration Breakouts Protect your SQL assets anywhere with Azure Defender for SQL SQL 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. Watch Now
Bob Ward

Niko Neugebauer

Data Administration Breakouts Inside Azure SQL Managed Instance SQL 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. Watch Now
Anna Hoffman Data Administration Breakouts What’s new in Azure SQL If you want to get started quickly with Azure SQL Managed Instance, this session is for you including demonstrations and resources to accelerate your journey for SQL in the cloud. Watch Now
Anna Hoffman Development Breakouts Develop serverless, full stack apps with Azure SQL Learn 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. Watch Now
Sourabh Agarwal

Vasiya Krishnan

Data Administration Demo-Only Azure SQL Edge : Real-time analysis of IoT Data In 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

Watch Now
Wee Hyong Tok

Linda Wang

Business Intelligence & Advanced Analytics Breakouts What’s new with Azure Data Factory Azure Data Factory is Azure’s cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management. 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. Watch Now
Bob Ward

Anshul Rampal

Architecture Breakouts Inside Serverless SQL pools in Azure Synapse Analytics Azure 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. Watch Now
Sunil Sabat Business Intelligence & Advanced Analytics Breakouts Near Real Time Data Analytics with ADF This 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. Watch Now
Sandy Winarko Business Intelligence & Advanced Analytics Breakouts New Enterprise-Friendly Features for SSIS in Azure Data Factory This 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. Watch Now
Gaurav Malhotra Business Intelligence & Advanced Analytics Breakouts Unified Data Governance with Azure Purview Azure 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. Watch Now
Saveen Reddy Business Intelligence & Advanced Analytics Breakouts Azure Synapse Analytics: Overview, Updates, & Roadmap Azure 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. Watch Now
Mohamed Kabiruddin

Rajesh Setlem

Data Administration Breakouts Azure SQL readiness assessment and migration from Azure Data Studio In 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. Watch Now
Raj Pochiraju

Ajay Jagannathan

Data Administration Breakouts Discover, assess Azure SQL readiness of SQL Server data estate at scale using Azure Migrate service Come 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. Watch Now
Raj Pochiraju

Mukesh Kumar

Data Administration Breakouts Database Modernization Best Practices & Lessons Harvested from Customer Engagements In 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. Watch Now
Alexandra Ciortea Data Administration Breakouts Modernize your Oracle workloads to Azure SQL Are 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 Tool Watch Now
Bob Ward Data Administration Breakouts Inside the Memory of SQL This 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. Watch Now
Drew Skwiers-Koballa

Alan Yu

Development Breakouts What’s New in SQL Tools for Developers With the growth of cross platform environments and DevOps for databases, now is a great time to learn about database development in Azure Data Studio 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. Watch Now
Amit Khandelwal Data Administration Breakouts SQL Server on Linux- Deployments made easy! This 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! Watch Now
Amit Khandelwal Data Administration Breakouts SQL Stateful Containers on Kubernetes with Helm! SQL 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! Watch Now
Kevin Farlee Data Administration Breakouts Understanding and designing HA/DR solutions in SQL Server Learn 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. Watch Now
Arun Thiagarajan Data Administration Breakouts Migrate Your MySQL and PostgreSQL Databases to Azure Ever 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. Watch Now
Sridhar Ranganathan

Bashar Hussein

Data Administration Breakouts Modernize your open-source database workloads with Flexible Server for the Azure Database for Postgres and MySQL Your 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.   Watch Now
Patrick LeBlanc Business Intelligence & Advanced Analytics Breakouts PowerBI Vision, strategy and roadmap Power 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. Watch Now
Siva Harinath

Philip Seamark

Business Intelligence & Advanced Analytics Breakouts Designing for high performance in Power BI It’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. Watch Now
Abhishek Narain Business Intelligence & Advanced Analytics Deep-Dives 10 superb tips about Azure Data Factory Learn 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. Watch Now
Denzil Ribeiro Data Administration Breakouts Scaling database workloads with Azure SQL Hyperscale Azure SQL Hyperscale, the innovative architecture of Azure SQL Database, provides applications with scale and availability needed from a cloud database. In this session, we will discuss Hyperscale architecture, including new scalability improvements in the platform. We will also discuss recently released and upcoming features, and cover Hyperscale-specific diagnostics that help gain insights into system performance. Watch Now
Bapi Chakraborty Architecture Short Drive Run Microsoft Azure Arc enabled data services anywhere This 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. Watch Now
Josh Caplan Business Intelligence & Advanced Analytics Breakouts Azure Synapse Analytics: AI, Synapse Link, and Microsoft Business Applications Azure 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. Watch Now
Bhanu Prakash Business Intelligence & Advanced Analytics Breakouts Azure Databricks for AI and Analytics Azure 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 Watch Now
Yuli Stremovsky Industry Solution Short Drive Fast GDPR compliance 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. Watch Now
Sravani Saluru Data Administration Breakouts Azure Database for MYSQL – Flexible Server 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

Watch Now
Richard Conway Architecture Breakouts Enterprise data governance with Azure Purview 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.

Watch Now
Radu Vunvulea Architecture Short Drive Top 13 best security practices for Azure 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. Watch Now
Parv Chana Business Intelligence & Advanced Analytics Breakouts Best Practices Using Power BI datasets in Paginated Reports – 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.

Watch Now
Oluwaseyi Oluwawumiju Professional Development Short Drive Remote Work and Certifications The session will take a dive into the new Role base certification and its effect and how we can align it with remote jobs. Watch Now
Mohit Batra Business Intelligence & Advanced Analytics Breakouts Delta Lake with Azure Databricks – Let’s build a reliable Data Lake! 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.

Watch Now
Mohammed Adnan Development Short Drive Power BI Tips to increase your productivity All about short cuts and tips to increase the Power BI development and some of the Industry best practices which we need to follow Watch Now
Ming Man Chan Development Short Drive Microsoft latest Web UI technology, Blazor, working with Azure SQL Azure database in cloud 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. Watch Now
Magnus Ahlkvist Development Breakouts Test Driven Database 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.

Watch Now
Jean Joseph Data Administration Breakouts NoSQL For The SQL DBAs & Developers 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.

Watch Now
Hariharan Rajendran Business Intelligence & Advanced Analytics Breakouts Tips and Tricks to Modernize Power BI Paginated Reports 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.

Watch Now
Frank Gill Data Administration Breakouts Backup Options for SQL Server in Azure 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. Watch Now
Dustin Dorsey Industry Solution Breakouts Knowing and Controlling Your Azure Spend 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. Watch Now
Dennes Torres Business Intelligence & Advanced Analytics Breakouts Power BI: Using streaming for real-time data 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 bi Watch Now
Christian Cote Business Intelligence & Advanced Analytics Breakouts Feeding the Modern Data Warehouse 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. Watch Now
Carlos Lopez Data Administration Short Drive Working with Azure SQL DB Serverless 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

Watch Now
Ben Miller Data Administration Breakouts DBAs getting more done in less time with PowerShell 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. Watch Now
Balram Prasad Development Breakouts Intro to Azure Data Service and Azure Synapse Analytics 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 synapse Watch Now
Andrea Martorana Tusa Business Intelligence & Advanced Analytics Breakouts Power BI scenarios for automated monitoring 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.

Watch Now
Adewale Yusuf Business Intelligence & Advanced Analytics Breakouts Advanced Conditional Formatting in Power BI Learn to configure conditional formatting rules to add colours & dynamic text to Power BI Dashboards Watch Now
Pooja Kamath

Balmukund Lakhani

Demo-Only Get to know the latest & coolest features in “Azure SQL Database Hyperscale” In 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

Watch Now
Daman Kaur Data Administration Short Drive Enabling Data with Azure Arc The 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.

Watch Now
Shaily Goel Data Science (AI/ML) Short Drive AI: Powering New Possibilities with Indian Languages 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. Watch Now
Charan Mohan Data Science (AI/ML) Short Drive Machine Translation – Empowering users and organization to be more productive by minimizing the language barrier 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.

Watch Now
Neta Haiby Data Science (AI/ML) Short Drive See how Decision AI can boost decision Intelligence organizations for better business outcomes 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. Watch Now
Varsha Parthasarathy Data Science (AI/ML) Short Drive Microsoft Azure AI – Computer Vision Learn what’s new in Azure Vision AI and build new capabilities with Azure Cognitive Services APIs. Watch Now
Disha Agarwal Data Science (AI/ML) Short Drive NLP Capabilities with Azure Cognitive Services. 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. Watch Now
Sandip Pani Data Science (AI/ML) Breakouts Build your first recommendation engine using AWS Personalize with Zero ML experience 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. Watch Now
Parashar Shah Data Science (AI/ML) Short Drive Analysing text with Azure Cognitive Services for Language 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. Watch Now
Charley Hanania Architecture Breakouts Data Platform Confusion: What are viable Data Platform Options when considering Azure from On-Prem? 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.

Watch Now
Grant Fritchey

Santiago Arias

Industry Solution Product Showcase Getting more realistic texting into your database DevOps process with Flyway and Spawn Redgate DevOps Advocate Grant Fritchey and Tech Lead Santiago discuss how to get more realistic testing into your database DevOps process. Watch Now
Jerod Johnson Data Administration Product Showcase DBAmp: Integrate Salesforce and SQL Server with Real-Time Bidirectional Connectivity DBAmp 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

Watch Now
Jerod Johnson Business Intelligence & Advanced Analytics Breakouts Salesforce & QuickBooks Integration to SQL Server via SSIS The 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 Watch Now
Jerod Johnson Business Intelligence & Advanced Analytics Breakouts Analyze Live Snowflake Data with SQL Server Analysis Services SQL 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. Watch Now
Anthony Nocentino

Argenis Fernandez

Data Administration Breakouts Protecting Data from Disasters and Ransomware Backups 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. Watch Now
Anthony Nocentino

Argenis Fernandez

Data Administration Breakouts How Storage Systems Work With SQL Server Ever 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. Watch Now
Robert Quimby Data Administration Product Showcase Power Up Copy Data Management for SQL Server with New Integrations Data is more valuble if it easily acceceable, this is why Pure makes integrations simple, and easy to automate. We will review best practices for managing data for Microsoft SQL Server, whether on-premises or using Pure Cloud Block Store. See how Pure integration improves backup and restore operations for SQL Server and how to leverage space-efficient snapshots for updating test/dev environments and other workflows. Learn tips and tricks on how to automate all of this with PowerShell.

Attend this session to learn:

· How Pure integrations simplify SQL operations

· Capabilities of Pure’s newest release of SQL Server Management Extension

· Different options for managing backup and restore of SQL Server databases

· Key differences between Crash and Application-consistent snapshots

· Tips and tricks to use PowerShell to script and automate common tasks

Watch Now
Mike Nelson Data Administration Product Showcase Automation with SQL, PowerShell, & Interactive Notebooks 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! Watch Now
Ben Kettner Industry Solution Product Showcase Doing IoT from Scratch – how we deliver successful IoT projects 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. Watch Now
Ben Kettner Architecture Breakouts An IoT application built on Azure Platform services, what to use and where to use it – an architectural guide When 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.

Watch Now

Speaker(s) Session Title Abstract Watch Now
Richard Conway Building an advanced practice using Azure Data Explorer In this talk Richard will talk through how to build a scalable, interactive data platform using Azure Data Explorer (ADX) and Kusto Query Language (KQL) based on work he’s been doing with one of his clients.

In this deep dive he’ll go through how to develop and productionise with examples using advanced concepts such as table permissioning, ingesting data, update policies, caching, row level security and other key enterprise features.

He’s the author of 30 lightning facts in 60 days which parade short blog posts on ADX which you can read more about here https://aizoo.info

And an admin command line tool dexcmd, which you can see here:

https://github.com/elastacloud/dexcmdline

Watch Now
Saveen Reddy Accelerating Enterprise Analytics Solutions with Azure Synapse Analytics This demo-heavy session will introduce the basic vision and concepts of Azure Synapse Analytics, will explore the platform approaches used to simplify the lives of data engineers, will explore the operation of key platform components, and provide a glimpse of the roadmap. Watch Now
Bryan Walsh & Doug Bernhardt Storage & Data Protection Innovations with Dell Technologies Enterprises large and small have made massive investments in applications and data running on Microsoft SQL. Futureproof your datacenter with revolutionary storage and data protection platforms designed from the ground up to deliver flexibility and scalability for all your applications and workloads types. Come learn more about how Dell EMC PowerStore and PowerProtect can integrate into a modern Microsoft data platform and enable innovation and modernization across the enterprise.

#infrastructure #dellemc #tpcleadership #sqlserver2019 #containerization #storagesolutions #thoughtleadership #innovation #dataprotection #datasecurity #hybridcloud

Watch Now
Bryan Walsh, Doug Bernhardt & Bart Driscoll Unleash the Power of SQL Server with Dell EMC PowerStore With the release of SQL 2019, Microsoft has shattered SQLs image as a simple relational database management system catapulting itself into the realm of AI/ML. Unleash the power of SQL with a revolutionary storage platform: Dell PowerStore, a modern automation platform delivering flexibility and scalability for all your applications and workloads types.

#infrastructure #dellemc #tpcleadership #sqlserver2019 #containerization #storagesolutions #thoughtleadership #innovation #dataprotection #datasecurity #hybridcloud

Watch Now
Stephen McMaster & Robert Sonders Considerations for designing a scalable and secure platform with SQL Server for today and tomorrow Unlocking the full potential of data is critical to success of any organization, and Microsoft SQL Server with Dell Technologies helps your organization deliver a fully supported stack on a platform of choice, providing intelligence over all of the data.. Microsoft SQL Server 2019 changed the rules of data gravity by taking data virtualization to the next level. Along with containerization, this evolution has enabled organizations to take a more holistic approach to infrastructure data management as they continue with their SQL Server journey. Join us for a review of what Dell Technologies is doing to help modernize your SQL architecture for today and tomorrow.

#infrastructure #dellemc #tpcleadership #sqlserver2019 #containerization #storagesolutions #thoughtleadership #innovation #dataprotection #datasecurity #hybridcloud

Watch Now
Udgith Mankad, Shashi Chidambara & Vikram Belapurkar Enterprise Storage Solutions for Microsoft SQL Server The bulk of the world’s largest enterprise Microsoft SQL Server environments rely on Dell EMC enterprise storage solutions. PowerMax is used in all 10 of the top US based banks, all 10 of the top healthcare companies worldwide, and 95% of the Fortune 100. Join us for a combined session highlighting the amazing performance, simplicity, availability, and advanced data services of Dell EMC PowerMax and Dell EMC PowerFlex.

#infrastructure #dellemc #tpcleadership #sqlserver2019 #containerization #storagesolutions #thoughtleadership #innovation #dataprotection #datasecurity #hybridcloud

Watch Now
Doug Bernhardt SQL Server storage considerations for Linux, containers, and Kubernetes environments It’s no longer news that SQL Server runs on Linux and containers and chances are you’re going to have to deploy and manage these environments sooner or later. When you do, you’re going to need to get the storage layer right for best performance and scale. Come get an inside look at how you provision and manage storage in these environments. You may want to make the leap sooner than you think!

#infrastructure #dellemc #tpcleadership #sqlserver2019 #containerization #storagesolutions #thoughtleadership #innovation #dataprotection #datasecurity #hybridcloud

Watch Now
Grant Fritchey & Stuart Ainsworth Challenges To Implementing Database DevOps Getting going in DevOps can be difficult at best of times. Throw in the need to manage data on top of that and the challenges grow. Using a case study, this session will provide you with tips and hints at how best to deal with your own database DevOps implementation. Whether your team is deploying locally to on-premises databases, or implementing cloud-based databases and DevOps technologies, the knowledge you gain from this session will help you deal with data in your DevOps. Watch Now
Ken Komazawa Fast Track AI/ML from Pilot to Production with Red Hat The potential market value of AI/ML is limitless. All enterprises are investigating in this domain, but the ideal platform is difficult to be maintained. Red Hat offers the enterprise Kubernetes services, OpenShift, with AI/ML ecosystem. This session explains how to solve the current AI/ML issues with Red Hat and partner solutions. Agenda: – The potential of AI/ML – The challenges of AI/ML – Why containers and Kubernetes for AI/ML? – Why Red Hat? – Q&A Watch Now
Adam Goossens Hello, world: what’s new in Red Hat Enterprise Linux 8.3 Red Hat Enterprise Linux is the leading Enterprise Linux Operating System, and with RHEL 8.3 it keeps getting better. In this session you’ll be taken on a tour of what’s new in RHEL 8.3, take a tour of the web console, and see how easy it is to get started with containers using tools in RHEL8. Agenda: – What’s new in RHEL 8.3? – Demo: Simplifying system management with the web console – Demo: Containerising an application with Buildah – Q&A

#redhat #rhel

Watch Now
Sukanta Basak & Bhargav Meka Red Hat OpenShift – Data Services Platform at Scale Red Hat and Microsoft has joined hands to deliver a Consistent Data Services Platform with Microsoft Big Data Clusters now available to run on Red Hat OpenShift, enterprise organizations can more securely deploy and manage a fully supported data analytics solution on the industry leading containers and Kubernetes platform. With integrated DevOps capabilities, OpenShift also allows extending DevOps to the entire Data Analytics & ML lifecycle, and enables collaboration across teams. The end result is the agility, scalability, flexibility, cross-cloud portability and security needed to roll out successful analytics/ML powered intelligent applications across hybrid and multi-cloud environments. In this session, learn how Red Hat OpenShift provides all of the components needed to run Kubernetes in production, including the underlying Linux platform, integrated networking, storage, monitoring, logging, installation, and upgrades. Red Hat OpenShift helps organizations transition to containers and Kubernetes—and realize the full potential of a hybrid cloud strategy. Watch Now
Rahul Vijayan & Sukanta Basak An Intelligent Operating systems for your data platform Microsoft and Red Hat have partnered to offer Microsoft SQL Server on Red Hat Enterprise Linux, an industry-leading Linux platform. In session learn how this combination extends the enterprise database and analytics capabilities of SQL Server. Session Agenda: –

Why Red Hat Enterprise Linux for MS SQL

Predictive Analytics with Red Hat Insights

What’s new in RHEL 8.3 – preview

Automating MS SQL server deployment with Ansible – Demonstration

Predictive analytics on MS SQL – Demonstration

#RHEL, #Hybrid Cloud, #Linux

Watch Now
Sanjeev Jagtap Inside OCR and Form Recognizer Learn about Microsoft Cognitive Services capabilities in Optical Character Recognition (OCR) and Document AI with the Form Recognizer product. Watch Now
Varsha Parthasarathy Inside Computer Vision Providing insights on the capabilities of the Computer Vision API in Azure Cognitive Services

#Computer-Vision #Azure-Machine-Learning #Artificial-Intelligence #Azure-Cognitive-Services

Watch Now
Amit Bahree Inside Reinforcement Learning – how RL is powering Decision AI and the next set of Cognitive Services Understand what Reinforcement Learning (RL) is and how is RL helping and power the next set of Cognitive Services such as Personalizer in Azure AI. These services are helping enterprises build applications for the changing world.

#AI, #AzureAI, #RL, #ReinforcementLearning, #CognitiveServices

Watch Now
Parashar Shah Inside Text Analytics, an Azure Cognitive service In this session, you will learn about various capabilities of Text Analytics (TA), an Azure Cognitive services to gather insights from unorganized and unstructured text that comes from online sources such as emails, blog posts, support tickets, web chats, social media channels, forums and comments. During the session you learn about the following capabilities of TA:

1. Language detection

2. Sentiment analysis

3. Opinion mining

4. Key phrase extraction

5. Named entity recognition

6. PII and redaction

7. TA for health

You will learn how to use TA’s pre-built models and what’s new in TA. You will also see some cool demos & reference architectures on how to use Text Analytics in your business.

Watch Now
Oliver Scholz Inside Azure Speech Services Quickly add speech capabilities to your solutions or experiences with no-code tools. In this session, we will cover how you can accelerate your development process with ready-to-go samples and a Speech services command line tool (SPX), customize solutions for your use case (Speech Studio), and benefit from flexibility in the hosting model from on-prem to the cloud.

#speech-to-text #speech-recognition #speech #speech-synthesis #text-to-speech #speaker-recognition #speaker-identification #speaker-verification #keyword-recognition

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

#Azure AI #CognitiveServices #machineLearning

Watch Now
Siva Harinath & Philip Seamark Designing for high performance in Power BI It’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. Watch Now
Sandy Winarko Blast to The Future: Accelerating Legacy SSIS Migrations into Azure Data Factory This session focuses on the new features to unblock/accelerate cloud migration of legacy SSIS with Azure Data Factory (ADF). We will first show you how to provision Azure-SSIS Integration Runtime (SSIS IR) – dedicated ADF servers for running SSIS – and extend it with custom/Open Source/3rd party components via standard/express custom setups. We will next show you how to enable the following scenarios: assessing SSIS packages for cloud compatibility and testing their executions in ADF from SSDT, accessing data on premises by joining SSIS IR to a VNet or using Self-Hosted IR as a proxy for SSIS IR, accessing Azure SQL DB/Managed Instance with OLEDB connectors that are configured for Azure Active Directory authentication with ADF managed identity, running SSIS packages stored in MSDB/SSISDB/file system/Azure Files/SSIS IR package stores or embedded in ADF JSON payload as first-class activities in ADF pipelines, scheduling SSIS jobs in ADF from SQL Server Agent/3rd party orchestrators that invoke Azure-enabled dtexec.exe, monitoring and alerting on SSIS IR operations and SSIS package executions using Azure Monitor, etc. We will finally show you the complete SSIS Migration Playbook to perform package assessments and package/job migrations using SSDT, Data Migration Assistant, Database Migration Service, dtutil.exe, scripts, etc. Watch Now
Sudhir Rawat Building Enterprise grade bot in no time In todays world every body need information on finger tips. It reduced peoples productivity if they have to spent hours and hours to find right information. Also finding right resources within organization is a big pain. Microsoft AI services can help but how about an interface to share this information. Microsoft bot can help here but as an AI developer or programmer how can I quickly create a enterprise grade bot in no time? How can we provide tools for business users or non developers to create a bot for their departments or team. This session will show case various ref architecture and tool to build enterprise grade bot in no time.

#AI #Code #Developer #Architect #bot #knowlwdgeMining

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

You will learn:

* The role of composite models in self-service reporting models

* How this will help you create Enterprise Semantic Models

* How these changes will impact you and your business

#PowerBI

Watch Now
Vijay Gopalakrishnan Big data analytics with Power BI and Azure Synapse Analytics This session will discuss the modern data warehouse stack focusing on Azure Synapse Analytics and Power BI for semantic modeling and data visualization. Learn how to unlock petabyte-scale datasets for interactive analysis. Use the Power BI Performance Accelerator for Synapse Analytics as a self-learning, self-optimizing system which automatically creates and manages materialized views in Synapse based on Power BI usage and query patterns. Watch Now
Andy Leonard Continuous Integration for SSIS with Azure DevOps Data Integration Lifecycle Management – or DILM – is challenging regardless of your chosen data integration platform. The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps – from initial development, through testing, to production.

#AzureDevOps #AzureDataFactory #ADF #SSIS

Watch Now
Dmitri Korotkevitch Architecture and Maintenance of VLDBs (Part 1) The modern Data Management systems deal with enormous amount of information. The business and compliance requirements force them to collect and process large amount of data and retain them for prolonged amount of time. As result, the size of the databases grows exponentially year after year, which leads to database administration and performance challenges, and increases hardware cost. This, 2-part session, discusses various aspects of architecture, implementation and maintenance of Very Large SQL Server Databases (VLDB) working under mixed (OLTP + DW/Reporting) workload. It will:

Provide an overview of three different technologies supported by SQL Server – row-based, column-based and In-Memory OLTP and discuss their benefits, downsides and the best use-cases

Show how to design the systems in the way, that would benefit from all those technologies

Discuss typical challenges related to VLDB maintenance, such as how to reduce database backup size and hardware cost, improve RTO, maintain indexes, among with several other topics.

Watch Now
Dmitri Korotkevitch Architecture and Maintenance of VLDBs (Part 2) The modern Data Management systems deal with enormous amount of information. The business and compliance requirements force them to collect and process large amount of data and retain them for prolonged amount of time. As result, the size of the databases grows exponentially year after year, which leads to database administration and performance challenges, and increases hardware cost. This, 2-part session, discusses various aspects of architecture, implementation and maintenance of Very Large SQL Server Databases (VLDB) working under mixed (OLTP + DW/Reporting) workload. It will:

Provide an overview of three different technologies supported by SQL Server – row-based, column-based and In-Memory OLTP and discuss their benefits, downsides and the best use-cases

Show how to design the systems in the way, that would benefit from all those technologies

Discuss typical challenges related to VLDB maintenance, such as how to reduce database backup size and hardware cost, improve RTO, maintain indexes, among with several other topics.

Watch Now
Priya Sathy Building systems of insights for enterprise scale with Power BI and Azure Bringing business intelligence to thousands of users in the enterprise requires scaling for the largest datasets in the organization without compromising performance or security. Join us to learn about how Power BI deeply integrates with Azure Synapse Analytics and how you can easily leverage your investments in Azure to bring insights to those who need it the most.

#PowerBI

Watch Now
Arun Ulagaratchagan & Amir Netz Microsoft Power BI: Business Intelligence Strategy, Vision, and Roadmap Update Our main goal for Power BI is to help our customers drive a data culture – helping everyone make better decisions based on data. Join Microsoft’s Business Intelligence leadership team to learn about our strategy, experience the newest capabilities available in Power BI, and see what is coming next.

#PowerBI

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

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

#MachineLearning #AzureSynapse #AzureDataFactory #BigData #Analytics

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

#HDInsight #BigData #Spark #Analytics

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

#AzureDatabricks #Spark #BigData #Analytics

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

#SQLSecurity #AzureSQL

Watch Now
Ajay Jagannathan Azure SQL: What to use when and product updates Come learn about the latest capabilities in the Azure SQL family (VM, SQL Managed Instance, SQL Database) in the past year, along with the latest “game changers” that Azure SQL brings to the table for organizations, including hyperscale, serverless, intelligence, and more.

#AzureSQL

Watch Now
Raj Pochiraju, Balmukund Lakhani & Ajay Jagannathan App Modernization and Migration from End to end, using data migration tools and Azure SQL In this session, you’ll learn about an end-to-end scenario that takes customers through the application and database migration process.

This demo heavy session will help you understand the Microsoft recommendations, tools, & services that help you migrating your .NET application and databases to Azure.

#AzureSQL #DMS #SQLMigration

Watch Now
Rajesh Setlem & Mohammed Kabiruddin Understanding your SQL Server readiness to migrate databases to Azure SQL using database assessment and migration tools In this session we will walk you through database assessment and migration tools that will assist in seamlessly migrating your SQL Server databases to Azure SQL. The session will guide you through migration process on how to determine readiness of your SQL Server instances, identify a recommended target, and complete the migration to Azure SQL.

#AzureSQL

Watch Now
Amit Khandelwal SQL containers are ready, are you? – For DBA and Developers In this session, learn how as a Data Engineer/DBA or a developer can you take your faviorite SQL Server to the container world. In this session we will also show you how easy it is for you to implement SQL Server in containers and get started with it. We will talk about new features available, how you can implement the containers in a secure way for production environments, customize it as per your requirement, we will also talk about the scenarios that best suit for SQL containers.

#containers #sqlcontainers

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

#sqlserver

Watch Now
Louis Imershein Securing SQL Server on Linux Securing database workloads involves more than just configuring the database and a firewall, the operating system security is deeply involved. Linux has built-in security features that can be leveraged by SQL Server database admins to protect the entire environment. These include features around access control, advanced vulnerability analysis and patching, non-root container support, identity and key management, as well as cryptography and encryption. Most DBAs don’t realize that Microsoft has built SQL Server on Linux to leverage all of these features. In this talk, we’ll dive deeper into the interaction between SQL Server security and the security features of Linux and show you how to leverage Linux security features to architect hardened database environments. We also take a look at some specific live demos that show SQL Server interacting with these features. Watch Now
Satya Ramesh Understanding NULLs in SQL Server SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this session, we will try to go through different test cases to understand NULLs properly.

#3VL #NULL #SQL #SQLServer #TSQL

Watch Now
Reza Rad Stop looking for job, let the job finds you Come to this session to learn tips and tricks from Reza himself, things that he learned through his professional career. Tips and tricks that help you to find your dream job. This is not a technical session, it is all about professional development and soft skills.

#ProfessionalDevelopment, #SoftSkills, #JobHunting, #CareerSuccess

Watch Now
Bob Pusateri Minimizing User Impact with Advanced Restore Methods We all know that backups are only half the battle – restores are what really matter when disaster strikes. Standard restores, while effective, may require additional downtime and further affect the business. This session will demonstrate three advanced restore methods you should know: point-in-time restores, piecemeal restores, and page restores, and will discuss when each method is appropriate. Attend this session to learn how to be a better DBA by minimizing downtime and user impact after disaster has struck! Watch Now
Kevin Kline Query Tuning Internals for the Advanced SQL Developer Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans and that SQL Server uses a cost-based optimizer to construct query execution plans. But how does does the optimizer decide the cost of a given operator over another equally valid operator, say between a nested loop join and a merge join? This session will teach you advanced techniques using undocumented trace flags to deeply explore the query optimization process. These choices can have a dramatic impact on performance, so we will pay special attention to the algebrizer, including associative, commutative, and transitive transformations. Together, we will Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer. We will examine a variety of everyday queries whose performance can be greatly improved by applying a deeper understanding of these internal behaviors. Lots of examples and demos!

#optimizer #algebrizer #parsing #binding #JoinOrder #MemoStructure #ParseTree

Watch Now
Sam Nasr Storing and Searching Files in SQL Server FileTables FileTables is a SQL Server features that allows easy storage and access to documents dynamically. After some initial setup, users can simply drag files into a folder and then be able to access their meta-data and contents through SQL Server, seamlessly. Due to the way FileTable uses the FileStream feature, it stores files on the file system but maintains the metadata in the database. This allows full control over the file while not bloating the database.

Tags: #FileTables, #Search

Watch Now
Sebastiano Galazzo Machine Learning – Best Practices and Vulnerabilities Artificial Intelligence and Machine Learning are a must nowdays.

For projects carrying a simple or well-known problem we can find a lot of ready-made solutions, but the game changes when facing with specific custom problems.

The first part of this session is a deep down on techiniques approaches and best practices in configuring ML algorithms but much more, do we really need it always?

The second part will cover vulnerabilities of ML, discovering how easy could be to fool and to hack a neural network by some techniques (Like pixel attack) and their implication in (our) security.

A demostration will focus on a case of e-commerce using cloud ML (Cognitive) services, breaking them then possible solutions and workarounds.

#AI #MachineLearning

Watch Now
Neil Hambly Data Science – Feature Engineering Data is the life (blood) of Analytics. Without it we have nothing. In this session we will focus on a core aspect of the TDSP “Feature engineering”. Feature Engineering involves aggregation and transformation of data variables to create features which are used in the analysis. We need to understand how features relate to each other and then select an optimum algorithms for these features. Feature Selection is where we define a subset of features to reduce the dimensionality of the training (model) and improve performance & costs of the ML Algorithms. One way we can understand these features better is to perform a PCA (Principal Component Analysis). For this important step using an example, we step though the process in a Jupyter (python) notebook to identify the features of a dataset which conveys important information about the structure of the dataset. Watch Now
Sray Agarwal How to Remove Bias and Make Machine Learning Models Fair & Discrimination-Free at the Example of Credit Risk Data There have been multiple instances when a machine learning model was found to discriminate against a particular section of society, be it rejecting female candidates during hiring, systemically disapproving loans to working women, or having a high rejection rate for darker color candidates. Recently, it was found that facial recognition algorithms that are available as open-source have lower accuracy on female faces with darker skin color than vice versa. In another instance, research by CMU showed how a Google ad showed an ad for high-income jobs to men more often than women. Using credit risk data where we wanted to predict the probability of someone defaulting on a loan, we were able to shortlist features that were discriminatory in nature. Watch Now
Mike Nelson Cross-Platform Management and Fun with PowerShell, the WSL, and Windows Terminal! Let’s face it – Windows and Linux are becoming very comparable with cross-platform databases and the interoperability between them. It is becoming a time when data administrators must embrace both worlds and dive into understanding things they have not had to before. For instance, did you know that PowerShell is available for other platforms than just Windows? Did you also know that there is an exceptionally easy way to combine all of those platforms into a single pane of glass with Windows Terminal, and run them simultaneously with the Windows Susbsystem for Linux (WSL)? This session will unravel all of the mystery and complexity around how to effectively manage these environments using these tools and some tricks to help guide your way to becoming cross-platform gurus!

#WSL #management #PowerShell #Windows Terminal #Linux #Windows

Watch Now
Matt Gordon Crushing a Cloud Migration: Moving Mountains While Migrating Data Are you an architect or DBA who has been tasked with executing a cloud migration? Are you a consultant who is trying to wrestle with the scale and scope of a cloud migration for a client? While there are certainly technical issues to solve and tooling selections to understand and execute, what often gets lost in a migration are the political and organizational mountains that need to be moved for the project to be successful. Technical success will not happen with our organizational success – they work hand in hand to lead to a successful conclusion.

As we walk through this session we will discuss and demo the technologies and tools that are useful for a cloud migration – and we\’ll review some that are not useful and talk about why they should be avoided. We will also mix in discussions of successful migrations and how the team worked together to move those organizational and political mountains out of the way in order to execute a successful cloud migration to make clients, customers, and managers happy!

#Cloud #Migration #DBA #Architect #Azure #AWS

Watch Now
Grant Fritchey Learn How to Deploy Databases Using AWS DevOps Tools DevOps itself is all about a cultural change in how you manage your IT resources. However, the biggest challenge when implementing DevOps is learning all the necessary tooling in support of automation. This issue is even stronger when it comes to automating database deployments. This session will show you the tools and mechanisms needed to get your databases deploying through AWS. We’ll slowly add additional steps and tools to expand the complexity and functionality of the deployment process. Understanding how to build out the bare bones of an AWS deployment process will make it easier to expand your deployments into the complex undertakings that they will ultimately become. Watch Now
Paresh Motiwala How to Get and Nail Your Interviews Workforce reduction can strike anyone, anywhere and anytime.

Are you prepared for that moment?

Let’s look at some real life examples through this session that draws full rooms wherever I have presented it!

Also, do you feel you need to get out, try either a new company or a new role or even a new boss? Then, this very entertaining, informative and highly interactive session is perfect for you. I assure you that you’ll walk out of it totally reassured and enlightened.

You’ll learn techniques for finding new opportunities in a competitive job market. I’ll also share how to exploit the social media to your advantage. (They are not bad if used judiciously)

What can you do once you get that rare and elusive interview?

There are several things we need to take care of like, overall appearance, food habits, arrival, sitting posture, small talk or ice-breakers and humor.

Finally you will learn about the follow-up and importance of keeping a log.

#Networking #Interviewing #JobHunting

Watch Now
Andreas Erben Hackathons – unleashing hidden potential in organizations and empower individuals Hackathons are a hot topic to drive innovation. Organizations across the globe have discovered that it enables them to help their digital transformation endeavors through unleashing hidden potential within the organization or across an industry.

For individuals, hackathons can help to dive into a new subject matter, empowering to work on subjects they always wanted to work on, and in some cases hackathons have changed career paths.

This session will discuss topics around hackathons:

What different types of hackathons exist? What value do hackathons have for organizations and for participants? How does one best prepare for a hackathon?

Most importantly, hackathons are about culture and in some cases helping to change culture in a positive way. The best hackathons are inclusive and empower people to succeed.

Attendees will learn about the value of hackathons for organizations and individuals, and tips will be shared how to run or participate in a successful hackathon. This session is for everyone who cares about innovation, digital transformation, and how to disrupt and reinvent themselves.

Watch Now
Steve Jones Blogging for the Tech Professional When a company posts a job opening, they are often inundated with dozens, if not hundreds, of applicants. How do they decide which ones are worth pursuing with an interview? Standing out from other candidates is important to ensure you receive the consideration that you deserve. Building a blog and including those links in your CV can help. Come learn how to build a blog, choose topics, and share your knowledge in a way that boosts your career.

#blogging #career #prodev

Watch Now
Armando Lacerda Stretched Databases From Zero To Hero This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

#Azure #AzureSQLDB #hybrid #cloud #database #mvpbuzz

Watch Now
Jorge Maia IoT Edge – Overview And Case Study For Smart Buildings Focused On Data This session is a merge of some clients’ use cases in the last five years on the smart buildings, facilities, and office automation projects that CrazyTechLabs be leading inside them.

Many examples of IoT presents a single sensor or a couple of them and a chart with their data. This session will cover how IoT can lead digital transformation in several buildings and present all Azure Environment that can be used, featuring Azure IoT Edge, Time Series Insights, and Azure Digital Twins to reduce energy waste, count people in rooms, and enhancing the user experience on the buildings.

The main idea behind the scenes on almost all of them on this kind of project was automation connected with authorization systems, to track the energy utilization by floors and sectors, based on occupancy and measurements. All data acquired must be stored, and after some months, the data extracted from the application promotes insights about rooms, illumination of individual suites, and common halls. It can turn HVAC, lighting, and access control systems automation with intelligence and control based on predictions and real-time data.

#IoT #SmartBuildings #SmartOffices #InternetOfThings

Watch Now
Jose Manuel Jurado & Roberto Cavalcanti Azure SQL Database – Troubleshooting real world scenarios with Microsoft Support Engineers In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos

#AzureSQL #QDS #Monitoring #Improving

Watch Now
Kevin Chant & Sander Stad Implementing SQL Server DevOps Using Azure DevOps Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.

This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.

We will discuss:

the challenges of implementing DevOps

setting up a database solution project

getting started with source control

testing your database releases using tSQLt

setting up your Azure Devops pipelines

As part of the session we will cover the default services you get with Azure DevOps including:

Azure Repos

Azure Boards

Azure Pipelines

Azure Test Plans

Azure Artifacts

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level. In addition, some ideas to get you developers and operations team to work together in a more DevOps related way.

If you want to see a session about using Azure DevOps with SQL Server, co-presented by a Microsoft MVP and somebody who is Microsoft certified for both, this is the session for you.

#sqlserver #AzureDevOps

Watch Now
Kevin Feasel Optimizing Backup Performance Using Data Science Techniques One of the most important tasks for a database administrator is taking (and testing!) backups. As databases get larger and larger, the amount of time it takes to perform a backup can grow as well, to the point where your backups take longer than your available backup window. There are several settings we can use to optimize backup performance, such as buffer counts, maximum transfer size, and the number of files, but trying every combination of settings on a single production-sized database could take weeks or even months. In this talk, we will apply data science techniques to the problem of backup settings optimization and look at different models for approaching the problem and analyzing data Some statistics background would be helpful, but is not required; the big requirement is a desire to speed up backups.

#SQLServer #Backups #datascience

Watch Now
Markus Ehrenmueller-Jensen A Game Of Hierarchies: Advanced Graph Algorithms In T-SQL Even when there is a big need from a business perspective, the solutions in relational databases are not straightforward. We will use this 60min to walk through solutions for typical questions we can ask a graph: centrality, PageRank, transitive closure, and shortest path.

Join this session for a journey through best practices to transform your hierarchies and graphs into useful information. We will have fun playing around with a sample database based on G. R. R. Martins famous Game of Thrones.

#TSQL #SQL #SQLServer #GraphDB #Graph #Hierarchy #AGameOfThrones #AGameOfHiearchies

Watch Now
Martin Catherall T-SQL Window Functions Window Functions first emerged with the 2005 release and were enhanced in 2012.

They provide a window over the result set and the ability to access data other than the current row.

This means that somethings that may – at first – seem like they need row-by-row processing can be done in one single set-based operation.

The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis.

Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient and cleaner queries.

Watch Now
Parikshit Savjani & Sunil Agarwal Modernize your data on Azure Database for Postgres and MySQL Flexible Server Are you looking to migrate it to the cloud, gain operational efficiency, and yet more importantly, not give up control of your database? Look no further. In this session you will learn how the new Flexible Server for Azure Postgres or Azure MySQL gives you full control for choosing your configuration, optimize cost, manage automatic maintenance, with flexible high availability options for your databases. For each of these capabilities, we will cover the ‘why’ and how using with simple demos to make your learning real. Watch Now
Paul Ou Yang SQL Code Testing Pipeline Imagine you write SQL code that must be compatible with the 5 latest versions of SQL Server: 2012, 2014, 2016, 2017, and 2019. Manually testing your SQL code in each version is going to be time consuming and perhaps neglected. This is where automation comes in. Using ARM templates, Azure DevOps, Pester and PowerShell, test environments can be easily created and destroyed when new versions are released. This session will help you automate the testing and ensure that your SQL code will run efficiently in any version. Demos planned include: – Using ARM templates to create multiple SQL VMs – Working with PowerShell to deploy SQL scripts – Testing SQL execution with Pester – Orchestrating the tasks with Azure DevOps pipelines

#DevOps #PowerShell #Pester #SQL #Azure

Watch Now
Niels Berglund Set Your SQL Server Data Free With The Use Of Apache Kafka In this session we look at how we can stream data from SQL Server to the de facto standard for streaming: Apache Kafka.

We look at tools like Kafka Connect, and external languages, and after the session we should have a good understanding in various ways we can “set the data free”.

#sqlserver #apachekafka #streaming

Watch Now
Pedro Lopes & Joe Sack Azure SQL: Getting Started With An Intelligent Database Azure SQL encompasses Azure SQL Database, Azure SQL Managed Instance, and SQL Server.

As part of the Intelligent Query Processing family, the latest SQL Server 2019 and Azure SQL Database introduce ground-breaking enhancements.

These enhancements make up the latest in Microsofts mission to improve critical parallel workloads when running at scale while remaining adaptive to the ever-changing landscape of data.

Join us to know more about the Intelligent Database world that’s available to you today, and to know more about the journey onwards.

Watch Now
Rainer Stropek Privacy In The Public Cloud – Azure SQL Private Endpoints Azure SQL Database has been designed so that it can run connected to the public internet. It has proper authentication and encryption built-in. However, administrators are humans and humans sometimes make mistakes. So it cannot harm to add another layer of security and limit access to cloud databases using network security mechanisms. Recently, Microsoft has been adding support for Azure Private Endpoints to more and more PaaS offerings including Azure SQL DB. In this session, long-time Azure MVP and RD Rainer Stropek will demonstrate how to use Private Endpoints to limit access to databases on a network level. He will show how you can connect your databases to Azure Virtual Networks and securely access them from applications running in the cloud and from on-premise systems using Azure VPN Gateways.

#Azure #Security #Network

Watch Now
Radu Vunvulea The Monster Under The Bed – Overengineering The cloud Nowdays, every new project that we start is around microservices. You cannot build anymore a simple solution that goes in production in 2 week time. Many times we grow the project complexity because of the current IT trends without thinking about what we need. The focus of the session is around microservices and what is the impact of it during development, automation and operation phase. The purpose is to identify the balance between the size, number and complexity of the services taking into account the delivery time and budget, especially during the first iterations. Watch Now
Rob Sewell Notebooks, PowerShell And Excel Automation Everyone loves Excel. A common request that I hear is can you put that into Excel for me, please. I love automation and so have combined two of my favourite tools PowerShell and Notebooks. Using Jupyter Notebooks to accomplish regular tasks and run-books has become common over the past year. A particular use-case that my clients have found very useful is to quickly create Excel sheets of information using Notebooks, PowerShell, and the ImportExcel module. Let me share my experience with you and show you how to create your own Notebooks for your users and the tactics I have learned to enable users to self-service and create their own Excel Workbooks.

#Automation #Excel #PowerShell #SQL Server #dbatools

Watch Now
Ronen Ariely SQL Internals – Physical Table Structure Under The Hood, And Implementation On Real Case Scenarios Understanding what we have under the hood is not only done for the sake of learning theory, but it directly impacts your daily work, and it can help us to improve performance and reduce resources dramatically.

During this session, we will go over the structure of the tables behind the scenes. I will show the changes in the table structure behind the scenes, related to actions which we execute on the table. Using this information, I will demonstrate several real case scenarios and the dramatic impact of understanding the internals in choosing our solution.

Is the order of the columns in the Create Table statement important? Can a specific order of columns affect performance or lead to an error in the future use of the table? Is dropping a column that is no longer needed is the right solution? Questions like these are very common in forums, but usually do not get the right answers even from experts.

Watch Now
Steve Jones Adopting A DevOps Process For Your Database When your application developers want a fast moving, DevOps software development process, the database often becomes a hindrance. It doesn’t have to be. While database development can be challenging when the system needs to rapidly evolve, many best practice software development practices still apply. Come learn about the ways you can mitigate the challenges of performing database development in a DevOps environment.

#DevOps #CICD #ContinuousIntegration #Testing

Watch Now
Tom Martens DAX – Time Series Analysis, Sequences, And Some Other Fancy Stuff Here Time Series Analysis does not mean calculating the YTD value of a numeric value. This is about discovering the clients who have been buying 10 days in a row and how concepts of time series analysis can be used with DAX.

These are the requirements to have fun attending this session: a basic understanding of the Filter Context is required, this article has to be read at least once

https://mdxdax.blogspot.com/2011/03/logic-behind-magic-of-dax-cross-table.html and it’s also helpful to have a good understanding of extended tables.

#DAX #PowerBI

Watch Now
Tomaz Kastrun Applied Data Science With Azure DataBricks Azure Databricks is an Apache Spark based analytics service for big data and data analytics on top.In this session we will create Databricks scenarios for useful business scenarios.

Data engineers and business analysts (data scientists) can now work on RDD structured files using workbooks for collaborative projects, using ANSI SQL, R, Python or Scala, easily covering both analytical and machine learning solutions on one hand, and also giving the capabilities to use it as a datawarehouse.

#data #Analytics #Azure #Databricks #datascience

Watch Now
Uwe Ricken Advanced Insides Into System Versioned Temporal Tables SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

This session takes you behind the basics of Temporal Tables and answers – after a short introduction – the following questions:

– How to handle the change of NULL constraints?

– Can Temporal Tables be renamed and what happens to the System Versioned table?

– What will happen if you change meta data (data length, data type, …)?

– What happens if you drop a column or add another column to the Temporal Table?

– what about security for the system versioned table?

– what about calculated columns in the temporal table?

Watch Now
Warwick Rudd Azure Data Studio Above And Beyond The data platform environment is exploding so quickly and as a data platform professional how can you be productive and able to support your environments easily?

In this session Warwick will introduce you to Azure Data Studio and take you on a demo rich journey on how, when, where and why Azure Data Studio can make your life easier in supporting your ever expanding data estate.

If you have not heard of or seen Azure Data Studio before, Warwick will introduce the tool, it’s history and introduce you to its continual enhancements to assist you.

#AzureDataStudio #DataPlatform #Tooling #SQLServer #Learning

Watch Now
Hasan Savran What Do Graph Tables Bring To The Table There are many ways to represent data. Most of us stuck with Relational Database Data Models and we don’t feel comfortable when data gets represented in different ways.

Graph Processing Tables is yet another way to represent data, it can change the way you look at the data. Relational Databases don’t adapt well to changes. Adding a new domain or relation to your data model should not be that difficult. You want to create flexible data models that evolve with your business process.

Join me to learn how to create flexible data models with Graph Database tables.

#SQL Server, #Graph Tables

Watch Now
David Goad A Guide To Developing Your Ideal Internet Of Things (IoT) Architecture: Nine (9) Key Questions To Ask Yourself BEFORE Developing Your IoT Solution Unlike the Internet which has been around in some shape or form for almost 30 years now and has a relatively stable architecture based on a handful of well known and recognized industry standards, the IoT has really only been around for the last 5 or 10 years (depending on your definition of IoT) and has a quickly evolving landscape of vendors, protocols, standards, and technologies with perhaps hundreds of options and combinations available to the practitioner to use in terms of technical architecture. Come to this session to learn more about the key questions you need to ask yourself when designing your IoT architecture.

#architecture #iot

Watch Now
Damir Matesic

MS SQL New functions, Syntaxes, Tips & Tricks In this session we will see what bring us some newly introduced MS SQL functions and syntax’s like COMPRESS, STRING_SPLIT, STRING_AGG, DROP IF EXISTS (a.k.a. DIE), UTF8 Support and many more. How are they performing compared to some old solutions?

Accompanied with multiple examples, this session will show you many interesting topics.

Watch Now
Alexander Arvidsson Talking To Myself(?) – Lessons Learned From Presenting Online If you had asked me in March if it was possible to speak or conduct training – with high quality – via the internet I would have said sure, it’s doable, but it’s different and it’s going pale in comparison to an in-person delivery. I would avoid it.

Then the world went off the rails.

Suddenly everyone had to adapt to being in quarantine or lockdown and not going to any conferences or trainings for the foreseeable future. I was forced to figure out a way to conduct technical training using tools that I didn’t believe in, by to people that I couldn’t see – without it sucking.

I had to figure out how to position myself to be able to use my hands, how to seamlessly switch between PowerPoint and the Azure portal and how to gauge my students’ information retention – all in about a week. It turns out that there are a lot more hours in a week than the 40 most people are used to working.

This session walks through what I’ve learned from speaking and conducting training over the internet the last few months – both what works well and what … doesn’t.

#Training #Presenting #ProfessionalDevelopment

Watch Now
Sandip Pani Data Leakage- Most Ignored Problem In Machine learning When you share information while training model which you shouldn’t is referred as data leakage. Beginners to experts many do this mistake of sharing information while tracing model. Sometime it happens accidentally and sometimes users not even aware about his mistake.

In this session we will discuss what is data leakage?, how it impact my model and how will you detect it? and how to prevent data leakage? I will demonstrate with various examples.

Watch Now
Thomas Grohser Building High End SQL Server Infrastructure While the overall goal is to utilize cost effective commodity hardware for the majority of the database systems sometimes it is necessary to have an efficient high end server to get the job done.

This session explains how to scale servers to hundreds of cores, terabytes of RAM and petabytes of storage in an optimized way for SQL Server. We will cover edge technologies like NVDIMM for the tail of the log buffering and talk about CPU and IO affinity and NUMA and how to expand the concept it from memory to your disks and network.

The most amazing part of this presentation is that you will learn that these high end servers are no longer as expensive as they one were.

This is the session for you if you need (or just want to know) how to handle millions of transactions per second or multi petabyte tables.

#SQLInfrastructure #HighEndSQL #CostEffective

Watch Now
Tillmann Eitelberg Structuring The Data Lake The Data Lake, infinite storage space, infinite possibilities to collect and hoard data. But is that the goal? Especially in a data lake there are rules how to store data, developers have to deal with naming conventions, business rules and policies.

In this session we will show which different concepts exist for structuring a data lake. Which naming conventions have become established or should be avoided. The Azure Data Lake also offers some support on the infrastructure side in the form of policies that can help to build a clean data lake.

Watch Now
Sunil Agarwal & Arun Kumar Thiagarajan Best Practices For Migrating Your Workloads To Azure Database For PostgreSQL And Azure Database For MySQL For open source relational database workloads, customers are increasingly adopting Azure Database for MySQL and Azure Database for PostgreSQL to take advantage of a fully managed database service technical teams innovate faster. In this session, we will cover the best practices to migrate existing MySQL/PostgreSQL/Oracle workloads to Azure PaaS. We will also dive deeper into various migration tools available for offline (one-time migrations and online (ongoing replication) migrations with a live demo of a MySQL to Azure DB for MySQL online migration. Watch Now
Guy Glantser Analyzing Execution Plans Like A Pro The most powerful tool when tuning a query is the execution plan. In most cases, by analyzing the execution plan of a query, you can learn all you need to know about how the query processor has chosen to execute the query, what is causing the execution to take so long, and what you can do in order to make it run faster.

But there are common pitfalls that you should be aware of when analyzing an execution plan, such as the fact that the operator cost values are always estimated, or the true meaning of the cardinality numbers within some of the plan operators. These pitfalls can be very misleading, and they might lead you to spend your tuning effort in the wrong direction. By understanding these pitfalls and avoiding them, you can save a lot of time and effort. You’ll become a performance tuning hero by getting the slow queries to run faster faster.

#SQLServer, #ExecutionPlan, #Performance

Watch Now
Hamish Watson KQL Will Be The Next Query Language You Will Learn To Manage Azure SQL Databases Azure is the leading platform for many companies, and to manage your databases and other infrastructure you need to have insights into what is happening.

You need to be able to query the Azure platform, to not only understand your infrastructure but also to leverage monitoring and analytics to react to operational changes occurring in it.

This session will introduce you to the Kusto Query Language (KQL) which will allow you to query a variety of Azure resources. The session will also show how machine learning and time series analytics can help advance your insights into you Azure services.

We will also look at how we can export our results out to csv files and PowerBI for full-scale reporting of our Azure platform.

#Azure #Database #Cloud #DevOps

Watch Now
Greg Low Really Understanding Character Data Types In SQL Server If you still think that varchar(10) means up to 10 characters, or you don’t know what that N is in front of some strings, and why it matters, or if you don’t really know your collations from your code pages, this session is for you. Let Greg explain it to you. Watch Now
Edwin M Sarmiento Building A Custom SQL Server On Containers Image For Deployment You have been given new responsibilities to automate deployment, scaling and management of containerized applications not just SQL Server databases. And while Microsoft provided publicly available images for you to use, you want to create your own custom images to meet your corporate policy requirements.

In this session, learn how to build a custom SQL Server on Containers image solution that you can incorporate in your DepOps workflow. You will also learn how to leverage containers for faster SQL Server deployments – be it in development or production environments.

#SQLServer #Docker #Containers #Linux #DevOps #Tag6 etc..

Watch Now
Amol Bhatnagar Turbocharge Your MySQL Engine On Azure To Make It Fast, Resilient And Scalable Looking to unleash the full power of the cloud and build fast, resilient and internet scale applications with MySQL on Azure? Are you looking to extract more performance and scale out of your Azure Database for MySQL service? Join this action packed deep technical session to understand how do you measure and monitor the right metrics with Azure Database for MySQL service, configure your Azure DB for MySQL server for best performance and how to scale your application seamlessly from 0 to thousands of QPS without any application changes. Whether you are a DBA, developer or devops engineer, you’ll leave the session with a list of great tips and tricks for optimizing performance of your MySQL server without any application side changes. Watch Now
Damian Widera Quantum Computing Explained With Demos! This talk is inspired by the quantum revolution we will see in a moment.

I would like to introduce the topics:

– reminder why basic linear algebra (matrices and vectors) is important

– qbits, superposition, and quantum logic gates

– Show the simplest problem where a quantum computer outperforms classical methods

If time permits – quantum entanglement

I will do demos implemented in Q# with the Microsoft Quantum Development Kit.

I do not assume any special knowledge, but if you know basic linear algebra (matrices, vectors, matrix multiplication) than the topic will be more easily understand!

Watch Now
Leonard Lobel Building Event-Driven Microservices with the Azure Cosmos DB Change Feed The 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. Watch Now
Amit Banerjee SQL Server Licensing: Demystified Learn about the new licensing benefits that were introduced with Software Assurance and how it can help you drive lower TCO for SQL Server deployments. In this session you will also understand how you can derive additional benefits by leveraging Azure SQL as an extension of your existing datacenter using Azure Hybrid Benefit.

#AzureArc

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

#AzureSQL

Watch Now
Borko Novakovic & Srdan Bozovic Modernize your SQL applications with the recently enhanced version of Azure SQL Managed Instance Azure SQL Database Managed Instance offers the best combination of a fully managed cloud service in Azure and compatibility with SQL Server on-premises product. This makes it the recommended destination for SQL Server workloads migrating to Azure cloud.

If you think about digital transformation in Azure, start exploiting the increased productivity and cost savings that the managed instance can provide to you.

Managed Instance remains to be one of the strategic investments in Azure SQL product portfolio. Over the last year it has been greatly enhanced in terms of new programmability surface area and increased application compatibility, improved price-performance, networking security and compliance, and better migration and manageability experience.

Come and hear about the best practices of migration to managed instance, the latest product enhancements, and get a sneak peek at the future product roadmap.

#AzureSQL

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

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

#Azure #AzureCosmosDB

Watch Now
Alain Dormehl & Mara Steiu 360-degree view of Azure SQL Monitoring Take a trip with the product group through all the monitoring options for Azure SQL. Learn more about some of the new upcoming features and capabilities in Azure to monitor Database workloads. You can come and see more on a new solution for gathering and ingesting telemetry, which allows you access to new telemetry for your database, with full granular control of the collection and ingesting of data. This session will help you understand all your options to adequately monitor your SQL workloads in Azure.

#AzureSQL

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

#AzureSQL

Watch Now
Rodrigo Souza HTAP Analytics with Azure Synapse Link for Azure Cosmos DB In this session, we will cover how you can build real time BI dashboards with deep granularity using Azure Synapse and Azure Cosmos DB. Learn how to enable no-ETL analytical processing on real time operational data with no performance impact on mission critical operational workloads.

Azure Synapse Link for Azure Cosmos DB is Microsoft’s cloud-native implementation of hybrid transactional/analytical processing (HTAP).

#Azure #AzureCosmosDB

Watch Now
Sanjay Mishra The Future of Cloud Relational Databases Relational databases have been a key foundation for applications for over 40 years. How does the future look for relational databases, especially in the cloud? This session will also bust several myths that have come to surround relational databases in the last few years through demos.

#AzureSQL

Watch Now
Emily Lisa & Shreya Verma Azure SQL High Availability and Disaster Recovery If you’ve ever had to deploy an Availability Group, Failover Cluster Instance, or backups you’ll appreciate learning about the availability architectures and disaster recovery solutions that Azure SQL provides automatically when you deploy Azure SQL Database or Azure SQL Managed Instance. You’ll learn about the latest innovation in availability, including topics around Availability Zones and Monitoring. You’ll also learn about options, recommendations, and tutorials for recovering from a disruptive event that could cause data loss.

#AzureSQL

Watch Now
William Durkin Upgrading/Migrating a Microsoft Data Platform Environment: Experiences from the Field In this session we will go over some experiences, thoughts, and pitfalls around upgrading and migrating SQL Server solutions. The audience will hear how different approaches are necessary depending upon business needs and that the most obvious solution isn’t always the right one! Along the way, we will gain insight into the tooling and methods that can be used to help during the different phases of these projects. How to prepare, how to execute and how to complete a migration or upgrade. Attendees will leave the session with important information to help design and execute their future projects, including questions to ask and options to consider before embarking on the upgrade journey.

#Migration #Azure #SQLServer

Watch Now
Mohit Batra Building Streaming Pipeline With Azure Databricks Using Structured Streaming And Delta Lake Modern data pipelines not just work with batch processing of data, but it often includes streaming data that needs to be processed in real-time. However, many a times, requirements go much beyond that. The processed data may then be consumed by downstream batch, as well as another streaming pipelines. There are several challenges that you need to address here.

First, to use a common platform to build unified batch and streaming pipelines. Second, to store the processed data into a Data Lake, and still make sure that downstream systems can consume it reliably, without any consistency issues. And third, to have a unified environment for development and deployment. And this is what we are going to address here.

This session will take you through three components.

Structured Streaming stream processing component of Apache Spark to build reliable streaming pipelines

Delta Lake an open-source storage layer that brings ACID transactions and reliability to your data lakes.

And Azure Databricks a unified analytics platform that runs on Azure, handles the infrastructure, and provides a collaborative environment for doing development.

We will first talk about the end-to-end architecture. Then we will spend time to understand these three components, the challenges they are addressing, and see it in action in the demos. And finally, you will see demos on how they come together and make it extremely easy to build data pipelines for many common scenarios.

#Azure #Databricks #AzureDatabricks #Spark #Streaming #StructuredStreaming #DeltaLake #DataLake #DataPipeline

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

#AzureSQL

Watch Now
Vicky Harp & Ken Van Hyning State of the SQL Tools Learn about what’s new and what’s coming soon for SQL Server tools in this demo-heavy session from the SQL Server product team, highlighting Jupter notebooks, sql database projects, and more.

#AzureDataStudio #OSS

Watch Now
Erik Darling Defeating Parameter Sniffing With Dynamic SQL Parameter sniffing can be a huge performance problem, and fixing it can feel like an exercise in futility. If you’re ready to go beyond recompiles and unknowns and solve problems for real, come to this session. I’ll teach you techniques to fix parameter sniffing problems for good.

#SQLServer #Performance #Query #Index #Query-Plan #Tuning

Watch Now
Andreas Erben Cognition For Applications – Cognitive Services And Mixed Reality In Action Cognition is defined as acquiring knowledge and understanding through thought, experiences, and the senses. This summarizes very well what can be accomplished when using Microsoft Azure Cognitive Services and Mixed Reality capabilities together.

In this demo-driven session, the presenter uses those services together enabling advanced scenarios. Cognitive Services allow understanding the environment, combined with Mixed Reality services, this understanding maps to locations in the real world.

This allows to create completely new spatially aware experiences.

Example code and demos will show both decision makers and software developers of all types what is possible, and how to start implementing in their organizations.

Watch Now
Magnus Ahlkvist Statistics, An Unreliable Friend Statistics are essential for SQL Server’s optimizer to generate a good query execution plan. A common practice is to update the statistics regularly. Although recent version of SQL Server has improved automatic statistics update with a lower threshold before automatic update is performed the larger an index grows, it is still a common problem that the statistics are not accurate when that one important and time critical query needs to run.

In this demo-packed session, I will demonstrate how statistics are used by the Query Optimizer, introduce the Ascending Key problem and talk about how SQL Server 2016 offers a great improvement compared to previous versions of SQL Server. I will also show some examples of missing statistics problems that have NOT been addressed by Microsoft, and a few different ways to address them in your code.

#statistics #tsql #performancetuning #ascendingkeyproblem

Watch Now
Kevin Farlee New ways to keep your SQL databases on Azure VMs protected and available Keeping your SQL database available and protected is a critical mission of any DBA. In this session, we will discuss new ways and best practices for keeping your SQL Server databases available on Azure VMs.

#SQLHA

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

#AzureDataStudio #OSS

Watch Now
Erland Sommarskog Don’t Bite Off More than You Can Chew – Take it in Chunks Any SQL programmer with some experience knows that loops are bad and that you should work with all data at once in set-based statements. However, you may have experienced situations where this strategy did not work out well and you ran into problems like out-growing the transaction log or blocking other users. You can solve this by operating on the data in chunks. Implementing chunking is not that difficult, but there are still pitfalls you can run into. In this session, I will discuss in what situations you may want to use chunking. I will give some best practices for how to implement chunking for good performance and I will highlight some things you need keep in mind, for instance, recovering from interruptions. I will also look at how you can use chunking for error handling: You want process many rows and you want the good rows to succeed even if some rows yield errors – something you cannot do in a single set-based statement. Watch Now
Aditya Badramraju & Pam Lahoud SQL Server in Azure Virtual Machines Reimagined Most of the enterprise workloads would want both control and Manageability of their database solutions. For such scenarios, deploying SQL Server in VM is a best choice. By deploying SQL Server in Azure Virtual Machines customers can take advantage of many features around administration, high availability and performance. In this session we will look at different best practices, advantages we have when we deploy SQL Server on Azure Virtual Machines.

#AzureSQL #SQLonVM #SQLIAAS

Watch Now
Silvano Coriani Leverage Azure SQL Database for Hybrid Transactional and Analytical Processing (HTAP) In real world, applications can rarely be classified as “pure OLTP” or “pure OLAP”, but more often they will be present a mix of these two workloads. Learn how Azure SQL Database features and capabilities can nicely cover customer requirements and data processing scenarios.

#AzureSQL

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

#Azure #AzureCosmosDB

Watch Now
Manohar Punna Cloud Infrastructure as Code (IaC) using Terraform In recent years, the cloud has been adopted by most companies. It offers greater flexibility in terms of infrastructure and resource management at a greater scale. Although, if not noticed the prices of maintaining this infrastructure and resources will blow through the roof. DevOps and deployability of resources as needed have become even more critical with the cloud.

Infrastructure as code is a necessity than a luxury. Terraform offer great IaC solution across multiple cloud vendors. In this session, I will explain the importance of infrastructure as code for cloud resources and introduce how Terraform can be used for building your IaC solutions. I will dive deep into using Terraform for deploying cloud resources for an end-to-end application platform in Azure.

#IaC #Terraform

Watch Now
Vasiya Krishnan & Sourabh Agarwal Real-time data analysis using Azure SQL Edge Join us to learn how Azure SQL Edge provides the flexibility and capabilities to develop IoT/Edge solutions that leverages machine learning & real-time analytics to drive continuous optimization and efficiency.

#AzureSQLEdge #SQL #IoTSolutions #AzureSQL #SQLServer #Edge

Watch Now
Davide Mauri Create Secure API With .NET, Dapper And Azure SQL Creating backend REST API is a very common duty in today’s work. But what about creating an API that is also secure and only shows the authorized data to each user invoking it? Thanks to Azure SQL’s Row Level Security feature, it’s very easy to create an API, even on an existing data, without any change to the database schema, that is secure and fast. In this session we’ll see how we can create a full REST API in an hour, using Azure SQL, the micro-ORM Dapper and .NET Core.

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

#RLS #Security #REST #API #Dapper #.NETCore #microORM

Watch Now
Arnaud Comet Building a connected analytics hub with Azure Synapse Link In this session, we will cover how you can build real time BI dashboards with deep granularity using Azure Synapse and Azure Cosmos DB. Learn how to enable no-ETL analytical processing on real time operational data with no performance impact on mission critical operational workloads. Azure Synapse Link for Azure Cosmos DB is Microsoft’s cloud-native implementation of hybrid transactional/analytical processing (HTAP).

#Analytics #AzureSynapse #CosmosDB #BigData

Watch Now
Drew Skwiers-Koballa & Udeesha Gautam SQL Database Projects Azure Data Studio has recently added project functionality, supporting both compatibility with SQL Server Data Tools (SSDT) and new features. With the growth of cross platform environments and DevOps for databases, now is a great time to learn about database development in Azure Data Studio. We will dive into the SQL Database Projects extension for Azure Data Studio through an end to end example with Azure SQL Edge as well as a review of the overall functionality.

#AzureDataStudio, #AzureSQLEdge

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

#Azure #PostgreSQL #AzureDBPostgres

Watch Now
Anupama Natarajan Design Patterns for Machine Learning Projects Machine Learning (ML) Design Patterns are proven techniques to solve common ML problems. In this session you will learn the techniques of applying these design patterns to solve real world problems. You will learn each design pattern with a problem statement followed by the solution provided by the pattern. We will be mainly looking at design patterns relating to Supervised, Unsupervised and Semi-supervised Machine Learning and each Design Pattern will be explained through a real-world use case.

#MachineLearning #DesignPattern #AI #ML #bestpractices

Watch Now
Alex Yates & Sander Stad Solving the dev database problem with GitHub, Docker and dbaclone DevOps promotes self-service access to usable, production-like dev/test

environments – but so many data folks are encumbered with shared

development databases which are often inconsistent with production. It’s

difficult to isolate the development of different features, so they are

rolled together into big releases. It’s no wonder database deployments

are often expensive, complicated and risky.

What if it was possible for developers to provision themselves a

disposable, masked copy of last night’s production 64 TB database on

their regular workstation, with limited storage, in a matter of seconds?

What if it was as easy as “git clone f5”?

In this session attendees will learn to use GitHub, Docker, SSDT and

PsDatabaseClone to unshackle themselves from “Wild West” dev databases

and empower them to use modern branching techniques and Azure DevOps to

continuously deliver their updates to production.

The result? Empowered developers who can deliver value in smaller

batches, through significantly more regular and reliable deployments,

delivering value to users much more quickly.

Watch Now
Raj Pochiraju & Mukesh Kumar Database modernization best practices and lessons learned through customer engagements In this session you will learn the real-world ins and outs of how we successfully migrated customers to Azure data platform.

You will get a detailed view of Microsoft investments accelerating Azure SQL migrations, the migration lifecycle phases, and specific tools/ services help you in the migration journey.

You will listen to real world customer migration case studies, the specific migration strategies adopted and best practices implemented.

#AzureSQL #DMS #SQLMigration

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

#SQLServer #BigDataClusters #Kubernetes

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

#SQLServeronLinux

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

#SQLServer #BigDataClusters

Watch Now
Javier Villegas Monitoring And Troubleshooting SQL Server Environments Using Free Community Tools In this session we will see how to monitor and troubleshoot different SQL Server environments using free tools developed by community experts

We will cover First Responder Kit , Diagnostics Queries, BPCCheck, dbatools / dbachecks and more

Watch Now
Harsh Chawla DBA to Data engineer How transition from monolithic to Microservices applications brought this radical change

Evolution of Data engineering and data scientist roles

Transition from Data warehouse to Modern data warehouses

Transition from Data mining to Advanced data analytics

Real time and batch mode data processing

Lambda and Kappa Architecture

Anatomy of Modern data warehouse and Advanced data analytics solutions

Watch Now
Michelle Gutzait Hey! I really need to save on SQL Server license costs, would you help me consolidate? Abstract In this session, Michelle will talk about consolidation options for SQL Server environments, discuss license costs reduction, Cloud alternatives and provide examples from real customers.

Tags: #sqlserver #consolidation #azure #sqlserverconsolidation #sqlazuredatabase

Watch Now
Daron Yondem Cosmos DB: Jack of All Trades, Master of Many How would it look like if you were building a wishlist for an imaginary database; turnkey global distribution, 5 well-defined consistency levels, SLAs across 4 dimensions (High Availability, Performance Latency, Performance Throughput, and Data Consistency), Schema-agnostic automatic indexing, Key-Value, Tabular, Document, Graph, Relational Data Models, MongoDB, Gremlin, T-SQL API support… Did we go too far? Not really. So far we have just listed some of the features of CosmosDB. Come and join me to take a closer look and see if it is all blue skies, or maybe not? Watch Now
Tracy Boggiano Mental Health and Wellness in IT: Safeguarding our most precious resource One in four Americans suffers from a mental health challenge each year. In the tech community, this number rises to 42%. The stigma associated with discussions around mental health, as well as how it can negatively impact your work and home life, make people reluctant to discuss the topic. Now is the time to start discussing mental health in tech and how to take advantage of the opportunity to safeguard our most precious resource: people. We\’ll discuss how mental health affects job quality, including sharing examples from my professional life. We\’ll discuss the four primary workplace factors which play a pivotal role in mental health challenges in the tech community. I\’ll provide tips on what is best to say and not say to people you know whose lives are being affected by their mental health. Lastly, we\’ll cover how to make your workplace a safe place where mental health can be talked about and how to encourage your company to offer resources to help maintain everyone\’s mental health. Watch Now
John Morehouse Optimizing Query Performance In Azure SQL Database Many think that moving to the cloud will not only help brighten your teeth but also solve all of your bad coding practices that give you poorly performing queries. If it’s done correctly, implementing Azure SQL Database can help with one of those two and while it can mask things well, the best solution is to fix the bad code. In this hour-long session, we’ll examine several different methods that you can utilize to help fix bad performance starting with the underlying service tier. Next, we’ll investigate what options are available directly from the Azure portal to determine where the bottlenecks might reside along with possible ways to fix them. Lastly, we will interrogate which native SQL Server tools exist within Azure SQL Database that can really help solve any performance issues you might be having. You’ll leave this session with a solid understanding of how to trouble shoot performance issues in Azure SQL Database and what you might be able to do to help fix them.

#azuresql #azure #performancetuning #sql2019

Watch Now
Ginger Grant Machine Learning with Spark and Azure Synapse Azure Synapse Analytics contains a number of different features, and this session will focus on how to use the integrated Spark clusters to analyze data using Auto ML and other coding examples. See how you can use Azure Synapse to create data pipelines and do exploratory analysis without creating a SQL Pool. This session will provide real world examples showing you how you can use Azure Synapse to create solutions with your data and the demos will explain how to make it possible.

Tags: #AzureSynapse #ApacheSpark #MachineLearning

Watch Now
Marco Russo Inside The VertiPaq Engine The VertiPaq engine used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq. We will show common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model. Watch Now
Marsha Pierce Migrate Your Database Like A Rockstar We often have to migrate databases between servers. It could be for a SQL Upgrade or it could be for a Hardware Upgrade. When you move servers there are a ton of things that can cause your move to fail. Learn from someone who has moved 1000s of instances. I will show you how to move your databases to a new server with just a few minutes of downtime and how to reduce the risk of needing to rollback. We will account for everything except an IP change including replication and not having to reseed it. Watch Now
Julie Koesmarno & Alan Yu Azure Data Studio Notebooks Power Hour Join this session to learn more about Notebooks in Azure Data Studio. We’ll demo new features in notebooks in Azure Data Studio, through the different use case lenses. Learn how to author notebooks, convert + organize your scripts to more manageable and shareable notebooks, all the way to fun + productive tricks that you can try at home! DBAs, Data Engineers and all data professionals are welcomed.

#AzureDataStudio, #Notebook, #AzureSQL, #ClientTooling

Watch Now
John Q. Martin SQL Server And Network Security The network is often forgotten when securing SQL Server is completed. However, this is a primary attack vector which needs to be designed and configured properly to help add the layers of protection needed.

In this session we will explore the network architecture you should look to implement as well as how to leverage Operating System Firewalls as well as Azure Network security configurations. When combined this will add more depth to the defence of your SQL Server security and help you meet compliance and regulatory requirements.

#Security #SQLServer #Azure

Watch Now
Thomas Leblanc Building an Agile Data Warehouse The Data Vault method can be used in agile development. If you follow 2.0 structure the hubs, links and satellites only have inserts. The difficult or more time consuming part is the Information Mart. This is where views for reporting can be used for reporting or converted into tables. The view code can be used, with some date manipulation, to schedule updates for structured dimensional model tables. The dimensional Data Mart is what most reporting or visualization tools (Power BI or Tableau) are programmed optimally.

It still gives those power query writers (T-SQL experts) the ability to see the archival data in the Data Vault if they so desire. What really becomes apparent is the integration of new applications that replace the existing applications. Satellites are great at structuring the hard rules of the data to tables and relationships. Again, the Information Mart views or tables is where the soft rules will be applied to help reporting queries.

Watch Now
Eva Pardi & Alan Smith Reinforcement Learning in gaming Microsoft uses reinforcement learning in many ways to improve our products and services. AI and machine learning can help accelerate game development by providing more realistic worlds and challenges as well as support automation and live operations.

At Game Stack Live, Microsoft Research announced Project Paidia, a research effort aimed at exploring new opportunities created with AI based reinforcement learning in gaming. During this session, attendees will be able to get started with Reinforcement Learning for gaming with the use of Azure Machine Learning.

Tags: #AzureML #Microsoft #ReinforcementLearning #ProjectPaidia

Watch Now
Mihail Mateev Anomaly Detection, Powered By Azure AI And Digital Twins Detecting the Onset of System Failure using Anomaly Detection Techniques is one of the key demands in Industry 4.0. Nowadays implementation of this functionality is often related to two concepts: Digital Twins and Anomaly Detection with AI

Anomaly detection is the identification of rare items, events or observations which raise suspicions by differing significantly from the majority of the data. Typically, anomalous data can be connected to some kind of problem or rare event such as e.g. bank fraud, medical problems, structural defects, malfunctioning equipment etc.

Digital twins have been around for several decades, the rapid rise of the internet of things (IoT) is that they have become more widely considered as a tool of the future. Digital twins are getting attention because they also integrate things like artificial intelligence (AI) and machine learning (ML) to bring data, algorithms, and context together

In this presentation will be discussed various techniques that can be used to detect the onset of failure occurring in systems in the context of Microsoft Azure, using Azure Digital Twins Service and Azure Cognitive Service Anomaly Detector API.

Azure Digital Twins is a game-changer in the modern IoT and AI solutions. This a SaaS offering easy to build digital models of complex systems.

The Anomaly Detector API enables you to monitor and detect abnormalities in your time series data with machine learning. This feature adapts by automatically identifying and applying the best-fitting models to your data, regardless of industry, scenario, or data volume.

This talk is covering the whole content from Digital Twins and Anomaly Detection concepts via Azure based implementation demonstrating real use cases and demos.

#DigitalTwins #IoT #AI #AzureDigitalTwins #MicrosoftAzure #CognitiveServices #AnomalyDetector #Azure.

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

#Data Analytics #Big Data #Azure Data Lake #Spark #SQL Data Warehouse

Watch Now
Gary Pretty Developing sophisticated virtual assistants using the Microsoft Conversational AI Platform Today, organizations are responding to increased demand from customers and employees looking for information and support. In this session, you will see how you can build your own Conversational AI applications using the Microsoft AI Platform – using Bot Framework Composer to rapidly create sophisticated and personalized conversational experiences which can be surfaced wherever your end users are, including Teams, WebChat, Alexa and more!

#ConversationalAI #Azure #BotFramework #Microsoft

Watch Now
Alex Whittles Machine Learning In Power BI Two of the hottest topics in data are Machine Learning and Power BI, but how to the work together? In this session we’ll look at what ML tools and features are available in the Power BI world, and how you go about using these in your data and reports. This will include using both built in and 3rd party Power BI visuals, consuming Azure Cognitive Services, as well as the new ML features available in data flows.

#PowerBI #ML #AI #CognitiveServices

Watch Now
Monica Rathbun Mastering Tempdb Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you’ll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container. Watch Now
Krishna Doss Mohan Challenges to Overcome while Building Machine Translation Models for Indian Languages Microsoft Translator has shipped machine translation support for 10+ Indian languages. In this session, we will use Indian languages as example to cover why it’s important to build machine translation models for digitally low resourced languages and challenges you would face during data acquisition and building machine translation models. You will learn tips to overcome those challenges. We will demo how those machine translation models makes societal and business impact.

#MachineTranslation #Azure #CognitiveServices #IndianLanguages #AI #ML #DataEngineering

Watch Now
Neha Rajput Inside QnA Maker This session is to give an overview of Microsoft Cognitive Service: QnA Maker. You can create a conversational layer over your data with no/low code experience. QnA Maker can be used to create your own bot in minutes without writing a single line of code. It uses deep learnt models which understands the user query and returns the best possible answer for them. Watch Now
Miguel Martinez & Peter Myers Monitor Your Data in Real-time with Microsoft Power BI Why make decision based on data from yesterday when you can learn what is happening now? Wouldn’t it be better to look forward instead of the rear-view mirror? Learn about the real-time data visualization capabilities for datasets, reports, and dashboards

In this session you will learn:

How to create dashboards, reports, and visuals with data that’s always up to date.

Different options for real-time datasets: streaming, push, et.

How to monitor critical events with automatic page refres.

#real-time #dataviz #streaming

Watch Now
Sunitha Muthukrishna Build Modern Cloud Native Applications With Kubernetes And OSS Databases (MySQL & Postgres) With changing customer requirements, you need to think about modernizing your approach to application development to be cloud-ready. In this session, we will show you how to modernize your application with Azure Kubernetes Service (AKS) and MySQL on Azure. We will walk through on how to migrate an application that uses PostgreSQL or MySQL to Kubernetes using AKS and Azure Database for MySQL. In additional to the migration, you will also learn how to optimize AKS to work best with Postgres or MySQL on Azure and to simplify migration and operational efficiency resulting in increased scalability, improved performance, and reduced costs. Watch Now
Benjamin Kettner Cloud-Based ETL With Azure Data Factory And Azure Functions Today, many ETL workloads and Data Warehouses move to the cloud. But also the data sources and requirements have changed. How can you process streaming data for a cloud-bourne DWH? How can you pull data from REST APIs in batches? What tools do you have for processing data in the cloud? In my session I will discuss scenarios that can be solved using the Azure Data Factory, scenarios that are beyond ADF capabilities and how Azure Functiosn can be employed in both scenarios. I will show real-life examples utilizing Storage queues for asynchronous processing, durable entities for streaming data and orchestrator functions.

#ETL, #Azure, #ADF, #AzureFunctions, #ModernDWH, #DWH, #Cloud

Watch Now
Vin Yu What is Azure Arc Enabled Managed Instance? Have you checked out Azure Arc yet? Azure Arc enabled Managed Instance enables you to run SQL Server compatible workloads with the added management capabilities anywhere. In this session, we’ll bring you quickly up to speed on Azure Arc enabled Managed Instance, discuss use cases, and demo this product. We’ll also cover how you can get easily get started with this product.

#AzureArc

Watch Now
Prashant G Bhoyar Applied AI Practical Use Case : Content Classification of Network drives Most of the organizations have humongous file shares/network drives where the contents are not organized and labeled as per the organization’s liking. This poses a high problem when organizations want to move the legacy contents in the public cloud. In this demo-driven talk, we will cover the case study of a recent file share migration project we did where we used Microsoft Cognitive Services (Applied AI) for intelligent content classification. Watch Now
Reza Rad Power BI for Ticketing and Subscription: A design pattern review This session explains one of the common design patterns for Power BI implementation. A design pattern that can be used for subscription or ticket systems. Through this session you will learn the structure of the data model, the data preparation steps to get there, DAX expressions to support analytics.

This is not a beginner-level session, you should have some understanding of Power BI, Power Query, and DAX already.

Tags: #PowerBI, #PowerQuery, #DataModeling, #StarSchema, #DAX #Analytics

Watch Now
Dejan Sarka Text Mining With TSQL Analyzing text is another modern hype. You have many tools, packages, and languages available. But did you know that you can do really a lot of text mining also in pure Transact-SQL? Yes, your SQL Server can also become a text mining engine. In this advanced session, you will learn how to analyze text in multiple languages with pure T-SQL, using also features from the full-text search (FTS).

#textmining #TSQL

Watch Now
Charley Hanania Querying best practices for Azure Synapse Analytics Data warehousing is evolving into the Cloud so it’s time to get on board. With Azure Synapse Analytics there are now more ways to transform, manage and present your data pipelines with scale and performance in mind. Recent experiences from clients on the platform have shown that if you just try to dump data into the platform and use it without understanding the underlying architecture and capabilities, you’ll leave fairly quickly as you see your costs skyrocket and the benefits decline. Join this session to get an understanding of what options are available to reduce your query times and lower your costs while allowing more users to access the data that’s been loaded into the platform. In this session we’ll cover: 1. Introduction to Azure Synapse Analytics Components 2. Azure Synapse Analytics Architecture Overview (querying-focused) 3. Best Practices & Tips for Querying data from Azure Synapse Analytics

Tags: #Azure #Synapse #Analytics #Loading #Polybase

Watch Now
Joshua Higginbotham Functional Python for the ETL Developer Python has been around for close to 2 decades now, with it\’s popularity and adoption growing larger each day. As Data Professionals moving towards a cloud approach, we will find Python as an offering in the majority of areas in the cloud environment. To be able to support this language, we can begin the adoption early on while still on-premises, replacing some of our traditional ETL\’s while increasing efficiency and accuracy of our existing solutions.

In this session:

We will leverage commonly used packages across the open source community that lowers your cycle time from start to completion. Building out reusable and scalable functions that facilitate commonly used ETL processes across your estate.

Tags: #DataEngineering #Analytics #ETL #Python

Watch Now
Jeremy Frye Power Apps and AI – A Flow of Location Events The Microsoft Power Platform has become an innovative bridge between data interaction, visualization and analytics. The possibilities have become almost endless for businesses to engage with their data in amazing ways.

In this session, I will show you an application using Power Apps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and use the application on a mobile device.  I will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Power Automate.

An end-user will be able to leverage Bing Search for location-aware web searches while an administrator will be able to leverage the Azure SQL Database and Power Automate to send alerts based on predefined metrics.

Watch Now
Reid Havens Unlocking New Visualizations and Features in Power BI Power 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.

Tags: #PowerBI #Visualizations #Storytelling #CustomVisualizations #Reporting #KPI

Watch Now
David Pless & Brian Carrig SQL Server 2019: Building A Foundation With Persistent Memory Data volumes have exploded. There is much more data at rest than ever before with only a small amount of the ingested data ever processed. Intel estimates that this is less than 1% of the volume ingested. Yet, we continue to produce data at record levels and systems can barely keep up to meet the demands.

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

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

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

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

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

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

We look forward to seeing you there!

#PersistentMemory #SQLServer2019 #SQLServer #Virtualization #Hyperconvergence

Watch Now
Lindsey Allen Azure AI, Power new possibilities for every organization AI and data is at the center of the digital feedback loops. The quintessential characteristic of every application going forward will have AI, we have invested in a comprehensive portfolio of AI tools, infrastructure and services. We are also pushing the bounds of how computers and AI can generalize learning beyond narrow domains. We work with our partners on our collective pursuit to democratize AI and its benefits for everyone. Come to this session to get an update of Azure AI with demos. Watch Now
Paul Turley Paginated Reports: the New Old Operational Reporting Platform Power BI Paginated Reports (aka SQL Server Reporting Services) was old but now it’s new again. Available on-premises or in the Power BI service with flexible licensing, you have multiple options to implement operational reports. This session will briefly cover the differences between analytic and operational reports; and help you understand the advantages and trade-offs using Power BI Paginated Reports, Power BI Report Server and SQL Server Reporting Services. Material from our forthcoming book: Paginated Report Recipes. Watch Now
Leila Etaati AI Builder: AI in Power Apps and Power Automate There are many ways to extend the AI capabilities inside Power Apps and Power Automate. In this session, you will see an overview of different capabilities with a brief demo on create an application to scan a business card and store back the result into Microsoft Outlook with help of AI builder and Power Automate. Watch Now
Melissa Coates What You Can Learn From The Power BI Activity Log And REST APIs The Power BI Activity Log and the Power BI REST APIs are a goldmine of information for understanding usage patterns and activities in your Power BI environment. In this demo-packed session, we will look at examples of the type of data you can obtain and how this data can make a significant contribution to your Power BI governance, security, management, and adoption efforts. Watch Now
Ben J Miller SQL Server Encryption Unplugged There are so many ways to encrypt data today, so you need to get your game on. From TDE, Always Encrypted, cell encryption and Backup encryption, there are some key pieces of information and methods that will help you get these all right. This session covers a lot of ground and will be over 60% demos. I will take you through each one of these and show you how it works. As an added bonus, we will hook TDE on premises up to Azure Key Vault too. We will also take you through rotation of the keys for TDE. Join me for a fast and furious demo packed session to get your data encrypted like a pro.

#TDE #SQLEncryption

Watch Now
Will Velida Introducing Graph Databases With Azure Cosmos DB Graph databases are an absolute game changer when it comes to storing our data! Data in the wild the more naturally connected than we might force it to be in a traditional relational database. However, you may not even know what a graph database is and how you can get started building one!

In this session, I’ll cover the basics of what graph databases are and how we can build a graph database in the cloud thanks to Azure Cosmos DB’s Gremlin API. Then I’ll discuss how we can model our graph data in Cosmos DB, how we can query our data that’s stored in a graph database and how we might apply graph databases to a variety of different use cases.

By the end of this session, you’ll leave with an understanding of what Graph databases are, what you can use graph databases for and how we can use Azure Cosmos DB to build a graph database.

#azure #cosmosdb #graphdb

Watch Now
Stefano Tempesta AI-Powered SharePoint Intranets This session combines the agility of building pages and web parts in SharePoint Framework, with the power of the Microsoft AI platform. Specifically, I’ll present a dashboard in SharePoint that displays Machine Learning-powered sentiment analysis of your intranet contributions; an automatic document and image classification with Cognitive Service, and a content filtering engine that learns from new entries and improves accuracy of detection over time.

#MachineLearning #SharePoint

Watch Now
Louis Davidson Matters Of Concurrency OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

Tags: #Concurrency #MemoryOptimizedTables #SQL Server 2019

Watch Now
Ferenc Csonka XMLA Read-Write Endpoint: The Cornerstone For Power BI As An Enterprise BI Solution Since the release of Power BI Premium in 2017, Microsoft has been continuously expanding the list of features that differentiate its solution running on a dedicated capacity from the shared capacity version. A game-changer step in this process is the release of the XMLA read-write endpoint, which makes Analysis Services Tabular models of Power BI reports deployed on Power BI Premium available for both reading and writing. This makes a myriad of applications and techniques previously developed for on-premises Analysis Services Tabular and Azure Analysis Services models available for developing and operating Power BI reports, taking Power BI Enterprise BI solutions to the next level. In this session, we present several practical use cases for XMLA read-write endpoint: migrating existing Analysis Services Tabular models to Power BI Service, significantly improved application lifecycle management for Power BI artifacts, debugging, monitoring and tracing functionalities for Power BI reports, much more sophisticated incremental refresh solutions, using such Analysis Services Tabular-specific features which are not available in Power BI, etc.

Power BI Premium, XMLA, Analysis Services, monitoring, ALM, incremental refresh

Watch Now
Argenis Fernandez Advanced Storage Troubleshooting for SQL Server In this session we will go over the tools and tricks used to track down nasty storage issues as they affect SQL Server databases on hypervisor plus storage array or hyper-converged configurations. We will go ver the different places in the stack where I/O could be stuck, queued, or just flat out slow.

This is an advanced session and as such you can expect tons of bits and bytes being shown!

Watch Now
Martin Cairney My Top 5 Omissions From Azure SQL Database Applications And How To Fix Them As a consultant, I am often called upon to help troubleshoot Azure SQL Database applications. Most of these could have been addressed with better design and planning.

Come along to this session and discover the common omissions from a robust Azure SQL Database implementation and how you can go about fixing these in your own environment before they bite you.

Watch Now
Haniel Croitoru Manage Your Power Automate Governance Like A Rockstar You’ve managed to get Power Automate introduced and even adopted within your organization, which is awesome. But are you sure that everyone is using it the way they should? Are you up at night wondering whether

– Do my flow makers know the confined in which they can and should build flows?

– Are there flows that are beyond the rights and capabilities of my flow makers?

– Is any of my organizational business data being compromised?

– Do my flow makers able to leverage Power Automate for their business needs without negatively impacting themselves or their peers?

– Are my flow makers following organizational best practices recommended by my IT department?

– Is my IT department being taxed with additional support for flow makers beyond their means?

If you’ve answered yes to any of these questions, then you shouldn’t miss this session, where I will introduce and demonstrate topics such as

– Data Loss Prevention in Power Automate

– Automating Power Automate onboarding and training for new flow makers

– Building a governance matrix to establish what flows should be owned by whom

– Leveraging the Power Apps Center of Excellence to audit and report on flow usage within your organization

– Create an audit trail of activities performed by users

– Creating organizational templates

Watch Now
Andrew Brust AI And Analytics With Apache Spark And Azure Databricks Open source technology Apache Spark is the analytics and machine learning platform of choice for many companies. While Spark has manifested in numerous parts of the Microsoft stack, including HDInsight, Synapse Analytics and even SQL Server 2019, Microsoft’s go-to Spark service is Azure Databricks.

The service, from Microsoft and Databricks (the company founded by Spark’s creators), is a versatile one, geared towards data lake management, analytics, data engineering and data science. Azure Databricks lets developers work in notebooks, offline, interactively with running clusters, or scheduled as production jobs that provision Spark clusters on-demand.

This session will cover the concepts, service mechanics, and code necessary for you to do analytics and machine learning on Azure Databricks, and integrate it with other Microsoft cloud services and on-premises technologies.

You will learn:

About the fundamentals of Apache Spark, Spark SQL and Spark MLlib

How to use Databricks notebooks and manage clusters

The rigors of integrating Databricks with Azure Storage, Azure SQL Database and Power BI

How to write Python code for both analytics and machine learning

Cool new Databricks features, like Delta Lake, Delta Engine and MLflow

#ApacheSpark #Databricks #Azure #MachineLearning #AI #ML #DataEngineering #DeltaLake #MLflow

Watch Now
Gilbert Quevauvilliers How I Reduced My Power BI Dataset By 60% How to optimize Power BI Datasets to ensure that they can run as fast as possible with the smallest amount of memory possible.

The session will cover the following topics:

Data Modelling with the Star Schema

Looking at columns in the dataset

Data Types and how this affects the size of your dataset

Using DAX Studio for analysis of datasets

Real world optimizations that I put into practice

Questions

Watch Now
Torsten Strauss Microsoft SQL Server – In-Memory OLTP Design Principles In this session we will look at the design principals of the in-memory OLTP engine. We will understand how the in-memory engine optimizes data storage for main memory, eliminates latches and locks, and uses native compilation to reduce the CPU overhead.

For this we will compare the traditional on-disk engine with the in-memory engine to decide when it makes sense to use in-memory OLTP.

Watch Now
Abhishek Narain Architecting enterprise-grade data pipelines with Azure Data Factory Azure Data Factory is the modern data integration service (hybrid, server-less, cloud scale) that enables customers to build their ETL/ ELT pipelines for their Modern Data Warehouse (MDW) from Big Data. What truly makes Azure Data Factory an enterprise-ready ETL service is the in-built security features. In this talk we will learn all security fundamentals and best practices while building data pipelines in Azure Data Factory.

#AzureDataFactory#ETL#Azure#AzureData#DataFactory#Security#DataPipelines

Watch Now
Anthony Nocentino Containers – What’s Next? You’ve been working with containers in development for a while, benefiting from the ease and speed of the deployments. Now it’s time to extend your container-based data platform’s capabilities for your production scenarios.

In this session, we’ll look at how to build custom containers, enabling you to craft a container image for your production system’s needs. We’ll also dive deeper into operationalizing your container-based data platform and learn how to provision advanced disk topologies, seed larger databases, implement resource control and understand performance concepts.

By the end of this session, you will learn what it takes to build containers and make them production ready for your environment.

Watch Now
Alicia Moniz Data Stewardship In An AI-Driven Ecosystem: InterpretML, FairLearn, WhiteNoise At the core of Microsoft’s AI are the principles of fairness, reliability & safety, privacy & security, inclusiveness, transparency & accountability. As AI capabilities increase along with adoption, it is important that we also leverage tools that enable us to practice AI responsibly.

Responsible ML provides us with tools to ensure that as practitioners we

Understand machine learning models – Are we able to interpret and explain model behavior? Are we able to assess and mitigate model unfairness

Protect people and their data – Are we actively working to prevent data exposure with differential privacy?

Control the end-to-end machine learning process – Are we documenting the machine learning life cycle?

Announced at Build this year were multiple Responsible ML open source packages. The accessibility of these freely available tools enables every machine learning developer to consider incorporating Responsible ML into the development cycle of their AI projects.

InterpretML – An open source package that enables developers to understand their models behavior and the reasons behind individual predictions.

A python package that enables developers to assess and address fairness and observed unfairness within their models.

WhiteNoise – An open source library that enables developers to review and validate the differential privacy of their data set and analysis. Also included are components for data access allowing data consumers to dynamically inject ‘noise’ directly into their queries.

Datasheets for Models – A python SDK that enables developers to document assets within a model, enabling easier access to metadata about models

It is import that we design sustainable AI systems with ethics in mind. Join us for an overview and demo of these packages!

Watch Now
Peter Myers Working With Different Power BI Data Model Architectures Power BI provides you with different data model architectures. It’s all controlled by setting the storage mode of model tables, as either Import, DirectQuery, or Dual. In this presentation, learn why and how to develop the model that best fits your data and circumstances. Also, learn how you can extend an existing Power BI data model with new data and calculations. Watch Now
Warner Chaves Global Analytics with Azure Cosmos Db and Synapse Analytics Cosmos Db is Azure’s NoSQL Database as a Service, born in the cloud and designed to take advantage of the flexibility, elasticity and global reach of cloud computing.

Synapse Analytics is Azures data analytics services that integrates on-demand SQL querying, Spark big data, Data Lake Store Gen2 as well as an integrated authoring experience.

Together these two services can be used to develop solutions in a simple and elegant way that would have been incredibly complex before. The most ambitious is the capability of doing Global Analytics, being able to do analytical queries over your live operational data coming from anywhere in the planet. All without having to handle one piece of infrastructure yourself.

In this demo-heavy session we will look at the C# code, features and configuration of Cosmos Db and Synapse and see the Global Analytics in action live.

#CosmosDB #NoSQL #Synapse #BigData #ADLS2 #Analytics

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

#sqlserver #azuresql

Watch Now
Sasha Nosov Azure Arc Enabled SQL Server Even if you cannot migrate or modify your SQL Server application, you can leverage Azure. Whether your existing SQL server instances deployed to your private infrstraucture, AWS or GCP, you can use Azure Arc to manage your global inventory, protect SQL Server instances with Azure Security Center or periodically assess and tune the health of your SQL Server configurations.

#AzureArc

Watch Now