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.
<<1>>