Sessions & Content

Search
Content Type
Conference
Tags
Advanced analytics features in Power BI Chris Webb
In this session you’ll learn about some of these advanced analytical features in Power BI, including: the Analytics pane on visuals; the Key Influencers visual and other AI features.
An administrators guide to SQL Server 2019 BDC Buck Woody
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.
Analyzing database with XE and Query Store data using R / Py Tomaž Kaštrun
DBA and Data scientists should work together! Analyzing data gathered with XE and Query Store data using R or Python for better database insight and discovering hidden patterns.
The video is not available to view online.
Azure AI, Power new possibilities for every organization Lindsey Allen
AI and data is at the center of the digital feedback loops. We have invested in a comprehensive portfolio of AI tools, infrastructure and services. Come to this session to get an update of Azure AI with demos.
Azure Cost Management Dustin Dorsey
Learn the tools and techniques you can use to create governance and insights around your Azure spend
Azure data services on Azure Arc Umachandar Jayachandran
In this session you’ll learn more about Azure data services on Azure Arc
Azure Machine Learning and the Python SDK Robin Lester
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
Baking Extended Events recipes without breaking a sweat Gianluca Sartori
In this demo intensive session I will show you how to tackle the most challenging tasks with Extended Events without writing a single line of code.
Baselining Performance with DEA Dustin Dorsey
Learn what the Database Experimentation Advisor is and how you can start using it to baseline performance from a target and source server when new changes are introduced.
Battle tested project planning with Azure Devops boards Kevin Chant
Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?
Building a secure data solution using Azure Data Lake Carmel Eve
In this session we'll focus on the benefits of using Azure Data Lake. We will cover how we use ADLS in real projects to produce a security architecture which is adaptable, scalable and provides monitoring capabilities.
Creating Custom Visuals in Power BI with TypeScript and D3.j Mihail Mateev
This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement.
De-risk Your Azure SQL Migration: 5 Critical Considerations Kevin Kline
The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
DevOps 101 for Data Folks Alex Yates
An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
Elementary! The Curious Case of Deceptive Query Optimizer Pinal Dave
We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
Failover groups under the magnifying glass Mladen Andzic
Learn about internals of the Failover Groups as a BCDR feature recommended for the critical database workloads that must survive region-wide outages and recover instantaneously.
The video is not available to view online.
Faster SSIS Andy Leonard
Learn tips and tricks to make SSIS perform better.
First Dates: AI & DBAs. Any Chance to be a perfect match? Sascha Lorenz
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
Getting Started with Learning Azure Monica Rathbun
Join three Microsoft Data Platform MVPs to discuss the best approach with building your Azure skills. You will learn the best approaches to gaining the skills you need to function in a cloud world.
Hidden Gems of SQL Server 2019 Denis Reznik
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
How to continuously optimise your hybrid SQL Server estate Martin Wild
Automate optimising your hybrid production databases by recording workloads and replaying them either on-prem or onto Azure instances whilst identifying bottlenecks and exploring SQL tuning techniques.
The video is not available to view online.
Introduction to Perf Troubleshooting Using Wait Statistics Paul Randal
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Life Hacks: dbatools edition Jess Pomfret
dbatools is an open source PowerShell module. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.
Microsoft certifications for the Data & AI professional Sandra Marin
Are you looking to take your career to the next step? Microsoft Certifications help validate knowledge and ability required to perform current and future industry job-roles in a modern digital business. Our certification
Network access controls for Azure SQL Database Rohit Nayak
Join us for a session that explains connectivity basics followed by how to eliminate all public access to SQL Database server and transition to private-only access using Azure Private Link.
New Azure AD authentication capabilities in Azure SQL Mirek Sztajno
Join this session to learn about new and upcoming Azure AD authentication capabilities in Azure SQL.
Optimizing your Azure SQL Database workloads Denzil Ribeiro
In this session we will demonstrate a few workload patterns on Azure SQL Database and discuss how to identify and remove bottlenecks in order to scale those applications.
PaaSport to Paradise: Azure SQL Database + SSIS in ADF Sandy Winarko
This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift & shift, modernize, and extend ETL workflows.
The video is not available to view online.
Performance Mythbusters Paul Randal
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
Populate and purify your data lake with Azure Data Factory Nico Jacobs
In this session you will get a birds eye view of all the features in Azure Data Factory, and see this demonstrated in a cloud ETL.
The video is not available to view online.
Predictive Maintenance with Azure Synapse James Broome
This session provides an end-to-end walk through of how to use Azure Synapse for cloud-hosted advanced analytics, based around a real-world predictive maintenance use case.
Protect hybrid data workloads with Advanced Data Security powered by Azure Security Center Michal Bar
Join this session to learn about new and upcoming SQL security features and how they are supported in hybrid environments.
Run rich confidential queries using Always Encrypted Jakub Szymaszek
In this session, we will demonstrate the main benefits and best practices of Always Encrypted secure enclaves.
SQL Injection: How it Works, How to Stop It Grant Fritchey
Learn what SQL Injection is and all the mechanisms you should employ to help stop it.
SQL Notebooks in Azure Data Studio for the DBA Rob Sewell
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
SQL Server 2019: The Modern Data Platform Bob Ward
SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.
SQL Server Big Data Clusters: The Full Story Ben Weissman (he/him)
A complete overview about SQL Server Big Data Clusters including it's major components and use-cases!
SQL Server farm management vs single instance management Per Christopher Undheim
Most DBA’s are cowboys, but there is much to learn from the world of cow herding and dairy farms that can make us manage SQL Server instances in a better way. Come and learn how SQL Server farms are the future.
SQL Server to Azure SQL: Performance and Availability Anna Hoffman
Translate your existing SQL Server performance and availability skills and apply them to Azure SQL.
Stop waiting to explore your data: use Azure Data Explorer! Jason Bonello
See how we can address the problem of real-time analysis, on data in its raw form, without going through the whole ETL/ELT process, using Azure Data Explorer. We will also explore this solution in a demo!
The Modern Data Platform: Automate Everything Angus Mack
Automation for deploying, monitoring and alerting in a data lake data platform using Terraform, DevOps, Application Insights, Log Analytics and PowerBI.
The Zero Budget DBA | SQL Community has got your back John Mccormack
So your company has no budget for fancy 3rd party tools. Don’t worry, the SQL community has got your back. Come and hear about the many free tools available to data professionals that will help you in your daily life.
Top tips for the accidental Power BI administrator Chris Webb
In this session you'll learn real-world experience from Microsoft's Customer Advisory Team about what you need to manage and administer Power BI.
VertiPaq Analyzer crash course Marco Russo
Learn how to read the information provided by VertiPaq Analyzer 2.0 and optimize data models in Power BI, Analysis Services, and Power Pivot.
Whats Going On in My Power BI Environment? Ásgeir Gunnarsson
As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it.
When Anti-Patterns Become Best Practices Joey D'Antoni
SQL Server has long had a series of development anti-practices like using scalar functions and table valued functions that are vastly improved in modern versions of the database engine. Learn what's fixed.
Why You Need Query Store Erin Stellato
If you have heard about Query Store but don't know what it can offer, or why you really need it, this session will answer those questions and demonstrate the value of this feature that continues to evolve.
Yes, You Should Monitor Azure SQL Database Grant Fritchey
Learn what is necessary to keep an eye on your Azure SQL Database in order to better tune it and reduce costs.
<<1>>