Uwe Ricken

As organizations move more workloads into the cloud, performance inefficiencies quickly translate into real money. Intelligent Query Processing (IQP) in SQL Server and Azure SQL introduces a powerful set of features designed to improve query performance automatically.

INSERT, UPDATE, and DELETE operations look simple on the surface — but inside SQL Server, they trigger a complex chain of storage‑engine behaviors that can dramatically affect performance, concurrency, fragmentation, and long‑term maintainability. Whether your tables are heaps or clustered indexes, DML operations behave very differently under the hood, and understanding those differences is essent

Statistics are one of the most powerful — and most misunderstood — components of the SQL Server query optimizer. They drive cardinality estimation, influence join strategies, shape memory grants, and ultimately determine whether a query runs in milliseconds or minutes.

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.

Deadlocks in SQL Server can pose significant challenges for database administrators, leading to performance bottlenecks and potential disruptions in critical business operations. This session aims to provide a hands-on demonstration of effective deadlock resolution strategies within SQL Server.

SQL Performance-Optimierung Langsame Abfragen, blockierte Prozesse oder unerklärliche Lastspitzen – viele SQL Instanzen, ob on-premises oder in der Cloud (Azure SQL Managed Instance oder Azure SQL Database), kämpfen im Alltag mit Performance-Problemen, deren Ursachen oft tief verborgen liegen. Diese zuverlässig zu identifizieren und nachhaltig zu beheben, ist eine Herausforderung, die fundiertes K

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.

Join Grant Fritchey and Uwe Ricken as they discuss the critical role of automation in ensuring data compliance. They will delve into a range of topics, including how automated systems can streamline audit processes, reduce human error, and enhance data integrity.

In the ever-evolving landscape of database management, the integration of JSON (JavaScript Object Notation) has become pivotal for modern applications. This session aims to provide a deep dive into the integration and utilization of JSON in Microsoft SQL Server.

Join Grant Fritchey and Uwe Ricken as they discuss the critical role of automation in ensuring data compliance. They will delve into a range of topics, including how automated systems can streamline audit processes, reduce human error, and enhance data integrity.

Unlock the power of data partitioning in Microsoft SQL Server and take your database management and performance optimization skills to the next level. If you're a database professional responsible for handling large datasets and optimizing query performance, this workshop is your gateway to mastering the art of partitioning.

Dealing with large object (LOB) data is one of the challenges of managing SQL Server installations. LOBs are usually composed of pictures, but they can contain large text elements as well.

Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance!