Past seminars

Uwe Ricken - Analyze and Optimize SQL Server

Unlock the full potential of your SQL Server environment by mastering the art of performance analysis and optimization. If you're a database professional responsible for maintaining SQL Server databases, this workshop is your gateway to becoming a skilled performance analyst and optimizer. Course will take place on June 7th 2024 at Hotel International, Miramarska 24, 10000 Zagreb, Croatia.

Session abstract

Unlock the full potential of your SQL Server environment by mastering the art of performance analysis and optimization. If you're a database professional responsible for maintaining SQL Server databases, this workshop is your gateway to becoming a skilled performance analyst and optimizer.

In this hands-on workshop, we will dive deep into the tools, techniques, and methodologies needed to identify performance bottlenecks, analyze query execution, and implement effective optimization strategies. Whether you're a seasoned database administrator, developer, or data analyst, this workshop will equip you with the knowledge and practical skills to ensure your SQL Server databases run at peak efficiency.

Key Workshop Topics Include:

  • Performance Monitoring and Profiling: Leveraging SQL Server's built-in tools and external utilities to monitor and profile database performance.
  • Query Tuning: Analyzing query execution plans, identifying inefficient queries, and optimizing SQL statements.
  • Indexing Strategies: Designing and maintaining indexes for optimal query performance.
  • System Resource Management: Balancing CPU, memory, disk I/O, and other system resources for SQL Server.
  • Advanced Query Optimization Techniques: Deepening your understanding of execution plan operators and query transformations.
  • Tempdb Optimization: Managing and optimizing tempdb for improved database performance.
  • Bottleneck Identification: Identifying and resolving common performance bottlenecks in SQL Server.
  • Real-world Case Studies: Applying performance optimization techniques to real-world scenarios.

Who Should Attend:

This workshop is tailored for database administrators, developers, data engineers, and anyone responsible for maintaining and optimizing SQL Server databases. Whether you're dealing with slow applications, growing data volumes, or complex query workloads, this workshop will empower you with the skills to address these challenges effectively.

Join us for this immersive workshop to become a performance optimization expert for SQL Server. By the end of the session, you'll be well-equipped to proactively manage and optimize SQL Server environments, ensuring they deliver peak performance and responsiveness to meet your organization's needs.

About the speaker

Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of membership administration software for the American Chamber of Commerce in Germany. Afterwards the software has been distributed to five additional European countries.

The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for the Deutsche Bank AG in Frankfurt am Main. After 6 years of experiences in the European Operations Center as a DBA and over 14 years as a developer of complex database models he earned in May 2013 the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification from Microsoft.

The successful year 2013 has been finalized with the first MVP award for his outstanding support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken was the first MCM + MVP in Germany!

To provide his deep knowledge about Microsoft SQL Server to the interested community Uwe is blogging since 2010 at http://db-berater.blogspot.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German speaking SQL community a deeper inside view into the technology of Microsoft SQL Server. Uwe Ricken is a speaker on many international conferences and events and preferred topics for “Database Internals”, “Indexing” and “Development”.