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 #.
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.
F# supports functional programming, object-oriented programming, and imperative programming. It is new langauge out of MS-Research and very closely resembles oCaml.
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.
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 .