Sessions & Content

Tags
Search
Conference
"But It Worked in Development!" 3 Hard Performance Problems
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
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
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
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?
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
Learn about the component of Power BI and best practices for implementations
DAX Optimization Examples
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
DirectQuery best practices in Analysis Services and Power BI
Evaluating Models: Get Ready to ROC
Introducing the ROC curve and its use in Azure ML.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers
Introduction to partitioning
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
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
Kick Start! SQL Server 2016/2017 Performance Tips and Tricks
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
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
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.
Maximizing the Query Performance with Columnstore Indexes
Common performance issues with clustered columnstore index experienced by customers and strategies to address them.
Performance Monitoring Using Extended Events, DMVs & Query S
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
Come learn how to make your BI projects perform at their max!!
Query Execution: Expectation-Reality
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
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>>