Performance optimization by identifying and correcting bad SQL code

This interactive workshop presents realistic examples of bad SQL programming that often lead to performance problems in practice. The aim of the session is to show participants how to identify, analyze and optimize inefficient SQL queries/SQL code in order to achieve significant performance improvements.
The workshop focuses on five to ten concrete, poorly implemented SQL coding scenarios. For each of these scenarios, the underlying problems are explained in detail and optimization approaches are then presented. Different techniques and best practices are presented that are essential for improving query speed and system efficiency.
With the help of practical lab exercises, load tests are generated to measurably compare performance before and after optimization. This allows participants to directly understand which measures lead to a significant reduction in response times and what impact they have on the overall system load.
At the end of the session, participants will have a better understanding of the most common pitfalls in SQL programming practices and will be able to perform in-depth performance analyses and make optimizations.

Evolution of User-Defined Functions in Microsoft SQL Server

Since their introduction in SQL Server 2000, User-Defined Functions (UDFs) have become a cornerstone for many database developers seeking to encapsulate logic, improve code reusability, and enhance maintainability. This session embarks on a journey through the development and evolution of UDFs in Microsoft SQL Server, highlighting the pivotal updates, performance improvements, and new features introduced with each version.

Attendees will explore the foundational concepts of UDFs in SQL Server, understanding their initial design and limitations. The session will then navigate through subsequent versions, showcasing significant milestones such as inline table-valued functions, scalar UDF inlining, and enhancements in SQL Server 2019 and beyond. We will delve into practical examples, performance considerations, and best practices for optimizing UDFs in the modern SQL Server environment.

Whether you're a seasoned DBA, a developer, or someone looking to deepen your SQL Server expertise, this session provides valuable insights into leveraging UDFs to their fullest potential. Join us for a comprehensive overview and discover how UDFs have transformed and will continue to evolve to meet the needs of today's dynamic data-driven world

Partitioning in Microsoft SQL Server: A Beginner's Guide

Partitioning is a powerful feature in Microsoft SQL Server, designed to enhance manageability, and scalability of large datasets. This introductory session aims to demystify the concept of partitioning and provide beginners with a solid foundation to effectively leverage this feature in their database environments.

Participants will learn about the basic principles of partitioning and when to use each. The session will cover step-by-step instructions on how to create partitioned tables and indexes, along with practical tips for managing and maintaining partitions.

We'll also explore the performance benefits of partitioning, such as improved data loading, and efficient data archiving. Real-world examples and best practices will be shared to help attendees avoid common pitfalls and optimize their partitioning strategy.

Whether you're a novice DBA, a developer, or someone looking to optimize data management in SQL Server, this session provides the essential knowledge and tools to get started with partitioning.

The Power of Partitioning through Real-World Showcases

Partitioning is an advanced feature in Microsoft SQL Server that offers significant performance and manageability benefits. This session is tailored for experienced SQL Server DBAs looking to deepen their understanding of partitioning by exploring real-world showcases that highlight its transformative impact.

We will delve into two to four detailed case studies where partitioning has been successfully implemented to solve complex database challenges:

1. Accelerating a High Transactional OLTP production environment by up to 30% in a manufacturing company by partitioning machine data.

2. Optimizing the load of more than 10.000 cash register data into a big Data Warehouse of a retail company

3. recalculation of financial risks of a bank for daily reports for supervisory authorities

4. A financial services company leveraged partitioning to streamline their data archiving process, enabling faster data retrieval and compliance with regulatory requirements.

Throughout the session, we will discuss the technical implementation, performance metrics, and best practices for each showcase, providing attendees with actionable insights and strategies to apply partitioning in their own environments.