Sessions & Content

Tags
Search
Conference
Baselining Performance with DEA
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?
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!
Faster SSIS
Learn tips and tricks to make SSIS perform better.
Kick Start! SQL Server 2019 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. 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
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
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
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
Learn what is necessary to keep an eye on your Azure SQL Database in order to better tune it and reduce costs.
<<1>>