Pittsburgh SQL Server Users Group


Next Meeting: Tue, Jan 30 2018

Who's on First? SQL Server statistics & Dynamic Power BI Visuals!

Language: English
Event Type: In-Person
Online Meeting URL: None



UTC : Tue, Jan 30 2018 17:00 - 19:00
Event Time : Tue, Jan 30 2018 17:00 - 19:00 UTC
Your Local Time: Tue, Jan 30 2018 17:00 - 19:00


Pittsburgh North Shore
Pittsburgh, Pennsylvania

Direction: None

Featured Presentation

Who's on First? SQL Server statistics & Dynamic Power BI Visuals!

Speaker: William Wolf, Manager - SQL Performance Tuning RDX

Summary: What will happen when a BI Expert is analyzing statistics and a Performance Tuner is creating Power BI reports based on that analysis? A dynamic learning experience from two experienced professionals. The SQL Server optimizer uses distribution statistics when creating execution plans. Statistics are used to provide the optimizer with estimations for the best way to process the query and hopefully optimize performance. Power BI is a powerful tool that has been released in the last few years that helps you visualize your information to help make informative decisions with rich visualization. In this session, we will show you how SQL Server uses statistics to create the execution plan and Power BI to visualize that statistical distribution.

About William: Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQL Saturday veteran speaking at nearly 40 SQL Saturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.



Thank you to our Sponsors!







Back to Top