Here you can access the recordings of DPS 2022, 2021 & 2020 general sessions. Browse from 500+ 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 8 years? Click Here
DPS 2022
DPS 2021
DPS 2020
| Speaker Name | Track | Content Language | Session Title | Abstract | Recordings |
|---|---|---|---|---|---|
| Bob Ward & Buck Woody | NA | English | Keynote | Check-out the latest innovations in the Microsoft Intelligent Data Platform for SQL and operational databases and how you can enable everyone in your organization to securely locate and use data to make intelligent decisions. Bob Ward and Buck Woody from the Engineering team will show you how to meet the needs of developers across the spectrum to leverage the new tools, processes, and platforms in the Intelligent Data Platform to create a data culture in your organization. Bob will go deep on the newest release in the Intelligent Data Platform – SQL Server 2022. | Watch Now |
| Alexandra Ciortea, Evangeline White, Valorie Hampton, Nikita Takru & Shreya R. Aithal | NA | English | WIT | NA | Watch Now |
| Dr. Sangeeta Gupta, Sanil Mhatre, Vanessa Toves, Michelle Gutzait, Deepthi Goguri, Brian Bønk, Edward Pollack, Tanya Pupko & Thomas Grohser | NA | English | DEI | NA | Watch Now |
| Abhiman Tiwari | Data Administration | English | Data Replication in Azure SQL and Beyond | This session will cover data replication technologies such as CDC (with a focus on CDC in Azure SQL DB), SQL Data Sync, transactional replication, and more. The topics covered will include common use cases, benefits/limitations, demos for each of the products covered. | Watch Now |
| Adi Eldar | Data Science (AI/ML) | English | Azure Data Explorer for Data Scientists | Join the session to learn about advanced analytics capabilities of ADX including native time series analytics capabilities, and ML features. | Watch Now |
| Aditya Badramraju & Mohammed Kabiruddin | Data Administration | English | SQL Server in Azure Virtual Machines – Configuring for price-performance | When selecting a virtual machine to host your SQL Server workload in Azure, you need to choose a virtual machine size that provides optimal performance and fits your organization’s budget. There are a number of different compute and storage options in Azure, so choosing the configuration that gives you the best price-performance for your workload can be a challenge. In this session, we will cover topics such as the different virtual machine types that are most appropriate for SQL Server workloads (including the new Ebdsv5 series), configuring storage, and features unique to Azure such as host caching and write acceleration that can help boost your performance without breaking the bank. | Watch Now |
| Akshata Revankar | Business Intelligence & Advanced Analytics | English | Wrangle data in Power BI with Power Query Editor | If you are wondering, “I don’t know Power Query M, but can I still wrangle my data?” , the answer is yes! Power Query Editor in Power BI Desktop has several options to wrangle your data with little expertise on Power Query M. This session will cover and introduction to Power Query Editor and a demo on how to profile, clean, prepare & enrich data in Power Query Editor.
Profile data : Understand your data Clean data : Find and replace, drop fields not required, remove outliers Prep/enrich data : add/compute new fields, structure your data, merge datasets Type : Light on slides, heavy on demo This session is perfect for those who want to get started with using Power Query Editor for wrangling data. |
Watch Now |
| Alberto Diaz Martin | Architecture | Spanish | Azure Machine Learning, Azure Databricks, ahora Azure Synapse | ¿Qué servicio uso para desarrollar mi AI? ¿Qué uso para implementar un Big Data? ¿y si necesito un Modern Datawarehouse? En esta sesión hablaremos sobre los servicios relevantes de AI y Big Data de Azure y cómo y cuándo los debería de tener en cuenta para usarlos en mi proyecto. | Watch Now |
| Neel Ball | Data Administration | English | Modernize your Oracle workloads to Azure SQL – What’s new? | Are you looking to leave Oracle behind? Join us on a demo packed session to find out what’s new in the Oracle to Azure Data 1st party migration tools as Database Schema Conversion Toolkit and Database Migration Assessment for Oracle. Assess your applications and identify connections strings and data access APIs using Data Access Migration Toolkit. | Watch Now |
| Alpa Buddhabhatti & Ben Kettner | Business Intelligence & Advanced Analytics | English | Azure Data Factory ♡ Bicep | Azure Data Factory Bicep Azure Data Factory (ADF) is a mighty tool when it comes to creating data loading workflows and orchestrations. However, creating ADF loading logic takes a lot of clicking and even though it is thoroughly integrated with Git, the code representation of ADF resources is hardly ever used. Bicep is a mighty tool when it comes to creating Azure Resources from Code and its capabilities go beyond just creating infrastructure resources. What if both came together and we were able to create ADF Linked Services, Datasets and Pipelines from a Bicep template? It would be a match made in heaven. But why wait for dreams to come true? In this session we will introduce you to the basic concepts of ADF and Bicep and then show you how you can create ADF from Code by writing Bicep files and deploy them to your Azure subscription with one click. | Watch Now |
| Amanda Martin | Industry Solution | English | Developer Productivity Engineering – The Next Big Thing in Software Development | It is 2022 and IDC has foretold that 65% of the global GDP is digitally transformed. Two-thirds of the products and services that we pay for are driven by software, and the quality, cost and time to market of your software products will determine the fate of your business. There has never been a more important time to foster developer productivity, but many of our methods have not evolved.
In this talk you will learn why DPE is the most important development in the software engineering world since the introduction of Agile and DevOps concepts and tools. DPE is a new software development practice that uses acceleration technologies to speed up the software build and test process and data analytics to improve developer efficiencies by as much as 10x. The ultimate aim is to achieve faster feedback cycles, more reliable and actionable data, and a highly satisfying developer experience. |
Watch Now |
| Anna Hoffman, Marisa Brasile | Development | English | Data Exposed Live: News Updates | Join the audience of a Data Exposed session LIVE from Data Platform Summit! You’ll receive the latest updates containing all things SQL Server and Azure SQL. This not-to-miss session will include demos, special guests, and a sneak peek at the future! | Watch Now |
| André Melancia | Data Science (AI/ML) | English | Machines Are Learning. You Should Learn ML Too: An Azure Story | Afraid bots will take over your job and you’ll need to fight Skynet?
Join us and learn how machine learning works, and have a look at how you can win the cyber wars with Azure Machine Learning (and a much more). Disclaimer: “This is the world now… Code with me if you want to live.” |
Watch Now |
| Andrea Martorana Tusa | Business Intelligence & Advanced Analytics | Italian | Integrate Teams, Power Automate and Power BI for project management and monitoring | Guarda un esempio reale di integrazione usando gli strumenti della Power Platform.
Un team utilizza Teams come strumento principale per il project management. Tutto è gestito in Teams attraverso l’estensione delle apps richieste: Planner, Sharepoint, OneNote, Power BI, … Ma non tutte le attività possono essere gestite via Teams e spesso i clienti non hanno una licenza Planner, oppure usano uno strumento differente per il Project Management (Trello, Jira, …). Inoltre, nè Planner nè Teams, hanno una dashboard condivisa con una visione d’insieme di tutti i progetti in corso, per i project managers. Ed è qui che la Power Platform si inserisce; usando Power Automate è possibile implementare un meccanismo di automazione da e verso Teams, eliminando le doppie attività ed incrementando la produttività. Power Automate si può connettere ad ogni canale Teams ed ai vari tasks di Planner in modo ricorsivo per leggere tutti i dati e copiarli in un’altra destinazione, per esempio una base dati. Il prodotto finale è quindi un report Power BI che sintetizza tutti i tasks e le varie attività in una pagina unica, costruendo quella vista generale che mancava in Teams e Planner. |
Watch Now |
| Andreas Wolter | Data Administration | English | Inside data and access policies for Azure SQL and SQL Server | Join this session to gain an understanding of how policies from Azure Purview are integrated into the SQL Engine and how to troubleshoot policy based authorization with XEvents and DMVs. | Watch Now |
| Anshul Sharma | Architecture | English | Overview of Azure Data Explorer | Azure Data Explorer is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, IoT devices, and more. Join this session to learn about ADX features, common use cases, customer stories, and lots of demos. | Watch Now |
| Anton Fritz, Yael Biss & Naama Tsafrir | Business Intelligence & Advanced Analytics | English | Govern your sensitive data in Power BI with Microsoft Purview | Learn how you can meet your organization’s compliance and information protection requirements with natively integrated into Power BI Microsoft Purview Information Protection and Data Loss prevention solutions. These solutions are widely used by Enterprises to meet compliance requirements for Microsoft 365 apps, like Office, SharePoint, Teams and Exchange. These solutions will enable you to classify and label sensitive data, protect data as it travels from Synapse trough Power BI and to Office and enable you to automatically detect upload of sensitive data leveraging content scan. | Watch Now |
| Arvind Shyamsundar | Development | English | SQL Graph: best practices for easily modelling and querying complex data models | Have you struggled with how to represent a “many-to-many” relationship in relational tables? Has your mind been strained in the process of writing a recursive CTE to query a hierarchy? Have you given up trying to implement core graph algorithms efficiently in T-SQL?
For all these cases, and more, SQL Graph provides an elegant way to model a graph (nodes and edges) built-in T-SQL support (MATCH / SHORTEST_PATH) to help with pattern matching and recursive path finding in such a graph. In this session we will use examples derived from real-world cases where SQL Graph has been used to ease development effort and enable new types of workloads on Azure SQL DB, Azure SQL Managed Instance, and SQL Server. |
Watch Now |
| Attinder Pal Singh & Balmukund Lakhani | Industry Solution | English | Scale out read workloads with Azure SQL DB Hyperscale Named Replicas | Join this session to learn how Named Replicas enables you to scale-out a variety of read workloads, be it highly concurrent OLTP workloads or HTAP solutions for real-time data analytics. | Watch Now |
| Avner Aharoni | Data Administration | English | Building highly concurrent applications with Azure Data Explorer | Join the session to explore techniques to develop highly concurrent applications on Azure Data Explorer (i.e.. scenarios where the application is required to simultaneously handle many requests with low latency and high throughput). Use cases include large-scale monitoring and alerting dashboards. If your organization is looking to derive full potential of continuous streaming data, this session is for you. | Watch Now |
| Avnish Rastogi | Data Administration | English | Migrate MySQL Databases from on-premises and other cloud providers to Azure Database for MySQL with near Zero Downtime | Join this session to learn different migration methodologies, techniques, tools and best practices to migrate from a self-managed MySQL environment running on-premises or other cloud providers to Azure Database for MySQL with near zero downtime | Watch Now |
| Avnish Rastogi & Sai Kondapalli | Development | English | Leveraging ARM, CLI & Terraform to provision Azure Database for MySQL Flexible Server using private or public access | In today’s world where agility and pace of development are key for a customer’s business, we will talk about leveraging ARM / CLI and Terraform templates to build MySQL environments at a rapid rate. | Watch Now |
| Balram Prasad | Business Intelligence & Advanced Analytics | English | Authoring, publishing Policy and Workflows in Azure Purview | Access policies in Microsoft Purview enable you to manage access to different data systems across your entire data estate. For example:
A user needs read access to an Azure Storage account that has been registered in Microsoft Purview. You can grant this access directly in Microsoft Purview by creating a data access policy through the Policy management app in the Microsoft Purview governance portal. Data access policies can be enforced through Purview on data systems that have been registered for policy. Workflows are automated, repeatable business processes that users can create within Microsoft Purview to validate and orchestrate CUD (create, update, delete) operations on their data entities. Enabling these processes allow organizations to track changes, enforce policy compliance, and ensure quality data across their data landscape. We will walkthrough how to create policy and workflow in this demo. |
Watch Now |
| Bashar Hussein & Siddhant Sawant | Data Administration | English | Improve database performance with Azure Database for MySQL – Flexible Server | Azure Database for MySQL – Flexible Server is a fully managed MySQL service on Azure designed to provide more granular control and flexibility over database management functions and configuration settings. In this session, you’ll learn how this service provides tuned performance to handle your mission-critical applications at affordable costs with the new Business Critical service tier, and how you easily you can improve your database performance further with monitoring and customized controls. | Watch Now |
| Ben Miller | Data Administration | English | dbatools PowerShell Module Deep Dive | DBAs now have PowerShell as a tool in their toolbox. Dbatools is a module that was written for the SQL Server DBA. This session will go deep in what you can do with this module. You will learn how to leverage this module to get more done in less time and effort. We will go through the commands in the module (not all of them, there are over 600) and do many demos of how to use them. The most important thing you will learn is how this was put together so that you can build your toolset around this amazing module and get more done and most importantly be able to reuse configurations to jump start your use of this module. Join me on a quest to become the best PowerShell DBA around. | Watch Now |
| Benjamin Kettner & Uwe Ricken | Development | English | Working with time: Timeseries data in SQL Server | Time series data is omnipresent in today’s data landscapes. Technical logging, financial transactions or IoT devices all generate data that is typically associated with a timestamp and can be categorized as time series data.
Even tough time series data stem from a plethora of sources, the structure of the data and the queries that are typically executed against this type of data are very similar throughout the different applications. Thus, it makes sense that a whole ecosystem of different databases evolved for working with time series data. The benefits of such specialized databases is that they are equipped with structures for supporting the different types of queries while at the same time providing techniques for the ingress of time series data as a stream of data. One of the most popular specialized tools for working with time series data is the TimeScale extension for PostgreSQL databases. Installing and enabling this extension will result in the creation of indexes, triggers and procedures that facilitate working with time series data. In our session, we will take a closer look at time series data and explain the different operations and data structures that can be utilized when working with time series data. We will discuss a strategy for benchmarking the efficiency of working with time series data. Next, we will take a closer look at the TimeScale extension for PostgreSQL and analyze its components. Finally, we will show which of these components can be implemented in an Azure SQL database and which need to be adjusted. |
Watch Now |
| Bob Duffy | Architecture | English | Star Schema Automation in EDW/SqlPool | This session focuses on how to automate Star Schema creation, loading and extensibility using meta data based automation TSQL templates and DMVs.
Go from BUS Matrix to star schema with almost no coding at scale as we do for 10s of thousands of tables. Note that we are focusing here on the Transform and Load parts of ETL, not the extract which is usually quite easy to automate. |
Watch Now |
| Bob Ward & Ajay Jagannathan | Data Administration | English | Overview of SQL Server 2022 | Join us to learn about the new features in SQL Server 2022 that improve security, performance, and high availability. See how new features in SQL Server empower you to build modern, intelligent apps even faster. You will also learn how the integrated data platform enables new hybrid scenarios such as near real-time intelligence with Azure Synapse Link and enhanced data governance with Azure Purview, for applications that rely on the power of the SQL Server database engine. | Watch Now |
| Brian Bønk | Development | English | Intro to Serverless SQL in Azure Synapse | If you are new to Synapse and want to know how to get started, then this is the session to attend.
I’ll guide you through the Synapse application and demo different ways to use the serverless SQL pools from Synapse. You’ll learn how to do simple setups, work with different filetypes from the Blob storage and I’ll give you tips and tricks to get the most out of your Synapse platform |
Watch Now |
| Caio Buzo & Leandro Sampaio | Data Administration | Portuguese | Desafios de mover um database de um Managed Instance para um Azure SQL Database | Nessa sessão mostraremos um case real de uma migração de um database do Managed Instance para um Azure SQL Database, passaremos por todas as etapas de construção do projeto até a execução final em uma demonstração. Esse projeto proporcionou a redução de $13k/ano. | Watch Now |
| Carlos Lopez | Data Administration | English | Getting into CI/CD Pipelines in AzureDevOps for Azure SQL | In this session we will work on Azure SQL as a data platform working interacting in collaboration with different teams in Azure Devops accelerating value of your workflow. Implementing DevOps practice helps organizations to develop en deliver faster products, maintaining the stability and confidence, increasing confidence in the applications they build, and achieve business goals faster..
In this session we can explore the use of tools and platforms like Visual Studio, Azure Data Studio, Git and Azure DevOps for a modern platform as data ops role using with DevOps practice in Azure SQL. With the combination of these platforms we can experience the integration of data world into the DevOps culture providing tools for the data engineer to support the process of delivering applications. |
Watch Now |
| Carlos Robles, Ajith Krishnan & David Levy | Architecture | English | How to migrate SQL Server databases to Azure | Microsoft provides data professionals with multiple tools and services, to handle SQL Server migrations to Azure. However, the key to a successful migration is to understand the differences and benefits of each one of these different tools and services, moreover how to leverage them according to your migration scenario.
In this session, you will learn the different cloud migration strategies, phrases, and examples through demos that will help you drive a successful migration of your SQL Server to the different options in Azure; like Azure VM, Azure SQL Database, and Azure SQL MI. Join us in this exciting journey to modernize your SQL Server workloads to Azure quickly and easily! |
Watch Now |
| Chan Ming Man | Development | Chinese | 如何前往 Azure 数据工厂 (ADF)中运行 SQL Server Integration Services (SSIS)和 ADF 管道 | 本次会议向您展示如何使用 Azure 数据工厂来执行 SSIS 包。 本次会议还展示了如何在没有 SSIS 包的情况下仅使用 Azure 数据工厂完成 SSIS 任务。 该会议还将讨论如何集成本地数据和云数据 | Watch Now |
| Charles Feddersen | Development | English | Building Scale-out OLTP with PostgreSQL Hyperscale (Citus) | Join this session to learn how to do develop OLTP optimized databases at any scale using PostgreSQL Hyperscale | Watch Now |
| Charles Webb | Business Intelligence & Advanced Analytics | English | What’s new in Datamarts | Join this session to learn about the latest features and improvements to Datamarts | Watch Now |
| Chris Adkin | Development | English | An introduction to Data Lakes on S3 | SQL Server 2022 includes enhancements to polybase such that data stored in S3 can be virtualised, this opens up the data platform world to data lakes on clouds other than Azure. But what is S3 ?, what tools can I use for working with it ?, | Watch Now |
| Christian Cote | Industry Solution | English | Azure Synapse Lake Databases in your Data Lakehouse | Data Lakehouses are the natural evolution of data lakes and data warehouses. Azure Synapse Analytics has a great functionnality for it: the lake databases. This sesssion will show you how lake databases can be used and how to integrate them in you data lakehouse. | Watch Now |
| Christophe Laporte | Data Administration | English | Configure SQL Server for efficient troubleshooting | Installing SQL Server is simple. Unfortunately, the default configuration is not meant for an effective diagnosis in the event of an issue. Data retention is insufficient, or no crucial information is collected.
Through some simple PowerShell scripts, we will address a few essential points to ensure an efficient troubleshooting. |
Watch Now |
| Cláudio Silva | Data Administration | Portuguese | dbatools e Power BI encontram-se num bar | Entrar numa nova equipa/empresa e não conhecer os ambientes pode ser intimidante.
A equipa de DBAs actual dá-nos uma lista de instâncias à qual devemos ter acesso e quer que façamos mágica! Felizmente, podemos aproveitar o módulo PowerShell dbatools para obter muitas informações que nos darão um estado da arte e ajudarão a responder a algumas perguntas. – Esta instância corre num servidor virtual ou físico? – Quais os recursos (CPU/memória) que estão alocados? – Qual versão e edição está instalada? – Qual é a evolução do tamanho das bases de dados, filegroup ou tabela? – Sabemos quantos registos são adicionados por dia à maior tabela? – O que uma previsão lhe dirá sobre o tamanho da base de dados e/ou tabelas em 2 meses? Irá precisar de mais espaço? Irei mostrar como podemos guardar estas informações obtidas através do dbatools numa base de dados central. Além disso, como podemos aproveitar alguns dashboards do Power BI que eu criei. Este painel ajudará a responder a estas e outras perguntas mais rapidamente do que você imaginava que seria possível. Esta é uma solução 100% gratuita! Termos dados e poder dar-lhes significado não tem preço! Após esta sessão poderão implementar esta solução nos vossos ambientes e partilhá-los com os seus colegas de equipa, clientes e gestores! |
Watch Now |
| Collin Brian & Kellyn Gorman | Data Administration | English | Make Azure the Future Home of Your Oracle Workloads | Migrate or modernize your Oracle workloads to Azure for greater flexibility, scale, and innovation, with industry leading security and compliance. With Azure VMs to cloud-native relational and non-relational databases, Azure has a home for all your Oracle workloads. Join this webinar to learn how to engage with Microsoft to advance your cloud adoption strategy with best practices, cost saving strategies, and more. We will walkthrough tools you can leverage to automate and accelerate the migration process. | Watch Now |
| Craig Bryden | Data Administration | English | Govern your data estate with Azure Purview | Keeping track of what data and reports you have is really hard and exposing this to users is even harder. In this session, I will introduce you to Microsoft’s data catalog tool, Azure Purview. Although you may have seen a session on this last year, this product has been evolving rapidly and will look quite different from last time | Watch Now |
| Dani Ljepava & Mladen Andzic | Architecture | English | Enjoy Azure SQL benefits using your SQL Server and Managed Instance link feature | We’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance. Embark with us on the innovation journey and hear directly from the Microsoft SQL engineering product group on how we’ve started this as an internal project codename Chimera to what became the link feature. | Watch Now |
| Daron Yöndem | Development | English | Discover Serverless Data for Serverless Apps | Serverless is all the hype. We walk about Serverless applications but rarely look into our data services options. Building a full-on serverless architecture requires all layers to conform to our serverless world. In this session, we will look at data services in Azure that are Serverless in their nature, or can be serverless with the right implementation. | Watch Now |
| Darshna Shah | Data Science (AI/ML) | English | The AI Gambit: Climate Change | One of the most powerful applications of data and AI technology is in the fight against climate change. From better understanding climate change to solutions that allow us to mitigate and adapt to the climate crisis through: predicting energy demand, understanding which chemical structures can better absorb carbon, developing robust electric vehicle charging infrastructure, educational tools, optimising supply chains, creating smarter buildings, improving agriculture at scale and so much more- the possibilities for innovation are limitless! On the flip side, it is also important to be aware of the carbon costs when designing architectures covering every aspect of development (Data Engineering, Data Science, Web development, etc). During this session we will explore the complexities of building reliable predictive climate models and considerations of building green technology. | Watch Now |
| David Barbarin | Data Administration | French | Automatiser le déploiement, la gestion et la surveillance de SQL Server | Les DBAs sont traditionnellement les gardiens des données dû à l’importance des bases de données dans le système d’information et de fait un rôle souvent isolé dans la plupart des entreprises. Mais l’industrie informatique est en perpétuel changement et le rôle d’administrateur de bases de données doit évoluer avec l’avènement des systèmes “cloud native”, des environnements distribués et d’une nouvelle culture “DevOps” où la notion de “time-to-market” prend une part importante.
L’automatisation est un des outils proposés par cette culture DevOps et permet de répondre à l’accélération des livraisons logiciels incluant les bases de données qui ne font pas exception. Dans cette session, nous verrons quelques outils d’automatisation de nouvelle génération et comment ils peuvent aider aux nouvelles exigences d’architectures modernes. |
Watch Now |
| David Pless | Data Administration | English | SQL Server 2022 tempdb – The Uncontended | Over the years, there have been many recommendations regarding configuration options for tempdb.
tempdb is used by every database workload for temporary storage, and additionally for internal operations. So, it’s important to get SQL Server’s tempdb as optimal as possible. The behavior of tempdb has also changed over time, but what hasn’t changed is the criticality of tempdb and how its proper use and configuration can have major implications in the performance of your application. In this session we will discuss some of the improvements with tempdb in the latest versions of SQL Server and what good tempdb practices look like today. We will also discuss the improvements in SQL Server that will unlock scalability of tempdb-heavy workloads now and into the future. SQL Server has improved tempdb in every single release and SQL Server 2022 is no exception. |
Watch Now |
| David Pless & Kevin Farlee | Data Administration | English | SQL Server 2022 Engine Deep Dive Part 1 | In this session we will focus on many of the storage improvements with advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power.
The storage engine features and capabilities we will highlight are tempdb improvements, Always On Availability Group improvements, accelerated database recovery, shrink database with low priority, xml compression and more. We will touch on availability improvements such as Intel QAT backup compression to offload backup overhead and multi-write replication for multi-master writes users across multiple locations. Finally, we will review the security capabilities with SQL Server ledger, encryption enhancements, improvements to dynamic data masking, and more. |
Watch Now |
| David Pless & Kevin Farlee | Data Administration | English | SQL Server 2022 Engine Deep Dive Part 2 | In this session we will focus on many of the storage improvements with advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power.
The storage engine features and capabilities we will highlight are tempdb improvements, Always On Availability Group improvements, accelerated database recovery, shrink database with low priority, xml compression and more. We will touch on availability improvements such as Intel QAT backup compression to offload backup overhead and multi-write replication for multi-master writes users across multiple locations. Finally, we will review the security capabilities with SQL Server ledger, encryption enhancements, improvements to dynamic data masking, and more. |
Watch Now |
| Deepthi Goguri & Matt Gordon | Data Administration | English | Troubleshoot and Triage Like a Pro | Have you ever felt overwhelmed by on-call issues? Have you ever felt hyper-stressed by urgent fixes demanded by developers, management, or anybody who doesn’t understand the issues at hand? Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane. | Watch Now |
| Dejan Sarka | Data Science (AI/ML) | English | Association Rules Step by Step | Market basket analysis with T-SQL, R, Python, Azure ML and SSAS. You will learn how to recognize good products, products which raise the sales of other products, and toxic products, products which are usually sold alone or are the last product in the basket, thus finishing the shopping. Measures like support, confidence and lift, are explained in details. Sequential basket analysis is covered as well. Demos are developed step by step in T-SQL, in order to show how the calculations are made. Then you will see demos also in other languages and on other platforms. | Watch Now |
| Dejan Sarka | Data Science (AI/ML) | Slovenian | Asociativna pravila korak za korakom | Analiza nakupovalne košarice s programskimi jeziki T-SQL, R in Python, z analitskimi storitvami Azure ML, ter s strežnikom SQL Server Analysis Services. Slušatelji se bodo naučili kako prepoznati pozitivne ali dobre produkte, produkte, ki povečajo prodajo drugih produktov, pa tudi negativne ali slabe produkte, produkte, ki se po navadi prodajajo sami ali pa kot zadnji v nakupovalnem seznamu in s tem zaključijo nakup. Razložili bomo vse podrobnosti meritev, ki jih pri tem uporabljamo – podpora, zaupanje, dvig (support, confidence, lift). Predstavljene bodo tudi sekvenčne asociacije, skupine produktov, ki pridejo v košarico v določenem vrstnem redu. Pravila bodo razvita korak za korakom v jeziku T-SQL, nato pa bo analiza prikazana še v drugih priljubljenih analitskih jezikih in okoljih. | Watch Now |
| Denis Reznik | Development | English | SQL Server Query Lifecycle | We all know what a relational database is, what the SQL language is, and how to get or modify data in a database. The algorithm is straightforward:
1) Write an SQL query 2) Send it to SQL Server 3) Get the result It’s all straightforward, but only until the moment when we get the result is not what we expected, or do not get it at all, or gave up to wait for the data, etc. It happens because, between the second and third steps, many things affect the result. When we face the issue related to query execution, it can be challenging to solve the problem without knowing what is happening inside. And in this session, we will go with you the same way that the query in SQL Server goes from the moment you run it in SSMS to the moment of receiving the result. Following this will help us understand why we get such a result under certain conditions and work more efficiently with databases. |
Watch Now |
| Denis Reznik | Development | Ukranian | Життєвий цикл запиту SQL Server | Ми всі знаємо, що таке реляційна база даних та як отримати або змінити дані в базі даних. Алгоритм приблизно такий:
1) Пишемо SQL-запит 2) Виконуємо його його на SQL Server 3) Отримуємо результат Це все виглядає досить просто, але лише до моменту, коли ми отримаємо результат не той, на який очікували, або не отримаємо його взагалі, або перестали чекати даних тощо. Це відбувається тому, що між другим і третім кроком, відбуваєтться багато процессів які впливають на кінцевий результат. Коли ми стикаємося з проблемою, пов’язаною з виконанням запиту, може бути важко її вирішити, не знаючи, що відбувається всередині. І по ходу цієї доповіді ми пройдемо з вами той самий шлях, яким проходить запит у SQL Server. Від моменту, коли ви запускаєте його в SSMS, до моменту отримання результату. Це допоможе нам зрозуміти, чому ми отримуємо такий результат за певних умов, і ефективніше працювати з базами даних SQL Server. |
Watch Now |
| Dennes Torres | Business Intelligence & Advanced Analytics | English | Power BI Metrics: Managing KPI’s with Power BI | Power BI Goals is a quite new and powerful feature to manage KPI’s and incorporate KPI’s in our analysis and Dashboards.
In this session you will discover how how Power BI Goals work and how they can be used to integrate KPI’s in our analysis |
Watch Now |
| Dennes Torres | Business Intelligence & Advanced Analytics | Portuguese | Power BI Metrics: Gerenciando KPI’s com o Power BI | Power BI Goals é uma poderosa feature para gerenciar KPI’s e incorporá-los nas suas análises e dashboards. Nesta sessão você vai descobrir como os Power BI Goals funcionam e como criar e integrar KPI’s em suas análises. | Watch Now |
| Denzil Ribeiro & Balmukund Lakhani | Industry Solution | English | Azure SQL DB Hyperscale – What’s new and Beyond | Azure SQL Hyperscale, the innovative architecture of Azure SQL Database, provides applications with scale and availability needed from a cloud database. In this session, we will discuss Hyperscale architecture, including new scalability improvements in the platform. We will also discuss recently released and upcoming features, and cover Hyperscale-specific diagnostics that help gain insights into system performance. | Watch Now |
| Des FitzGerald, Naveen Samba & Sumit Sarabhai | Architecture | English | SQL Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices | Come, Join this demo packed technical session from Data Engineers & Architects if you are looking to learn enterprise customer’s challenges, reusable IPs, & best practices modernizing SQL estate to Azure. Focus will be to share frequent complex issues, their resolution, perf optimization including tips to select right SQL service on Azure and rightsize the environment. | Watch Now |
| Dhananjay Mahajan | Data Administration | English | SQL MI on Kubernetes | Data-intense workloads are increasingly deployed on K8s. Arc data service uses the elasticity and high availability provided by K8s and extends it to run business critical databases like SQL. This session will give us a simple overview of K8s and tips/tricks to run Arc data services without requiring you to be an expert. This session will go into the architectural details to help administrators and developers understand how to get the most out of Azure Arc-enabled SQLMI | Watch Now |
| Dinakar Nethi | Data Administration | English | Multicloud and Hybrid readiness: Mission Critical capabilities from Azure-Arc enabled SQL Managed Instance – Part1 | Many enterprise are modernizing their mission critical applications, data and infrastructure to be cloud-enabled, while they develop newer applications for multicloud platform for resiliency, data sovereignty, compliance and latency. The session will help you understand capabilities of Azure Arc-enabled SQL Managed Instance. You will learn how to spin up an Azure Arc environment quickly to run on Kubernetes and deploy your SQL managed instance on any cloud. You will understand how to run your mission critical data with high availability and performance. We can show how developers use Azure portal and Azure to centrally update, monitor and backup/restore the data. | Watch Now |
| Dinakar Nethi | Data Administration | English | Multicloud and Hybrid readiness: Mission Critical capabilities from Azure-Arc enabled SQL Managed Instance – Part2 | Many enterprise are modernizing their mission critical applications, data and infrastructure to be cloud-enabled, while they develop newer applications for multicloud platform for resiliency, data sovereignty, compliance and latency. The session will help you understand capabilities of Azure Arc-enabled SQL Managed Instance. You will learn how to spin up an Azure Arc environment quickly to run on Kubernetes and deploy your SQL managed instance on any cloud. You will understand how to run your mission critical data with high availability and performance. We can show how developers use Azure portal and Azure to centrally update, monitor and backup/restore the data. | Watch Now |
| Diponkar Paul | Business Intelligence & Advanced Analytics | English | How to make sure sensitive data is secure in a modern Data Warehouse | The amount of structured, semi-structured, and unstructured data is growing at an exponential pace within organizations. With increased amounts of data and usage, inherently data security concerns grow. Cloud platform like Azure, Amazon, or Google promising organization data is almost impossible to hack. And if the data is leaked it will be encrypted so no one from outside the organization should be able to READ the data, claimed by these big vendors. However, there are security issues that can arise from rogue employees around PII data and there needs to be a process in place to deal with this. In this session, we will highlight how a modern data warehouse can act as a safeguard against malicious data exposure or misusage. As well as showcase different ways to protect PII data in both production and non-production environment and explore Microsoft Azure Synapse Analytics capabilities to protect sensitive data. | Watch Now |
| Doug Sillars | Data Administration | English | Managing Data Pipelines with Conductor | Data pipelines are a challenging part of working in data science. Netflix Conductor is a battle tested workflow orchestration tool invented at Netflix to automate millions of microservice workflows. Using a workflow tool like Conductor as a part of your data analysis pipeline can help streamline and improve the reproducibility of your results. In this presentation we will use Conductor to automate a set of microservices to build an automated workflow for a data pipeline workflow, automating the data acquisition, cleaning and analysis. | Watch Now |
| Dustin Dorsey & Gerald Hartley | Business Intelligence & Advanced Analytics | English | Modernizing Data Transformations with dbt | Data Build Tool (dbt) is a free and easy to use data transformation tool that is exploding in popularity, transforming the landscape of data and analytics platforms across the world. The Transformation (T) step in your Extract-Transform-Load (ETL) process can often be seen a bottleneck, requiring specialized skills, rigorous testing and an extensive deployment process to handle even minor changes. Dbt focuses on the Transformation step, making it super easy to transform data already in your database or data warehouse. No specialized skills required; all you need with dbt is to write a SELECT statement. In other words, dbt takes the SQL skills that data analysts are already comfortable with and enables them to build their own analytics engineering workflows. This session is intended for anyone new to dbt who wants to know if it is right fit for their organization. We will cover the dbt viewpoint, the fundamental uses of the tool, and demo several features so that you can get started right away creating automated analytics engineering workflows. | Watch Now |
| Dustin Vannoy | Business Intelligence & Advanced Analytics | English | Data Ingestion on Azure: Real-life scenarios and solutions | Data engineering involves more than just moving data around, but the data ingestion step is still critical to a successful data project. A foundation of the data lake or data warehouse is collecting and organizing the data. This typically involves a variety of sources each with different security or performance constraints. In this session we focus in on several common services for data ingestion and real use cases for each. We will walk through ingesting data from Azure Storage, SQL Server, APIs, and Event Hubs. We will use the best tool for each source which require using Synapse Pipelines, Synapse Serverless SQL, Synapse Spark, and Azure Databricks. | Watch Now |
| Dwayne McDaniel | Professional Development | English | What Git Metrics Can Tell You About Your Team | As Lord Kelvin said: “If you cannot measure it, you cannot improve it.”
It is vital to the success of every team that you have metrics and those metrics are simple to track. But what do you measure? For DevOps teams at least, the answer is more and more clear thanks to the work by Google Cloud’s DevOps Research and Assessment, also known as DORA. Even if you are not ready to take the full plunge to adopt all the practices and methodologies they prescribe, taking stock of the surprising amount of data that already exists around your DevOps practice is an incredible step towards building a more manageable team with overall better success. In this session we will cover: – Why DevOps success is hard to quantify – What the DORA team uncovered – How to do a base level assessment of your current path – What options exist to better capture data and tune your organizational practices |
Watch Now |
| Eason Lai | Data Science (AI/ML) | English | Building AI/ML model effectively with Microsoft AI solutions | The demand for AI/ML models and solutions keeps rising in the digital era. AI/ML models are infused into an entire digital transformation journey, from backend operation to front-end experience. But how do we effectively build AI/ML models to fulfill the demands? In this session, I will share how to leverage Microsoft AI & Platform solutions to build AI/ML models in an effective way. | Watch Now |
| Edward Pollack | Professional Development | English | Effective Public Speaking in Tech | Public speaking is a critical life skill that benefits anyone in any field. The ability to effectively communicate ideas in meetings, presentations, or interviews is necessary to make the most of our technical skills. The greatest ideas in history would have been meaningless if their inventors were unable to share them with others effectively.
In the world of tech, this skill is even more pronounced as the knowledge gap between what we do and how it appears to others is far greater. This session dives into public speaking, focusing on how we as technical experts can best improve and use this skill to its fullest. Tips, tricks, and best practices will be shared that will help make speaking an experience that is more fun and less scary. This is intended to feel more like a technical session, with demos and embarrassing stories to illustrate the importance of this topic. In addition, group facilitation skills will be discussed, focusing on the need to include audience engagement in any speaking endeavor. Knowing how to best gain and maintain the attention of a group is as important as speaking clearly and articulately. The scope of this session goes well beyond presenting sessions and will help in any scenario where information sharing with other team members, organizations, and even friends is involved. Level up your speaking skills here! |
Watch Now |
| Edward Pollack | Development | English | My Favorite New T-SQL in SQL Server 2022 | SQL Server 2022 adds a variety of new T-SQL functions, as well as some excellent upgrades to existing functions.
Want to generate a list on the fly without the need for a tally table? Tired of repeating window function syntax over and over? Ever wish you could return the MAX or MIN value from a set of columns? How about more easily generating starting points for date parts? This is a fast-paced, demo-filled party of new features that will save time, resources and make for cleaner and happier code! |
Watch Now |
| Eitan Blumin | Development | English | Troubleshooting Build and Deployment of SSDT Projects for SQL Server DevOps | You want to implement DevOps (or rather, DataOps) for your SQL Server database. So, you created a SQL Server Database Project in Visual Studio or VSCode using SSDT. Maybe you even have a CI/CD pipeline all ready to go…
But now, you’re starting to see all kinds of errors and problems that you’re not sure how to tackle. Maybe you have some kind of edge case in your target environment. Maybe you need to store something in your project and you don’t know how. Maybe you’re having trouble with your unit tests. Maybe your project can’t even be built properly without getting a bunch of errors. You’re starting to doubt… Was SSDT even the right choice?? CAN this even be done at all??? Join me in this important session for you to learn How To Do It Right. Based on my real-world experience of consulting and mentoring multiple organizations in their implementation of SQL Server DevOps. |
Watch Now |
| Erland Sommarskog | Data Administration | English | Deadlocks – Analysing, Preventing and Mitigating | Deadlocks happens in the best of families, and an occasional deadlock is nothing to be alarmed of. But too many deadlocks can hamper throughput or be irritating for the users who encounter them, and in this case you need to investigate the deadlocks to see how you can reduce the pain.
I start this session with discussing how you can get information about deadlocks. Next, I will go through the XML report for a deadlock and highlight things you should pay attention to. I the second half of the session, I will discuss various devices you can apply to prevent deadlocks. I will also discuss possible mitigations for deadlocks that are too difficult to prevent entirely. The topic of deadlocks is a complex one, so don’t expect to learn everything, but the hope is that this session will open your eyes for things to look out for, next time you have to analyse a deadlock. This is a level 300/400 session for developers and DBAs who need to perform troubleshooting in production systems. The session assumes that you have a basic understanding of locking in SQL Server. |
Watch Now |
| Fátima Blancas Velázquez & Ana María Bisbé York | Business Intelligence & Advanced Analytics | Spanish | Informes de indicadores clave en Power BI, una herramienta de crecimiento y colaboración | La sesión definirá cómo colaborar desde el Servicio Power BI para disponer de la información clave que permita identificar el estado de las métricas para tomar buenas decisiones y alcanzar los objetivos. Se indicarán las mejores prácticas para el consumo empresarial de datos, con ejemplos sobre cómo administrar la seguridad de los datos según las licencias de usuario en el servicio Power BI. Los asistentes aprenderán a compartir, comentar y combinar Power BI con M365 y MS Teams. | Watch Now |
| Florian Eiden | Business Intelligence & Advanced Analytics | English | You know SQL? Then you’re set for real-time data processing with Azure Stream Analytics | You know SQL? You need to process data in real time? Azure Stream Analytics (ASA) is the service for you. But let’s dig a bit deeper and understand what makes a streaming query in ASA different from a T-SQL one in SQL Server.
In this session we’ll start by a short introduction to stream processing and its typical applications like Streaming ETL or real-time dashboarding, Then we’ll focus on the 3 key aspects that we need to keep in mind when working on our streaming SQL queries in ASA. First we’ll talk data types. We’ll see how to best handle the complex ones (JSON nested records and array), but also that ASA applies types at the row level (which is both awesome and treacherous) and how to deal with it. Then we’ll discuss the temporal aspect of stream processing, in theory and how it’s implemented in ASA. That means time skew policies, windowing functions and how timestamps evolve as data flows through query steps. Finally we’ll have a performance conversation. We’ll see how partitioning a stream differs (or not) from partitioning a table. We’ll take a look at the metrics to monitor and how/when to scale an ASA job. |
Watch Now |
| Gaurav Malhotra | Business Intelligence & Advanced Analytics | English | Unified data governance with Microsoft Purview | In this session, Learn how to create a comprehensive, automated map of all your data, and see how Microsoft Purview data governance works with Azure Synapse Analytics, Power BI, and the rest of your hybrid data estate to deliver timely, reliable insights—with an overview followed by a deep dive into key topics and real companies’ experiences. | Watch Now |
| Gethyn Ellis | Professional Development | English | Build a Business: Using your technical skills to build your own business | Have you have wanted to run your own business? Work for yourself? Set your own agenda? Select the projects and even the clients that you work on? Then this session might be for you.
In this session, we will discuss what it takes for a person with outstanding technical skills to build a product or service around those skills to become a marketable product you can sell to clients. You can build a business. To build a business, let’s say it’s as an IT Contractor or consultant. You will need excellent technical skills; however, that’s probably not half the battle you will need to > Build and describe a product or service that solves a clients problem (Product Development) > Build a brand around you and your product/service, so people are aware that it exists (Marketing) > Talk to clients to understand what problems they are experiencing and how your product will help solve them. (Sales) >Produce a sales document that evidences how the services and products you supply solve clients problems (Sales) >Manage your time and resources to ensure that you deliver maximum value to your existing clients while continuing to find new clients (Business Management) It can be a rewarding and fun way to work if you do it right, and in this session, we’ll show how you can approach starting your own IT Contracting or Training business and hopefully help you build a successful business of your own. |
Watch Now |
| Gilbert Quevauvilliers | Business Intelligence & Advanced Analytics | English | How to use PowerShell to get data from any Power BI REST API | In this session I am going to demonstrate that PowerShell is not all that scary. I will show the users how to use PowerShell to connect to any Power BI REST API to quickly and easily download data. This data can then be used in a Power BI Report.
The concept I will demonstrate can be used repeatedly on any Power BI REST API. If time permits I will also show how to use more advanced concepts of looping through data. All the scripts will be available to be downloaded and used after the session. |
Watch Now |
| Gonzalo Bissio | Data Administration | English | Azure SQL Managed instance HA-DR Options to ensure business continuity | On this session we are going to talk about all the high availability and disaster recovery options in Azure SQL Managed Instance. Internals and demos are ensured! | Watch Now |
| Guy Glantser | Development | English | The Complete Guide to Temporary Tables and Table Variables | What should I use? A temporary table or a table variable? What’s the difference? What are the use cases for each one? How much impact does it have on performance? These are very common questions. In this session we will provide some surprising answers. This is a must session for every SQL Server developer. | Watch Now |
| Guy Glantser | Development | Hebrew | המדריך המלא לטבלאות זמניות (#) ומשתנים טבלאיים (@) | במה עדיף להשתמש? בטבלה זמנית או במשתנה טבלאי? מה ההבדלים ביניהם? באיזה מקרים עדיף להשתמש בכל אחד מהם? מה ההשפעה שלהם על ביצועים?
אלה שאלות מאוד נפוצות. ב-Session הזה נספק את כל התשובות (חלקן מפתיעות). זהו Session חובה לכל מפתח ב-SQL Server. |
Watch Now |
| Hariharan Rajendran | Business Intelligence & Advanced Analytics | English | SAP BO to Power BI Migration – Approach & Best Practices | This session is for Power BI Developers and SAP BO developers and BI architects.
In recent times, Power BI adoption keep increasing across organizations. Most of the organization are already started migrating their BI workloads into Power BI from their legacy BI platforms. I have involved multiple migration projects and most of them are SAP BO to Power BI. This session covers how you should approach the SAP BO migration to Power BI and how you can satisfy the business users by retaining the same functionality and experience in Power BI. Also, I will talk about how you can enhance your solution than legacy platform and some of the workarounds that you need in Power BI to match the SAP BO features. It covers all sort of options to help you to build the migration strategy to move your SAP BO reports to Power BI smoothly. |
Watch Now |
| Hasan Savran | Development | English | Performance tuning for Azure Cosmos DB | Azure Cosmos DB is a fully managed service that takes database administration off your hands. Fully Managed Database sounds good, but developers end up with some of the database administration work anyway.
As a developer, you will be responsible for changing Indexing policies, configuring connections to Cosmos DB, estimating the workloads, and selecting throughput options for containers. All these tasks determine your application performance and monthly Azure Cosmos DB bill. We will explore .NET/SDK settings, connection types, and indexing types to keep your application fast. Then we will focus on selecting correct throughput options, Query Execution Metrics, and using the right server-side programming to keep your Cosmos DB fast. Please join me as we explore how to keep your Azure Cosmos DB solutions fast. |
Watch Now |
| Heidi Hasting | Data Administration | English | Sensitivity labels – what do they look like | Like me you may have heard about sensitivity labels but what does that mean to your reports, data or documents. Some of the questions this session will answer;
– what do they look like in Power BI – what do they look like in Azure Purview – what do they look like in 0365 – how to maintain and manage them In this session we will go through setting up sensitivity labels and see them across multiple platforms ( Power BI, Azure Purview) |
Watch Now |
| Hugo Barona | Data Administration | English | Getting started building Data solutions on Azure | In this session, you will have an overview of the Data Services available on Azure and how you can use them in different scenarios. Also, you will see how to build a simple data solution using Azure Data services. | Watch Now |
| Indira Bandari | Data Science (AI/ML) | English | Python made easy for SQL Developers | Python is one of the valuable skills needed in these modern days if you want to become a data scientist.
In this session I will cover the basics libraries of Python that help in analyzing your data and also will do a comparison of what the equivalent is in SQL so that you can easily understand the commands. |
Watch Now |
| Inés Pascual Iglesias & Oscar Pérez Arauz | Business Intelligence & Advanced Analytics | Spanish | Herramienta Analytics en Power BI: Diferentes escenarios de aplicación | La herramienta Analytics que incluye Power BI permite ser utilizada en diferentes escenarios para la detección de anomalías, barras de error, tratamiento de cuadrantes, … que junto con la inclusión de parámetros What-If y el enriquecimiento de las visualizaciones a través de la utilización de Tooltips y Bookmarks se convierten en nuestros aliados para realizar un buen análisis de los datos. | Watch Now |
| James Broome | Business Intelligence & Advanced Analytics | English | Do those numbers look right? How to ensure quality, and avoid inaccuracies in your data insights. | The need to validate business rules and security boundaries within a data solution is important, as well as the need for ensuring that quality doesn’t regress over time as it evolves. Data insights are useless or even dangerous if they can’t be trusted, and in this session, James will explain how and why they should treated just like any other software project with respect to testing – by building automated quality gates into the end to end development process. During the session, he’ll walkthrough some practical examples and proven techniques around testing data solutions – including Power BI reports, Synapse Pipelines and interactive Spark notebooks. | Watch Now |
| Jasmin Azemović | Development | English | GDPR Ready Features in Azure SQL Database/SQL Server | The GDPR aims to improve the protection and management of users’ personal data. On the user side, private “more positive” legislation has not appeared for a long time. However, from the point of view of those who process the data, the situation is not so great. To do this properly, each organization needs to identify and document the locations where personal data is stored in existing databases and apply the GDPR. In cases where the system is in the early stages of development, identifying business processes that are subject to GDPR rules can help. However, when we talk about existing environments, it can be a great challenge from the practical and formally right side.
Azure SQL Database offers built-in mechanisms and tools that can help you ensure that all your data is GDPR compliant. Your only job is to use them in the right way. |
Watch Now |
| Jason Hunt | Professional Development | English | Lead from Where You Stand: How to influence as a middle level manager | Being a leader in the middle is tough. You often find yourself stuck between a rock and a hard place, trying to please your boss and make your direct reports happy. You have to translate what your senior leader wants into action, you have to work with other departments who may or may not like you, and people can go above your head because the buck doesn’t stop with you. It’s no wonder that middle-level leaders are one of the most stressed of all worker groups. In this highly engaging and relevant session, you’ll learn how to help lift your leader’s load, to get noticed for the great work you are doing, and what you can do to lead and empower your direct reports. Surely, you’ve got a difficult job, but with the right tools and strategies, you can learn how to succeed as a middle-level leader, leaving your working day satisfied that you are making a difference in your role and on the communities that you serve. | Watch Now |
| Javier Villegas | Data Administration | Spanish | Introduction a SQL Server 2022 | En esta sesión veremos todas las nuevas funcionalidades anunciadas en la versión preliminar de SQL Server 2022, enfocándonos especialmente en las mejoras relacionadas a Performance, Alta disponibilidad y Seguridad. | Watch Now |
| Jorge Maia & Rebeca Sousa | Development | English | IoT – Creating a Digital Twin with Azure | In this session, you will see how to develop a solution using Serverless, IoT Hub, and IoT Edge to create a Digital Twin with the Azure Digital Twins.
From the computing on the edge and data path in the cloud, we will present all the components needed to develop the solution, step-by-step integrations as well as the pitfalls that we had in other projects like this. |
Watch Now |
| Jorge Maia & Rebeca Sousa | Architecture | Portuguese | Azure IoT – Como substituir o Time Series Insights? | Com a aposentadoria anunciada do Time Series Insights, qual o melhor caminho para seus dados em projetos de IoT?
Nesta sessão vamos demonstrar como você pode utilizar outros recursos e quais os desafios. |
Watch Now |
| Josephine Bush | Data Administration | English | Handle Azure SQL Auditing with Ease | Are you tired of not knowing who’s changing what in your Azure SQL databases?
To audit Azure SQL Database, you can use the built-in functionality in the Azure portal or with Extended Events; to audit Azure SQL Managed Instance, you can use SQL Server Audit or Extended Events. With auditing, you can track changes, report on usage to auditors, or change user permissions/passwords without breaking functionality. In this session, you will get an overview, different options available, and a demo. You will also learn how to centralize and report on your auditing data. Auditing is a key part of any proper database setup, and with this session, you can be an auditing pro in no time! |
Watch Now |
| Jungsun Kim | Data Administration | Korean | SQL Server 2017&2019 Intelligent Query Processing 실무 사례 | It covers the benefits and disadvantages of the practical cases of Intelligent Query Processing newly introduced in SQL Server 2017&2019 and deals with important considerations when upgrading SQL Server.
In addition, we will briefly introduce more intelligent Query Processing features added in SQL Server 2022. Korean Version) SQL Server 2017&2019에 새로 도입된 Intelligent Query Processing의 실제 사례를 통해 그 이득과 주의사항들을 알아보고, SQL Server를 업그레이드할 때 중요한 고려 사항을 다룹니다. 또한 SQL Server 2022에 추가된 보다 똑똑해진 Query Processing 기능들도 간략하게 소개합니다. |
Watch Now |
| Kate Smith, Derek Wilson & David Pless | Data Administration | English | SQL Server 2022 IQP Deep Drive | Intelligent query processing is a key component to help business-critical workloads improve when running at scale, while remaining adaptive to the constantly changing world of data.
In this session we will cover how the latest SQL Server versions improve performance with features and enhancements under the intelligent database feature family. These features include query store and intelligent query processing that helps improves performance and scalability with minimal changes to your application or database design. We will cover the scenarios where intelligent query processing can have the most benefit for your application workloads and how Query Store can help make it easier to identify poorly performing statements and respond to regression scenarios. We will cover Query Store use cases such as Query Store internals, performance regressions, and improvements in the latest versions of SQL Server including the new Query Store Hints improvement. |
Watch Now |
| Kevin Chant & Sander Stad | Development | English | Unleash the testing of your CI/CD pipelines for SQL Server deployments in Azure DevOps | In this session we will cover go through the different ways you can test SQL Server deployments at various stages. We show you how you can unleash the CI/CD capabilities without the need of any spreadsheets.
During the session we will cover how to use tSQLt and Test Plans within Azure DevOps. Going deeper into tSQLt and Azure Test Plans than before. By the end of this session you will have gained knowledge on how to implement testing at different stages of your deployments. |
Watch Now |
| Kevin Feasel | Business Intelligence & Advanced Analytics | English | Building Your First Data Pipeline in Apache Spark | As a data engineer, the Apache Spark platform provides a great deal of functionality designed to solve common problems around data movement and processing, particularly in the cloud. In this session, we will learn how to use Apache Spark in Microsoft Azure. We will see which Azure services provide Apache Spark integration points, look at use cases in which Apache Spark is a great choice, and use the metaphor of the data pipeline to perform data movement and transformation in the cloud. We will additionally learn how to use notebook workflows in Azure Databricks to simplify the process. | Watch Now |
| Leila Etaati | Data Science (AI/ML) | English | AI Fundamental examp Prepration | In this session an overivew on materials and concepts for Azure Ai fundamental exam will provided, from AI responsible, to Cognitive service and how to call them inside Azure ML notbook, an overview on Azure ML workspace and Azure ML SDK also presented | Watch Now |
| Leo Li | Development | English | Managed VNET in Cloud Scale Analytics: What’s New & Best Practices | Join this session to learn about the latest enhancements being made to Managed VNET in cloud scale analytics. | Watch Now |
| Leonard Lobel | Data Administration | English | Securing Azure Cosmos DB | Every database needs to be secured, and Azure Cosmos DB provides enterprise-class security features to make certain that all your data is fully protected. In this session, you’ll learn how to setup network security – the first line of defense against any unauthorized access. We’ll cover the IP firewall and VNet access using service endpoints, plus how to enable private endpoints for a solution that’s completely isolated from the public internet. We’ll then move on to authentication options using master keys, resource tokens, and Azure Active Directory integration. Finally, we’ll look at built-in server-side encryption using Microsoft managed keys and customer managed keys, plus client-side encryption which ensures that highly sensitive data is always encrypted, and accessible only through applications that you approve. Attend this session and arm yourself with the skills you need to secure your database in Azure Cosmos DB!
Goals • Implement network security with the IP firewall, VNet access, and private endpoints • Understand the various authentication options using master keys, resource tokens and Azure AD integration • Learn about built-in server-side encryption, and how to configure client-side encryption using Always Encrypted |
Watch Now |
| Leonardo Fonseca & Sulamita Dantas | Data Administration | Portuguese | Como reduzir custos do seu SQL Database no Azure | Sabemos que um dos maiores custos em nuvem são relacionados à Bancos de Dados. Nessa palestra vamos compartilhar como analisar se o seu banco está na camada de preços ideal e como criar uma automação para redução de custos dentro do Azure. | Watch Now |
| Madhumita Tripathy & Anton Fritz | Data Administration | English | How to protect your data when it travels from Azure Synapse to PowerBI and to office | Join this session to understand how you can leverage Microsoft Purview Information Protection capability to classify sensitive information in Azure Synapse, Azure SQL, SQL on-prem and then how these protection lebels travel to PowerBI & to Office 365 applications. | Watch Now |
| Magnus Ahlkvist | Development | English | Everything you need to know about Temporal Tables | Temporal Tables (or system versioned tables) were introduced in SQL Server 2016 as a way to automatically version rows within a table.
In this session I will present: – Create a new table which is system versioned – Start system versioning on existing tables. – Transform a main/history-table pair from application versioned to system versioned. – How to query using the SYSTEM TIME AS OF extensions to SELECT queires. – How to use the Row Start and Row End attributes for delta loads into a data warehouse. – How to load Type 2 Slowly Changing Dimensions using system versioned tables – Performance considerations for your history table. |
Watch Now |
| Manish Sharma & Sandeep Nair | Data Administration | English | Synapse Link for Cosmos DB Best practices | In this session you will learn what are the best practices to implement a successful analytical solution using your Cosmos DB data at no RUs cost. From data modeling to SQL serverless and Spark configurations, this session will cover everything you need to do to achieve good and scalable performance. | Watch Now |
| Marcelo Adade | Architecture | English | Using Apache Kafka to replicate data from Postgres to SQL SERVER | Ever needed to replicate data from a RDBMs into SQL SERVER and have updates on the destination datastore in near real time? With the amount of options we have today to build an Enterprise Datawarehouse this can be a very challenging task. As a Data Professional you need to be able to choose the right tools to move data around the many different Datastores that your company adopts. In this session we will focus on how to bring data from a Postgres database into a SQL SERVER database using a typical Big Data realm tool: Apache Kafka. | Watch Now |
| Marco Parenzan | Business Intelligence & Advanced Analytics | English | Power BI Streaming DataFlow and Azure IoT Central | Since 2015 Power BI users have been able to analyze data in real-time thanks to integration with other Microsoft products and services. With streaming dataflow, the analysis will be carried out in real time completely from the inside of Power BI, removing most of the restrictions we have, integrating in the meantime key analysis functionality such as the preparation of data in streaming and no code creation. To see it in action, we will study a specific case of streaming such as IoT with Azure IoT Central. | Watch Now |
| Mark Kromer | Development | English | What’s New in Azure Data Factory | Azure Data Factory is Azure’s cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management. Join this session to learn what’s news with Azure Data Factory, and resources to help you get started, and be productive with ADF. | Watch Now |
| Markus Ehrenmüller-Jensen | Business Intelligence & Advanced Analytics | English | 5 Things you can do with Power BI Report Builder | … but not with Power BI Desktop. There is life in the old dog yet! SQL Server Report Server’s Report Builder is having it’s revival as Power BI Report Builder recently. As a product which had years to mature, it still has features yet missed in it’s younger brother Power BI Desktop.
When you ever faced one of these problems in Power BI Desktop, then you should make sure to not miss this session: • Exporting of visuals, which span more than the size of one page • Adding a “Print” button to your reports • Use an expression to set the default value for a filter • Dynamically show & hide portions of a report • Re-use code via functions and sub-reports • Live-connection to more than one Power BI dataset |
Watch Now |
| Markus Ehrenmüller-Jensen | Business Intelligence & Advanced Analytics | German | 5 Dinge, die man mit Power BI Report Builder machen kann | … aber nicht mit Power BI Desktop. Totgesagte leben länger: SQL Server Report Server’s Report Builder erlebt seit kurzem seinen zweiten Frühling als Power BI Report Builder. Dieses ausgereifte Werkzeug hat immer noch Funktionen, die man in seinem jüngeren Bruder Power BI Desktop vergeblich sucht.
Sollten Sie schon einmal auf eines der folgenden Probleme gestoßen sein, dann sollten Sie diesen Vortrag nicht versäumen: • Exportieren einer formatierten Datei mit mehreren Seiten • Einen “Print”-Knopf zu einem Bericht hinzufügen • Einen Ausdruck als Standardwert für einen Filter verwenden • Dynamisch Teile eines Berichtes zeigen oder verstecken • Funktionen und Unterberichten wiederverwenden • Live-connection zu mehr als einem Power BI Dataset |
Watch Now |
| Daniel Coelho | Development | English | An in-depth look into Azure Synapse Spark | In this session, prepare to get an in-depth look into Synapse Spark to gain an understanding on how to maximize your performance for your workload. Learn more about Autoscale, Delta, and the latest features to gain an understanding of when and where to apply them. | Watch Now |
| Mathias Thierbach | Business Intelligence & Advanced Analytics | English | The internals of a PBIX file and how pbi-tools helps make sense of it all | The PBIX file is the fundamental building block when it comes to Power BI development. You may have heard that PBIX files are simply ZIP files with an internal file structure, however, very little is publicly known beyond that.
Mathias, for his work on pbi-tools, has spent years deciphering the (undocumented) PBIX internals. Those efforts have led to pbi-tools, today the only end-to-end source control solution for Power BI development. This session will explain what’s inside a PBIX file and how everything is linked together. Using the folder structure view of a PBIX file provided by pbi-tools, all of the components (Model, Report, Queries, Resources, Settings) will be looked at in detail. You will understand how to track changes made to a PBIX file using Power BI Desktop, what those changes mean, and how to apply similar changes offline, targeting the pbi-tools folder structure only. Using that understanding, the session will further look into more advanced automation scenarios which become viable once the PBIX internals are known and provide various examples. This session is likely to inspire you to take your Power BI projects to new levels of automation! |
Watch Now |
| Michelle Gutzait | Business Intelligence & Advanced Analytics | English | Set up your data and Azure Synapse in minutes and start analyzing your data immediately! | In this session, Michelle will show you how to push your existing data from your relational databases and files to the Azure Data Lake storage, set up Azure Synapse Analytics workspace and start exploring your data immediately! | Watch Now |
| Miguel Félix | Business Intelligence & Advanced Analytics | Portuguese | Questões comuns em DAX e como resolvê-las | Na utilização do Power BI surgem muitas questões, especialmente no que diz respeito ao DAX e chegamos a conclusão que o DAX é simples mas não é fácil. Na comunidade, todos os dias surgem novas questões sendo que algumas são recorrentes e, nesta sessão, vamos falar sobre algumas das questões mais comuns da comunidade e como podemos resolvê-las. | Watch Now |
| Mikey Bronowski | Data Administration | English | Azure Elastic Jobs – PowerShell edition | Azure Elastic Jobs are (still) preview feature, but can help you translate what SQL Agent does for on-premisses databases to your Azure SQL. This session won’t look into the Azure Portal though, it will be purely in PowerShell usin Az PowerShell module and some dbatools. | Watch Now |
| Milos Radivojevic | Development | English | Let’s Tune Together! | In this interactive session, we will work together to improve performance of different Transact-SQL queries.
You will see many bad designed queries leading to poor execution plans, and by using different techniques and tricks, we’ll help the query optimizer to make better ones. And all this very quickly, in a single or a few steps. It will be interactive, useful, and funny. I am looking forward tuning queries with you! |
Watch Now |
| Milos Radivojevic | Development | German | Intelligente Abfrageverarbeitung in SQL Server | Die Neuerungen aus dem SQL Server 2019 Feature mit dem vielversprechendsten Namen – Intelligent Query Processing sehen wirklich toll aus. Einige ermöglichen dem Query Optimizer bessere Ausführungspläne zu generieren, die andere korrigieren die Pläne zur Laufzeit nach.
Es werden die wichtigste Features aus dem Box demonstriert: Batch and Row Mode Memory Grant Feedback, Batch Mode Adaptive Join, Batch Mode Rowstore, Table Variable Deferred Compilation und Scalar UDF Inlining. Die Session wird sich auch mit den folgenden Fragen befassen: – Wie viele Verbesserungen soll man von diesem vielversprechenden Satz von Funktionen bei realen Workloads erwarten? – Welche Abfrage muss ich nicht mehr tunen? – Bei welchen Abfragen soll man eine deutliche Performancesteigerung ohne Codeänderungen erwarten? – Besteht die Gefahr von Performance-Regressions? – Ist nun das Parameter Sniffing Problem behoben? Zum Abschluss der Session werden wir einen kurzen Blick auf die geplanten Verbesserungen und Neuerungen in SQL Server 2022 werfen. |
Watch Now |
| Morgan Oslake | Industry Solution | English | Compute auto-scaling using serverless in Azure SQL Database | Serverless in Azure SQL Database optimizes price-performance for databases with unpredictable and intermittent usage patterns. Extension of support for serverless to the Hyperscale tier in SQL DB enables native auto-scaling of compute for workloads requiring more storage or IO performance, read-scale out, or HA configuration flexibility among other benefits not available in the General Purpose tier. Join this session to learn about serverless for Hyperscale. | Watch Now |
| Mukesh Kumar, Ashish Khandelwal & Amethyst Solomon | Architecture | English | Mainframe/Midrange to Azure Data Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices | Learn from Mainframe and Data platform engineers in this demo packed session to find out how to execute a data first modernization strategy for mainframe and midrange systems. Learn about the Microsoft products, custom IPs, ISV tools, and engineering led support to implement this at your organization. Assess your workload, identify the complexity, and learn how to perform data migration, data ingestion, data replication, data integration and data co-existence. | Watch Now |
| Mukesh Kumar, Narendra Angange & Kapil Samant | Architecture | English | Oracle to SQL/PostgreSQL Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices | Come, Join this demo packed technical session from Data Engineers & Architects if you are looking to learn enterprise customer’s challenges, reusable IPs, & best practices modernizing Oracle estate to Azure. Focus will be to share frequent complex issues, their resolution, perf optimization including tips to select right SQL service on Azure and rightsize the environment. | Watch Now |
| Namrata Sherkhane | Data Science (AI/ML) | English | Customer Use cases on latest Azure AI Services | Detail discussion on how Azure AI services have solved real world customer challenges. Case studies on digital document processing , IVR chat bot etc | Watch Now |
| Nellie Gustafsson & Mark Hamilton | Data Science (AI/ML) | English | Massively scalable machine learning on Spark with Synapse ML | SynapseML (Previously MMLSpark) is an open-source library, aiming to simplify the creation of massively scalable machine learning pipelines. Composing tools from different ecosystems often requires considerable “glue” code, and many frameworks aren’t designed with thousand-machine elastic clusters in mind. SynapseML resolves this challenge by unifying several existing ML frameworks and new Microsoft algorithms in a single, scalable API that’s usable across Python, R, Scala, and Java. This session will provide an overview of these features, a demonstration, and resources to learn more. | Watch Now |
| Nicolas Nakasone | Architecture | Spanish | Arquitecturas Recomendadas de Data Analitica en Cloud | Ante el advenimiento del Cloud, las arquitecturas de Data y Analitica han cambiado, descubre todo lo que debes saber antes de emprender un proyecto de Data Analtica en la nube. | Watch Now |
| Niels Berglund | Development | English | ksqlDB – The Real-Time Streaming Database | More and more organizations are moving towards an event-driven, real-time streaming architecture, using Apache Kafka as their streaming backbone. Having event streaming applications allows these organizations to unlock new benefits by combining various data feeds.
However, getting actionable insights in a timely fashion has remained a challenge as to how do you query streaming data? ksqlDB solves this by providing an interactive SQL interface allowing you to, in real-time, query the streaming data, doing aggregations, in essence treating the data as it was data persisted in a database. This demo-filled session will look at how to: * execute ksqlDB push/pull queries * create ksqlDB User Defined Functions * use table and streams |
Watch Now |
| Nikita Takru | Data Administration | English | What is Azure Arc-enabled data services | Imagine running an Azure service on-premises or in another cloud…too good to be true? No! With Azure Arc-enabled Data Services, you can run Azure managed data services anywhere! Bringing a managed offering into the infrastructure of your choice brings benefits such as: built-in services like high availability, automatic backups, and point-in-time restore; an always-current database engine; and consistent database features and administration across environments. Join this session to learn the architecture of Arc-enabled Data Services, how to run SQL Managed Instance on it, and common use cases for this exciting new offering! | Watch Now |
| Niko Neugebauer & Uros Randjelovic | Data Administration | English | Azure Sql Managed Instance – the future of flexible cloud-based data centers | In a world where we’re faced with ever increasing workloads and a constant pressure to decrease costs it was never more important to enjoy maximum flexibility. SQL Managed instance with a new set of features including cross subnet move, start stop and preprovisioning gives you the necessary flexibility and prepares you for the future workloads. | Watch Now |
| Niko Neugebauer, Zoran Rilak & Mladen Andzic | Architecture | English | Cost optimization for workloads on Azure SQL Managed Instance | Cost savings make cloud and PaaS attractive options; however, the structure of costs in the cloud is different from the traditional on-prem model. To get the most value for the price, it is important to understand how cloud services operate, how their offerings are structured and priced, and what options exist to optimize the cost according to the workloads. This session will focus on cost optimization in Azure SQL Managed Instance. We will cover the key benefits of PaaS SQL, server consolidation, service tiers, configuration options to right-size cloud resources, SQL licensing, cost monitoring, and tools that can help you along the way. | Watch Now |
| Nikola Ilic | Business Intelligence & Advanced Analytics | English | Crash course on Data Visualization in Power BI! | You’ve connected to a data source and imported data into Power BI – now what? You need to display the information to users in the most effective way!
Is 40 million of revenue good or bad? Are your visuals equally accessible to anyone? How to display detailed data, or highlight important points? In this session, we’ll examine different ways of (mis)representing data in your visuals. You’ll understand why context is the key, how to choose the appropriate visualization type for certain business scenarios, and how to configure and format visualizations to provide additional value to your Power BI reports. |
Watch Now |
| Nikola Ilic | Business Intelligence & Advanced Analytics | Serbian | Brzi kurs za vizualizaciju podataka u Power BI! | Povezali ste se na izvor podataka i uvezli podatke u Power BI – šta sad? Treba da prikažete informacije korisnicima na najefikasniji način!
Da li je obrt od 40 miliona dobar ili loš? Da li su vizuelizacije podjednako pristupačne svima? Kako da prikažete detaljne podatke, ili kako da naglasite važne tačke? Toko move prezentacije, razmotrićemo različite načine (ne)prikazivanja podataka u vizuelizacijama. Shvatićete zašto je kontekst od ključne važnosti, kako da odaberete odgovarajući tip vizuelizacije za odredjeni biznis scenario, i kako da konfigurišete i formatirate vizuelizacije da bi vaši Power BI izveštaji dobili dodatno na vrednosti. |
Watch Now |
| Nuno Árias Silva | Student Track | Portuguese | Introdução ao Power BI | Uma introdução do que é PowerBI com arquitetura, o que é possível fazer e possibilidades de ter uma visão do seu negócio e da sua empresa | Watch Now |
| Ola Hallengren | Data Administration | English | Query Store In-Depth | Query Store has become one of the most important tools for troubleshooting performance problems.
In this session I will share my experiences about how Query Store is working in different scenarios. We will also look at some real-world cases. Finally, we will look at how you can use PowerBI and PowerPivot to analyze the data from Query Store. |
Watch Now |
| Oskari Heikkinen | Architecture | English | Best Practices for building a Data Lake with Azure Databricks | Databricks is a Unified Analytics Platform making it easier than ever to do big data analytics on cloud. However, there are a lot of things you need to know and take into account before diving head first into a Data Lake. This session is intended for architects and developers who are looking to build a massive scale data storing and processing solution. I will go through the Best Practices for the purpose. In addition, I will demonstrate how to unify real-time and batch processing using Azure Databricks. | Watch Now |
| Parv Chana | Business Intelligence & Advanced Analytics | English | Calculation Group – Best Practices and avoid Pitfalls | Calculation Group in Power BI is very powerful, allows to avoid clutters by writing tons of measures, ability to mix data formatting but at the same time, if no close attention is paid, you can get unexpected results.
In this session, we will go over multiple uses of Calculation Groups and also how to avoid common mistakes when working with Calculation Groups. |
Watch Now |
| Paul Ou Yang | Data Administration | English | Automating TPC-C Tests with HammerdDB and PowerShell | Doing load testing is time consuming because we need to repeat the same tests, changing one of the variables until we reach resource saturation. HammerDB and PowerShell make it easier. HammerDB is a leading open-source benchmarking tool for databases. PowerShell allows you to easily wrap HammerDB commands to be like cmdlets with an output that can be piped to other cmdlets, thus simplifying the tedious process of load testing. This session is a real-world scenario of how to use the PowerShell Crescendo module and fully automate HammerDB TPC-C tests for SQL Server. | Watch Now |
| Pedro Reis | Business Intelligence & Advanced Analytics | Portuguese | Power BI Metrics: The Ultimate Piece for Top Management | During this session, you will see a complete Demo of Power BI Scorecards.
You will quickly understand how to create, leverage its power, and a strategy for pitching to Top Management for success and adoption. You will also get to know licensing considerations, report building considerations, current limitations, and roadmap. – |
Watch Now |
| Perry Skountrianos & Kendal Van Dyke | Data Administration | English | SQL Server 2022 “Goodies” | With over 70 new features coming in SQL Server 2022, there’s a lot to get excited about! You’ve heard about the “meat and potatoes” features like Azure connectivity, IQP NextGen, and Contained Availability Groups. In this session, we’ll cover additional features and capabilities (“goodies”) that help SQL Server run faster, make it easier to manage, and simplify development, including: Accelerated Database Recovery (ADR) improvements, T-SQL Snapshot Backups, Time Series and T-SQL improvements, and a bevy of smaller improvements to get you even more excited for GA! | Watch Now |
| Pieter Vanhove | Architecture | English | Protect your data from tampering with Ledger | Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is a new feature in Azure SQL and SQL Server that incorporates blockchain crypto technologies into the RDBMS to ensure the data stored in a database is tamper evident. Ledger introduces ledger tables that make data tampering easy to detect.
In this session, we will cover • The basic concepts of Ledger and how it works • Ledger Tables • Digest management and database verification After completing this session, you will understand how Ledger works and how it can help to protect sensitive data. |
Watch Now |
| Pragati Jain | Business Intelligence & Advanced Analytics | English | Power BI & Azure Databricks – A Magical Union | Azure Databricks is a powerful technology that is used by both Data Engineers and Data Scientists to perform their jobs. On one hand Data Engineers use it to transform and structure data, on the other hand Data Scientists use this transformed data to do advanced analytics.
But what about the business users, who in real life need to see this data in an easier way to generate actionable insights in their day-to-day life? Apart from Data Engineers and Data Scientists, we do have a league of people who want to generate insights from this data. Azure Databricks platform can’t be used by business users, marketing people, etc. In order to make their life easier, we can now use the data from Azure Databricks within a powerful visualization tool like Microsoft Power BI; and further help the end-users to leverage the benefit of this data and generate insights based on their requirements. In this session today, we will see how we can quickly bring in the transformed data from Azure Databricks to Microsoft Power BI, and further generate beautiful visualizations to generate insights. We will further explore how easy it is to drag and drop data points to different type of charts/visuals and make them pretty with few clicks. The session will help the audience in understanding how a magic is created when Azure Databricks meets with Microsoft Power BI. |
Watch Now |
| Priyanka Shah | Data Science (AI/ML) | English | Machine learning on IoT with SQL Edge | Azure SQL Edge is an optimized relational database engine geared for IoT and IoT Edge deployments. It provides capabilities to create a high-performance data storage and processing layer for IoT applications and solutions. Azure SQL Edge provides capabilities to stream, process, and analyze relational and non-relational such as JSON, graph and time-series data, which makes it the right choice for a variety of modern IoT applications. Azure SQL Edge provides built-in machine learning and analytics capabilities by integrating the open format ONNX (Open Neural Network Exchange) runtime, which allows exchange of deep learning and neural network models between different frameworks. In this session let us see how to deploy and use a liner regression model for prediction of rental prices of houses using ONNX and SQL Edge | Watch Now |
| Rahul Saha & Neil DSouza | Architecture | English | Building fault tolerant applications with Azure Database for MySQL | Azure Database for MySQL is a fast, reliant, secure MySQL database as a service that lets customers build fault tolerant applications, in this talk we will talk about best practices on deploying fault- tolerant applications across multiple AZs in a region and globally distributed applications across regions | Watch Now |
| Rajendra Ongole | Business Intelligence & Advanced Analytics | English | Dynamically Select the category using Line chart in Power BI | Rather using legend for data segregation, we can dynamically select two different category to observe the trend over the period of time. | Watch Now |
| Reid Havens | Business Intelligence & Advanced Analytics | English | How to Fix a Report I Didn’t Build – An Ugly Baby Story | As a Power BI Developer, many of us have had to take ownership of a report that we didn’t author, often with little to no documentation! This session will provide a best practices toolset to help audit, repair, and optimize the PBIX file. You will learn how to identify common pitfalls in: Power Query queries, modeling, relationships, DAX, and report design. The resulting report will have a reduced file size, load and calculate faster, and provide a cleaner U/I experience for end-users. | Watch Now |
| Renato Haddad | Business Intelligence & Advanced Analytics | Portuguese | Dicas e Truques de Formatação Condicional no Power BI | Nesta palestra Renato mostrará como aplicar formatação condicional de diversas formas, em diversos objetos gráficos, usando DAX, a fim de deixar o visual dos gráficos mais atrativos e de fácil entendimento no Power BI | Watch Now |
| Richa Gaur | Data Administration | English | How to model and partition data in Azure Cosmos DB to achieve cloud scale | The era of cloud computing has ushered in a new era where applications now demand unprecedented levels of scale and size. Relational databases which have been with us for 50 years were never designed to ingest vast quantities of data per second, grow to Petabytes in size, or provide 99.999% availability. Enter distributed NoSQL databases which were designed specifically to deal with these and other unique challenges brought about by the cloud.
In this session we will take the relational data model for a simple e-commerce application and migrate it to a horizontally partitioned, NoSQL database. Along the way you will learn the concepts, techniques and technologies needed to model for a horizontally partitioned NoSQL database that will allow your application to achieve millisecond response times with near unlimited size and scalability. |
Watch Now |
| Richard Conway & Pablo Cabeza | Data Administration | English | Extending data governance for the enterprise with Azure Purview | Data Governance is the new frontier for any business to gain control and accountability of their data processes. With the vast amounts of data produced and consumed and new laws like GDPR in Europe and CCPA in the US, it is an imperative to have a well defined governance process.
Azure Purview is a unified and cloud native one stop solution for governance that Microsoft released to start addressing the governance issues from the enterprise. It allows mapping of cloud and on-premise sources to automatically discover data, sensitive data classification, lineage tracking and glossary management. In this demo-heavy session we’ll go beyond the docs and show you to extend Purview capabilities. Whether you want to use to track lineage of unsupported data sources or you want to extend the Purview type system with your own custom metadata we’ll show you how to build full end-to-end workflows that extend the functionality of out-of-the-box Purview features. We’ll go into depth on using Apache Atlas, the underlying store for data lineage and all associated metadata and how you can use APIs and undocumented features to customise your data governance at enterprise scale. After this session, we hope you understand better what Purview can provide for your Governance solution, and how to adapt it and make it your own for your data platforms and data governance challenges at enterprise scale. |
Watch Now |
| Rob Richardson | Data Administration | English | A Database DevOps Pipeline | Are your automation practices accounting for the database? How do you verify database software quality? Most importantly, how do you care for customer data as the schema evolves? Let’s dig into building a CI/CD pipeline for databases. We’ll leverage Red Gate tools and containers for automation, testing, and push-button deployment. You can bring DevOps to the database. | Watch Now |
| Rohit Nayak, Sranavi Saluru & Madhumita Tripathy | Architecture | English | Protect your data in the cloud with the latest security enhancements for Azure SQL | Join this session to learn about the latest security enhancements in Azure SQL. The session will include an overview of the breadth of security capabilities available in Azure SQL, with a focus on new and upcoming investments in authentication, encryption, networking and more, with demos of the new capabilities in action. | Watch Now |
| Ron Dagdag | Data Science (AI/ML) | English | AI to the edge with Azure Percept | AI enabled IoT creates intelligent machines that simulate smart behavior and supports in decision making with little or no human interference. Attend this session to learn about using machine learning to train custom object detection model, use Azure Percept to collect data, deploy model and manage edge device. | Watch Now |
| Ruben Pertusa Lopez | Business Intelligence & Advanced Analytics | Spanish | Curvas de retencion, DAU, MAU y más metricas DAX de marketing digital en Power BI desde cero | Todos nos hemos visto ante la necesidad de entender cómo se estan comportando los usuarios, cuál es la experiencia al navegar por nuestra solución, dónde mejorar, y sobre todo, cual es el Retorno de la inversión de lo que estamos haciendo.
En este caso práctico crearemos un Dashboard con métricas para el analisis del “engagement” de los usuarios ( DAU,MAU, ratios, curvas de retención) desde cero. Entendiendo la problematica y como llegamos a la solución con DAX. Y todo esto usando también DAX Studio, Tabular editor y el resto de herramientas del ecosistema Power BI. Además daremos algunas ideas sobre como medir ROI mendiante ellos. |
Watch Now |
| Sagar Sumit | Architecture | English | Intelligent Lakehouse: Think Beyond Transactional Data Lake with Apache Hudi | Abstract
The rise of cloud computing, decoupling of storage and compute, and the need to store and process large amounts of unstructured or semi-structured data led to the data lake movement a decade ago. And yet the promise of that movement has been unfulfilled. The lack of transaction and its isolation in the data lake forced users to maintain both a lake and data warehouse in their data architecture. As if that was not enough, the problem of data quality and governance has grown with the data lake movement. To bridge some of these gaps, Apache Hudi, created in 2016 at Uber, pioneered the modern transactional data lake, aka lakehouse, architecture movement. In this session, we will discuss the design of an embedded database kernel that is Hudi, and how it unlocks transactional updates/deletes with tunable concurrency control and incremental change streams from tables directly on lake storage. Then, we will go one step beyond and discuss what it takes to build a lake that is not only transactional but also intelligent. With its rich set of table services and indexing schemes to offer the advantage of data locality, Hudi attempts to balance the tradeoff between incremental ingestion and query latency in a novel way. Today, Hudi already powers data lakes of varying scales from a few terabytes to exabytes. |
Watch Now |
| Sai Kondapalli | Industry Solution | English | Scale out database write performance in Azure Database for MySQL | Join this session to learn how to improve write scalability in Azure Database for MySQL using Vitess as a sharding solution to segregate writes amongst different nodes. | Watch Now |
| Sandra Marin | Professional Development | English | Ask the Expert: Get Microsoft Certified | Microsoft has certifications for many technical job roles. And upon earning a certification, 61% of tech professionals say they earned a promotion. Join this session to learn about the process of certification and why you should take the steps to get certified. | Watch Now |
| Sandra Marin & James Herring | Data Administration | English | Prep for Exam DP- 203 and the Azure Data Engineer Associate Certification | In this session we will review your path to Microsoft Certified: Data Engineering on Microsoft Azure. We will check out what is covered on Exam DP-203 and which concepts to prioritize for further study. You will also receive resources to help you prepare for certification. | Watch Now |
| Sandra Marin & Juliane Padrao | Data Administration | English | Prep for Exam DP-300 and the Azure Database Administrator Associate Certification | In this session we will review your path to Microsoft Certified: Azure Database Administrator Associate. We will check out what is covered on Exam DP-300 and which concepts to prioritize for further study. You will also receive resources to help you prepare for certification. | Watch Now |
| Sandra Marin & Shannon Linsday | Business Intelligence & Advanced Analytics | English | Prep for Exam DP-500 and the Azure Enterprise Data Analyst Associate Certification | In this session we will review your path to Microsoft Certified: Azure Enterprise Data Analyst Associate. We will check out what is covered on Exam DP-500 and which concepts to prioritize for further study. You will also receive resources to help you prepare for certification. | Watch Now |
| Sanil Mhatre | Data Science (AI/ML) | English | Topic Modeling made easy | Is your organization looking to unlock valuable insights for large amounts of text data for sources like social media posts, product reviews and survey results ? Have you already tried techniques like key words/phrases, sentiment analysis or word cloud, but are looking for deeper insights ? Topic modeling will elevate your Natural Language processing/Text Analytics to the next level and help your organization discover valuable business insights.
This demo filled session uses a real life use case of Team Health Survey data to introduce attendees to the concepts , tools and techniques of topic modeling. Using Jupyter notebook, we will walk through the python code demo for ; • Data loading, clean-up and pre-processing • Tokenization, Stop words, n-grams and lemmatization • Iterate through model training and evaluation • Visualize output and interpret human readable topics • Business value and application of topic modeling |
Watch Now |
| Sascha Lorenz | Development | English | Development with Go for SQL Server 101 | Go (also known as Golang) is the language in which Docker and Kubernetes were developed. As one of the most popular trending programming languages in recent years, virtually everyone has heard of it.
In this session, you will learn compactly the essential basics and concepts of the language and how to use it to interact with your favorite database system. We will look at structures, interfaces, and built-in concurrent programming functions, among other things. Furthermore, we will talk about the connectivity of the SQL Server and other database systems. In addition, we will see how to use Go as a cloud-native language in Azure efficiently. At the end of this session, you should clearly understand how to get started with Go. |
Watch Now |
| Sheela Siddappa | Data Science (AI/ML) | English | Automated Data Annotation in Images by Data Science | While there are companies working towards annotation of images for defects/anomalies here is a Data Science approach to automatically annotate the defects.
The approach has been implemented for multiple data sets and have provided very good accuracy (>90%) in being able to identify the defects correctly. The approach also enables, one to identify the various types of defects. This solution thereby provides a very good input for the Deep Learning model building. |
Watch Now |
| Shireen Bahadur, Chuck Heinzelman, Rodrigo Souza, Jason Huang & Wee Hyong Tok | Development | English | Overview of Synapse Link | Synapse Link enables near real-time analytics over operational data. Join this session to learn more about Synapse Link for SQL, CosmosDB, and Dataverse. | Watch Now |
| Shreya R. Aithal | Development | English | Develop and deploy a MySQL application on Azure App Services. | Azure Database for MySQL – Flexible Server is a developer-friendly, affordable and fully managed MySQL service on Azure, which provides you the flexibility to develop applications using your favourite tools, languages, and frameworks, deploy faster by integrating with Azure ecosystem of services. In this session, you’ll learn how to build and deploy your applications on Azure App Service, integrating with Azure Database for MySQL – Flexible Server in the backend. You’ll also learn some of the best practices to apply which can help to ensure better performance, resilience and security. | Watch Now |
| Sohini Garg | Data Administration | English | Two pronged approach to securing sensitive data on Azure SQL | Walk through two ways of securing sensitive data on Azure SQL:
a) Dynamic Data Masking – examples of masking sensitive columns of tables using a SQL script. Include nuances of using the Custom String mask to handle specific email domains (like .gov, .edu etc) or SSN etc. b) Utilizing Row-level-Security to hide specific sensitive data in a table from users who are not authorized to see those rows, while all of the the users can see all non-sensitive rows. c) We will go one more step in depth about scenario b), where the table itself’s schema cannot be changed due to software constraints, and examine how row level security can still be applied. Format of session: Slides followed by demo |
Watch Now |
| Srdjan Bozovic & Mirek Sztajno | Data Administration | English | Azure AD authentication and Microsoft Purview access policies for SQL Server 2022 on Azure Arc-enabled servers | Join this session on SQL Server 2022 security to learn about new capabilities using Microsoft Purview and Azure Active Directory authentication. With Microsoft Purview unified data-governance solution, Data Officer can assign permissions to Azure Active Directory users at a scale, without the need to run scripts or to explicitly create logins or users on SQL Servers through the org. To align with the principle of least privilege, SQL Server 2022 will make the following server roles eligible for assignment using the Microsoft Purview access policies: Data Reader, Performance Monitor, and Security Auditor. Join this session to learn how to harden the security of SQL Server 2022 deployed on Azure Arc-enabled servers with Azure AD Authentication and Microsoft Purview access policies. | Watch Now |
| Sudheesh Narayanaswamy & Shreya R. Aithal | Data Administration | English | Introduction to MySQL for the SQL Server user | Are you a SQL Server user curious about the world of open source databases like MySQL? What are the use cases and benefits to hosting workloads on MySQL? Join this session to learn more about what is MySQL, the options to host MySQL on Azure and the fully managed MySQL service Azure Database for MySQL – Flexible Server. | Watch Now |
| Sudhir Raparla, Rajesh Setlem & Scott Kim | Data Administration | English | Azure SQL availability and resiliency for modern applications | Modern applications need databases with high availability and extreme resilience. You can build the most resilient databases with highest availability using the latest capabilities of Azure SQL such as zone redundancy, geo replication, maintenance window and backup/restore. In this session you will be taken on a deep dive journey through architectures, configurations, and our industry leading SLAs which will help you get the right level of availability, resilience and disaster recovery your databases need. | Watch Now |
| Sunitha Muthukrishna & Vivek Gk | Development | English | Copy and transform data in Azure Database for MySQL using Azure Data Factory or Synapse Analytics | In the world of big data, data engineers and analysts require services like Azure Data Factory (to orchestrate data movement and to transform data) and Azure Synapse Analytics (for data warehousing and analytics). You can now use ADF and Synapse Analytics to orchestrate, transform and analyse data hosted on Azure Database for MySQL – Flexible Server, the fully managed MySQL service on Azure. In this session, you’ll learn how to use Copy Activity in Azure Data Factory or Synapse Analytics pipelines to copy data from and to Azure Database for MySQL, and use Data Flow to transform data in Azure Database for MySQL. | Watch Now |
| Taiob Ali | Data Administration | English | What the heck is a checkpoint, and why should I care? | An 8K page is the fundamental unit of data storage in SQL Server. For performance reasons, SQL Server performs every data modification operation in memory (buffer pool) and does not write it back to disk immediately.
This is where checkpoint comes into play. The Database Engine periodically issues a checkpoint on each database. A checkpoint writes the current in-memory modified pages (known as dirty pages) and transaction log information from memory to disk. It also records this information in the transaction log. This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, changes made with checkpoint settings in SQL 2012 and SQL 2016+. |
Watch Now |
| Tanya Pupko & Alexandra Horbatenko | Professional Development | Russian | Добавьте виртуальные разговоры с данными в рабочую жизнь | Сценарии с Power Platform и Teams для эффективной работы. | Watch Now |
| Tejas Shah & Amit Khandelwal | Data Administration | English | SQL Server on Linux & Kubernetes! – From Zero to Hero | Continuing from the last year, this year’s session is all about how you can get your SQL Server production workload deployed on your choice of Kubernetes and Linux distributions. This session will give you answers to the below questions, so if you have these question or any other questions on SQL Server on Linux/Containers then this is a session for you. And, no session is complete without Demos. This session will have lots and lots of demos that you can see and also try them in your environments after the session.
1) Do you know what stateful set SQL Server deployment means in Kubernetes? 2) What QoS(quality of Service) should SQL Server containers be deployed with? 3) Did you know, you could set HA using Always on AGs for SQL Server containers using few simple steps? 4) Do we have any reference architectures and numbers that can be shared? |
Watch Now |
| Thomas Grohser | Architecture | English | Scaling SQL Server Beyond 1 Core | The data we have to manage grows faster and faster and the queries we analyze it are getting more and more complex. Many applications and workloads can not easily be converted to scale out solutions. This session explains how to scale up SQL Server and what you need to do to end up with a system that scales well.
We will look at 2,4,8 and 32 socket systems and see how we can optimize for latency, throughput and concurrency. We look at hardware options, OS configurations and SQL Server settings. |
Watch Now |
| Tomaž Kaštrun | Data Science (AI/ML) | English | Addressing climate change with help of Machine learning | Climate change is a fact, it is happening, and we need not only actively participate in tackling it, but also we need to raise awareness. One area that can be identified is the area of using and implementing machine learning algorithms and techniques to tackle climate change.
Addressing this issue can be done using machine learning and different approaches to tackling it, from mitigating or reducing and stopping CO2 emissions or adapting to the changes that climate change will bring. With the help of Microsoft Azure services, we will go through some of the machine learning concepts and how Azure can help us address, reduce, adapt to these issues or which tools can be found in Azure to help take actions and address policies. The session will look into climate change modeling, efficient sensing, biodiversity, solar geo-modeling, transportation, and electricity with the help of Machine Learning and Microsoft Azure. |
Watch Now |
| Tommy Puglia | Data Administration | English | Promoting & Governing Power BI in your Organization – Building a framework to Adopt Power BI | This session is focused on the education of administering , adopting, and promoting the Power BI platform for an Enterprise solution. The overall success for an enterprise using Power BI comes not just the skilled Power BI champions but how Power BI is deployed to an organization and maintained. Join us to learn about adopting a framework for your BI team to govern and manage content in Power BI, utilizing Workspaces for BI Collaboration and organization of Report content, creating a Power BI Admin team who maintains and defines the intent of Workspace environments, establishing naming conventions for content (Dashboards, Reports) for End Users, methods to help support and educate end users to adopt Power BI, and creating an internal BI Support Site. | Watch Now |
| Torsten Strauß | Professional Development | English | Extent and Page Management in Microsoft SQL Server | In this session, you will learn how SQL Server physically stores data in pages and how they are managed by the IAM, PFS, GAM, SGAM pages and extents. We look into partitions and allocation units and compare the various page types, such as in-row, row overflow and LOB pages. We will also dump a data page to analyze the page header and translate the payload with the FixedVarFormat. | Watch Now |
| Ulrich Christ | Development | English | SAP connectivity in Azure Data Factory | Join this session to learn about the latest enhancements being made to SAP connectivity in cloud scale analytics. | Watch Now |
| Uri Barash | Data Administration | English | Observational Analytics with Synapse Data Explorer | The integration of data explorer pools natively into Synapse unlocks new capabilities to bring insights from log and telemetry data into your enterprise analytics solutions. In this session we’ll review the basic capabilities, cover recent updates, and discuss plans for the future. | Watch Now |
| Uros Milanovic | Data Administration | English | From bare metal to the SQL Managed Instance PaaS | Azure SQL Managed Instance is a fully managed platform-as-a-service offering for deploying SQL workloads in the cloud. As a PaaS service it relies on multiple Azure components including compute, networking, and storage. These components combined provide a variety of configuration options reflected in different service tiers powered by customer selected hardware, organized in virtual cluster, and maintained and patched in the time spans that customer define. We will go over configuration options and explain how they impact the deployment flows. | Watch Now |
| Vahid Doustimajd | Development | Farsi – Persian | مزایای استفاده از HTML در گزارشات Power BI | در این جلسه تعدادی از Tag های HTML را به شرح ذیل برای ارتقای گزارشات Power BI با همدیگر مرور خواهیم کرد
1- نحوه اضافه کردن ویدیو به گزارش 2- نحوه استفاده از فونت های گوگل در Text Box 3- استفاده از رنگ دلخواه برای تغییر رنگ پس ضمینه یک متن 4- نحوه اضافه نمودن حرکت به متون در گزارشات (از چپ به راست و از بالا به پایین و …) 5- نحوه اضافه تمودن GIF به گزارشات 6- دادن امکان تغییر سایز فونت های متون به کاربرای در گزارش 7- ارتقای استفاده از تصاویر در گزارشات |
Watch Now |
| Vanessa Toves | Architecture | English | Architecting an end to end data driven solution in 365 | Business problems that need data driven solutions don’t all require massive investments in infrastructure (native or cloud). We will discover the power of solution architecture and Microsoft 365 apps to solve everyday business problems. | Watch Now |
| Venkata Raj Pochiraju | Data Administration | English | Manage on-premises SQL Servers with the power of Azure- “Arc-enabled SQL Servers” | Do you want to continue hosting your SQL Servers on-premises but optimize administration of SQL Server instances in on-premises and multi-cloud environments by using Azure Arc? Please join our session that we can deep dive into how Arc enabled SQL Server capabilities assessing SQL Server configuration, availability, performance and help mitigating. Bring the power of Azure Defender, Best Practice Assessments and Azure Monitor services to optimize and secure your SQL Servers.
In this session you learn below: Use cases and when to use Arc enabled SQL Servers Architecture: How does all this works Onboarding single and at scale SQL Servers Capabilities: SQL BPA, Defender, and Purview. Customer success stories Roadmap and references |
Watch Now |
| Venkata Raj Pochiraju & Sasha Nosov | Data Administration | English | SQL Server 2022 – Azure integration to enable Hybrid solutions out of the box | In this session, you learn how SQL Server 2022 allows you to achieve business continuity, seamless analytics over on-prem operational data, manage, secure and govern data centrally through seamless integration with Azure services. You will learn how to leverage Azure Active Directory as a single sign-on solution for your database applications running on-premises or in other clouds. You will see how you can leverage the built-in integration with Microsoft Defender for Cloud to proactively check for vulnerabilities and get alerted for security attacks of your database application. | Watch Now |
| Warner Chaves | Business Intelligence & Advanced Analytics | Spanish | Introduccion a Azure Synapse Analytics | Lo que comenzo como Azure SQL Data Warehouse, ha evolucionado a un servicio completo de desarrollo de soluciones de analisis de datos. Microsoft ha tomado el poder de bases de datos distribuida de SQL y ha agregado nuevas capacidades de big data, notebooks e integracion de datos.
Para administradores o desarrolladores, Synapse ofrece herramientas utiles para ambos roles. Incluyendo nuevas tecnologias y conceptos como SQL On-Demand, catalogs de tablas Spark-SQL, integracion con Azure Data Lake Storage Gen 2 y mas. Esta sesion es 90% demo, demostrando los conceptos principales de Synapse y demos con todos los features principales y la nueva experiencia del Synapse Studio. Los participantes se van con la comprension de las nuevas capacidades de Synapse y como este innovador servicio puede ser utilizado en sus organizaciones para generar resultados de analisis de datos mas rapido que nunca antes. |
Watch Now |
| Warner Chaves | Business Intelligence & Advanced Analytics | English | The World of Spark in Azure | Apache Spark is an open-source unified analytics engine for large-scale data processing that has taken the data industry by storm since it’s inception in 2014.
With a clean, integrated interface for programming entire clusters, Spark shines with capabilities of implicit data parallelism and fault tolerance, making it a great open-source or proprietary platform for open ended big data processing. With a very broad range of capabilities and programmability, Spark can also run in many different ways and choosing the right one is a key component for any successful project. In this session we will introduce Spark’s main concepts and the main ways to run it in Microsoft Azure: HDInsight, Databricks and Synapse! |
Watch Now |
| Wyn Hopkins | Business Intelligence & Advanced Analytics | English | How to sell Power BI to the Excel crowd | There are so many amazing overlaps and integrations between Power BI and Excel that if Excel users aren’t excited about the adoption of Power BI then maybe it’s not being sold to them in the best way.
Whether it’s connected datasets, dataflows, featured tables & data types, data model, or interactive Pivots embedded in your Power BI app one of these features will surely win them over. |
Watch Now |
| Zoran Barac | Architecture | English | Go full-scale with Azure SQL Hyperscale Service Tier | Azure SQL PaaS
• Azure SQL deployment models • Purchasing Models • Service Tiers • Availability Models Azure SQL PaaS Architectures Socrates Architecture • Decoupling the compute, storage, and log services Socrates Architecture Principles Socrates Foundation – SQL Features (RBPEX, ADR, Page Versioning, Snapshot Backups and Restore, etc) SQL DB Hyperscale at work • Primary Compute Node • Secondary Compute Node • XLog Service • Page Servers • XStore SQL DB Hyperscale provisioning and monitoring |
Watch Now |
| Srikantan Sankaran | Data Administration | English | Large scale Bulk Data ingestion | Join us to understand the approaches & Best Practices in bulk ingestion of large datasets from Azure Data Lake Stores into Databases (OLTP, OLAP and HTAP), using Spark with Azure Databricks | Watch Now |
| Bishnu Agrawal & Vishakha Arbat | Business Intelligence & Advanced Analytics | English | Deliver Personalized experience with Customer Data Platform | Join us to understand how Microsoft Customer Data Platform(D365 Customer Insights) helps deliver personalized customer experience.
In this session, we will showcase, how can you easily plug in customer profiles from first and third party data sources. Get 360-degree customer views and derive out-of-the-box insights with prebuilt AI models. |
Watch Now |
| Jerod Johnson | NA | English | Analyze Live Snowflake Data with SQLServer Analytics Services | NA | Watch Now |
| Jerod Johnson | NA | English | DBAmp Product Showcase | NA | Watch Now |
| Jerod Johnson | NA | English | Salesforece & QuickBooks Integration to SQLServer | NA | Watch Now |
| Louis Imershein | NA | English | Automating Deployment of Enterprise Linux for Microsoft SQL Server | NA | Watch Now |
| 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 | 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 worlds 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 Kubernetesand 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, Ill share how Microsoft is leveraging AI and packaging some of those innovations to deliver as part of our Azure AI services. Ill 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, Microsofts 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 dont realize that Microsoft has built SQL Server on Linux to leverage all of these features. In this talk, well 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 Microsofts 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, youll 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? Whats 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 conceptsrequest units (RU), partitioning, and data modelingand 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 Microsofts 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 Microsofts 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. Its difficult to isolate the development of different features, so they are rolled together into big releases. Its 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 nights 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. Youll learn how to configure AD authentication reliably and quickly with new and improved experience. Youll 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, well bring you quickly up to speed on Azure Arc enabled Managed Instance, discuss use cases, and demo this product. Well 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 organizations 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 |