SQL Server Deep Dive: Writing Efficient Queries and Enhancing Performance

The Data Community Austria is an independent, non-profit organization (NPO) dedicated to supporting, educating, and promoting the global Microsoft SQL Server and Azure community. The organization is run by and for the community, made up of database administrators and developers, application developers, Business Intelligence and IT professionals, executives, consultants, educators, instructors, students, vendors, and many others who work with or use Microsoft Azure, SQL Server and Business Intelligence technologies.

Data Community Austria

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

JUFA Wien City

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 LearnHere's an overview of the key topics covered in the workshop:<ul><li>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.</li><li>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.</li><li>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.</li><li>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.</li><li>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.</li><li>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.</li></ul>Who Should AttendThis 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.

SQL Server Deep Dive: Writing Efficient Queries and Enhancing Performance

More events from Data Community Austria

Discover more events from Data Community Austria, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Wien and filter by date, category, and more to find the perfect fit.

SQL Server Deep Dive: Writing Efficient Queries and Enhancing Performance

More events from Data Community Austria

Discover more events from Data Community Austria, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Wien and filter by date, category, and more to find the perfect fit.