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?
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
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.
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.
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.
Learn about the component of Power BI and best practices for implementations
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 best practices in Analysis Services and Power BI
Introducing the ROC curve and its use in Azure ML.
For anyone frustrated by column-hoarding users and developers
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.
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
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.
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.
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.
Common performance issues with clustered columnstore index experienced by customers and strategies to address them.
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.
Come learn how to make your BI projects perform at their max!!
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 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.
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.
Come learn how to set up a production-grade SQL Server on Linux environment!
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
In this demo-only session, you will learn how Premier Field Engineers at Microsoft troubleshoot performance problems and what tool and scripts they use. We will take a look at tools and scripts like SQLDiag, SQLNexus, PAL, and BPCheck.
Solve complex problems with T-SQL window functions.