Sessions & Content

Search
Content Type
Conference
Tags
10 reasons to look at using Azure Data Studio Robert French
Yet another new tool from Microsoft ! Why should you consider using it? Thats a good question. In this session we will explore at least 10 reasons to use the tool, and maybe a few more.
A Distributed Availability Groups Primer Allan Hirt
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
Advanced Plan Explorer Usage for Tuning Execution Plans Andy Yun
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Analyzing database with XE and Query Store data using R / Py Tomaz Kastrun
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 SQL and SQL Server: Path to an Intelligent Database Pedro Lopes
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
Azure SQL Database Edge-Optimized SQL Engine for Edge/IoT Sourabh Agarwal
Azure SQL Database Edge has taken the same SQL database engine you know and optimized it for the Edge. This session explores popular customer implementations, along with new product features for the Intelligent Edge
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.
Building a Better Backup Strategy Paul Randal
Learn how backup and restore work and how to put together an effective backup strategy.
Can SQL Server 2019 auto-magically fix my bad T-SQL code? Andy Yun
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Deadlocks: Lets Do One, Understand It, and Fix It Brent Ozar
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
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.
Designing Azure Data Disaster Recovery Strategies John Morehouse
Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!
Digital Transformation from Edge to Cloud with Azure Data Rohan Kumar
In 2020, organizations have undergone digital transformation at breakneck speeds. In this keynote Rohan Kumar, Corporate Vice President of Azure Data, will discuss how you can be at the heart of change for your company.
The video is not available to view online.
Docker Deep Dive Andrew Pruski
Played around with SQL Server in containers and want to delve further into the platform? This session is for you! In this session we'll dive straight into the Docker platform and investigate its internals.
Dynamic Data Masking in 20 Minutes David Postlethwaite
In this 20 minute session we will have an overview and demos of Dynamic Data Masking which allows us to obfuscate data in real time
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.
Execution plans ... where do I start? Hugo Kornelis
Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
Fast Focus: Scalar User-defined Functions in SQL Server 2019 Hugo Kornelis
SQL Server 2019 introduces FROID, a framework to inline user-defined functions, promising much better performance. What problem does it solve? And how does it work?
Financial Modelling with Power BI Bob Duffy
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
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.
<<123>>