22-25 April 2026

Ashwani Roy

I am SQL Server MVP and SQL Server Business Intelligence and C# consultant at CodePerfect Limited .  I am also a regular speaker in SQL Server and BI conferences in UK.

I have worked with SQL Server BI stack since 2003 and I am Microsoft Certified IT Professional. My main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.

Ashwani Roy's Sessions

Supercharge MDX performance using MDX StudioSQLBits 2010

MDX Studio can be used to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships.

Analysis Services Best PracticesSQLBits 2010

Some tips and tricks which I have picked in my last few projects which can help you optimize cube design , optimize query and processing performance .

Understanding Graphical Execution Plans SQLBits 2009

Graphical Execution Plans in SSMS is not only the best way to know what is happenning under the hood of SQL engine but also it is the most accessible one.

Lets go more functional - F# WHAT , WHY and BISQLBits 2009

F# supports functional programming, object-oriented programming, and imperative programming. It is new langauge out of MS-Research and very closely resembles oCaml.