Sessions & Content

Search
Content Type
Conference
Tags
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.
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?
Faster SSIS Andy Leonard
Learn tips and tricks to make SSIS perform better.
Kick Start! SQL Server 2019 Performance Tips and Tricks Pinal Dave
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2019 has introduced many new features. Here is a glimpse of the features we wil
SQL Server Table partitioning – DOs and DON’Ts Margarita Naumova
When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?
Troubleshooting Plans: P1-Root Cause Analysis/Caching Probs Kimberly L. Tripp
One of the most common “false positives” that people see when troubleshooting query plans is that updating statistics “fixes” a problem. In this first session, we'll decipher the ACTUAL problem - caching or statistics?
Troubleshooting Plans: P2-Statistics Problems Kimberly L. Tripp
In this second session, we'll talk about problems that are NOT caching related but in fact, actually statistics problems? More importantly, I'll give you ways to help solve them!
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.
A dive into the architecture that is Azure SQL DW Gen2 Philip Beaumont
A technical overview of Azure SQL Data Warehouse Gen 2. SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.
The video is not available to view online.
Aggregations in Power BI Alberto Ferrari
We introduce the concept of aggregation, we show several examples of their usage understanding the advantages and the limitations of aggregations, with the goal of building a solid understanding on how and when to use the feature in data models.
Azure Cosmos DB and Databricks for CRM Optimization Simon Hayward
Find out how a major UK hotel chain unified their wildly different sources of data to build a supercharged analytics and pricing engine to power their business. Find out how Cosmos and Databricks helped them get to know their customers, how best to retain them, and how best to keep them happy, all while ensuring GDPR compliance and the right to be forgotten.
Azure Cosmos DB Use Cases and Customer Stories Blesson John
Do you want to know why customers chose Cosmos DB? Come learn about the business goals and technical challenges faced by real world customers, and learn about key Cosmos DB features so you can help your customers deliver their high-performance business-critical applications on Cosmos DB.
Batch Execution Mode on the Rowstore Niko Neugebauer
Learn in 75 Minutes what Batch Execution Mode is, when & how it will affect your workloads (in upcoming SQL Server 2019 & Azure SQLDB) on the traditional Rowstore Indexes.
Behind the Query Store… Kalen Delaney
Look inside Query Store to see what it does and how it works
Benchmarking in the Cloud Gianluca Sartori
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
Cognitive Services, Bots, and Search: Dev Tools for AI Christina E. Leo
In this session, we’ll look at the different options within the Cognitive Services suite, show you how to connect to the APIs using Python code, walk through a live bot demo, and build an Azure Cognitive Search index. You should leave this session feeling like you’ve had a jump start to further your AI developer skill set.
Database Adventure Kevin Chant
Based on real life scenarios, an audience interactive session.
The video is not available to view online.
DB Engineering: Shall we test the code before we hit prod? Ed Elliott
Deploying untested code to production isn't ideal, manual testing can be slow and unreliable. In this talk we will look at the different types of automated testing we can use for our databases to give us confidence in the quality of the code.
The video is not available to view online.
Debugging common DAX and Model performance issues Kasper de Jonge
In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.
<<12345678910...>>