SQL Server Deep Dive: Writing Efficient Queries and Enhancing Performance

Join us for a deep dive into writing efficient SQL queries and boosting performance - you won't want to miss it!

Get ready to elevate your SQL Server skills with a comprehensive full-day workshop designed specifically for professionals like you!

In this workshop, you will gain essential skills and techniques for writing powerful and well-performing Transact-SQL queries. You’ll also develop the expertise to diagnose and optimize slow-performing queries while leveraging the latest features in SQL Server.

The workshop is led by Miloš Radivojević, a database expert with over 25 years of experience in SQL Server development, troubleshooting, and performance tuning. Miloš will share techniques, advice, and practical tips for writing efficient queries and optimizing performance, all drawn from decades of real-world experience.

What You Will Learn

Here's an overview of the key topics covered in the workshop:

• How SQL Server Uses Indexes
  Gain a deeper understanding of how and when SQL Server uses indexes, identifying which indexes are beneficial and which unnecessarily slow down the system. Learn when the missing indexes feature is helpful - and when it can be dangerous.
• Tips for Writing Efficient Queries
  Discover how to avoid common pitfalls when writing Transact-SQL queries. Understand the impact of functions, data type conversions, and local variables on performance, and learn how to optimize complex queries effectively.
• User-Defined Functions and Performance
  Explore the different types of user-defined functions, understand their typical negative effects on performance, and learn strategies to mitigate these issues.
• Optimizing Queries on Very Large Tables
  Master techniques for handling performance challenges when querying very large tables. You will learn to mitigate issues by using query, table, and index hints, table variables, and temporary tables, but you’ll also understand common root causes of performance issues with large tables and how to eliminate them.
• Using Query Store
  Query Store is a powerful tool not only for identifying but also for fixing performance issues caused by execution plan regressions. Learn how it works and how to use it effectively in your SQL Server environment.
• Performance Improvements in SQL Server 2019 and 2022
  Explore more than a dozen new features in SQL Server 2019 and 2022 designed to enhance the performance of Transact-SQL queries. Understand how to apply these features properly to avoid potential performance degradation while maximizing their benefits.

Who Should Attend

This workshop is designed for database developers, database administrators, software engineers, and IT professionals who work with SQL Server. It is especially beneficial for those looking to elevate their Transact-SQL knowledge and performance tuning skills to the next level.