SQL Server Performance for Application Developers

with Gianluca Sartori

You write applications for a living, but the database for you represents more of an inconvenience than a resource. You know exactly how to write efficient application code, but whenever your application is slow, it’s the database that’s always to blame.

How can you achieve better performance in the database? How can you write efficient queries? How can you take advantage of indexes, and how exactly do they work? How does the database engine come up with execution plans? How does one read and optimize those plans? Is blocking involved in any way? How do I measure and tune performance?

Gianluca Sartori, an independent consultant, performance tuning specialist, and Microsoft Data Platform MVP, will share with you his vast knowledge of databases and data-centric applications in this one-day seminar, dedicated to the essentials of database design, and query performance monitoring and tuning. Whether you're just starting out with database design, or looking to improve your existing knowledge, this is where you should take the next step on your journey.

Register

Data Modeling for Power BI: From Foundations to Best Practices

with Markus Ehrenmüller-Jensen

You’ve built your first Power BI reports, but now you're facing performance issues, overly complex DAX formulas, or confusion about the model view. Sound familiar? Whether you’re struggling with slow reports, puzzling relationships, or just want to understand how to build clean, scalable data models, this hands-on, full-day workshop is for you.

We’ll start from the ground up, establishing a strong foundation in data modeling concepts before exploring how they apply in Power BI. Step-by-step, you’ll gain practical insights, work through real-world scenarios, and build the confidence to model data efficiently and effectively.

Markus Ehrenmüller-Jensen, an expert in project leadership, data engineering, and business intelligence architecture since 1994, a professor of databases and project engineering at HTL Leonding technical college, will guide you through some of the most important topics in modern Business Intelligence solutions in this one-day seminar, covering the core concepts of data modeling, how to implement them using Power BI, and take you deep into the realms of dimensional modeling.

Register