Sessions & Content

Search
Content Type
Conference
Tags
"But It Worked in Development!" 3 Hard Performance Problems Brent Ozar
You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
An introduction to SQL Server for data scientists Gavin Payne
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
Azure and SQL Server: Getting the best out of the cloud Murilo Miranda
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
Azure SQL Data Warehouse Optimizing and Maintaining Robin Lester
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Azure SQL Database vs. Cosmos Db. How do you choose? James Duggan
Focusing on the micro-service / OLTP domain, this talk approaches the challenge of choosing between Azure SQL Database and Cosmos Db (Document Db) by using solution use cases to test each storage's offering for appropriateness.
Best pratices for Power BI on implementation and monitoring Bent Nissen Pedersen
Learn about the component of Power BI and best practices for implementations
DAX Optimization Examples Alberto Ferrari
In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
DirectQuery in Power BI and Analysis Services Marco Russo
DirectQuery best practices in Analysis Services and Power BI
The video is not available to view online.
Evaluating Models: Get Ready to ROC Emma Zambonini
Introducing the ROC curve and its use in Azure ML.
Improving SELECT * Query Performance Erik Darling
For anyone frustrated by column-hoarding users and developers
Introduction to partitioning Andrew Pruski
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Investigate TempDB like Sherlock Holmes Richard Douglas
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
Kick Start! SQL Server 2016/2017 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. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Man vs Machine: Adaptive query processing and auto tuning Fabiano Neves Amorim
Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL 2017. Adaptive query processing, auto tuning and few other features added into the product.
Maximise compute performance with Azure SQL Data Warehouse James Rowland-Jones
Learn about the new compute optimized performance tier in SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
The video is not available to view online.
Maximizing the Query Performance with Columnstore Indexes Sunil Aagrwal
Common performance issues with clustered columnstore index experienced by customers and strategies to address them.
Performance Monitoring Using Extended Events, DMVs & Query S Ola Hallengren
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Performance Tuning for the BI Professional Jonathan Stewart
Come learn how to make your BI projects perform at their max!!
Query Execution: Expectation-Reality Denis Reznik
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Query Store without SQL 2016 = Open Query Store William Durkin
Query Store was the cool new feature in SQL 2016, but what about those of us stuck on older versions of SQL Server? Introducing: Open Query Store! This session will explain what OQS is and how it can help you take control of your query plans.
<<12>>