We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
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!
Learn tips and tricks to make SSIS perform better.
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
Based on real life scenarios, an audience interactive session.
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 2017 / 2019 has introduced many new features.
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing
Join this session to learn how managing performance is even more critical with Azure SQL DB. Learn what key performance indicators are most applicable, what auto-tuning really means and get some tools to help you identify and fix issues.
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.
This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. Learn tips and tricks on how to reduce IO,relieve memory pressure, and reduce blocking.
Automatic Plan Correction is a feature you can use whether you're a pro at performance tuning or just starting with SQL Server. Come to this session to learn how to spend less time fighting fires with this new feature.
Enough of bookish examples. Learn how you can re-write T-SQL queries using new constructs, tune indexes & deal with statistics to improve query performance.
This session is about using the Business Intelligence Markup Language (Biml) to monitor and control your orchestration patterns. By automatically analyzing the results in ETL logs, we’ll be able to automate our staging orchestration!
<<1>>