Recommended Reading

for Work with SSAS Entity Framework Provider

See also Our recommended reading for software development in general

• Microsoft SQL Server Analysis Services

  • Books

    • Delivering Business Intelligence with Microsoft SQL Server 2008
    • Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
    • Microsoft® SQL Server® 2008 MDX Step by Step (Step by Step (Microsoft))
      Note: you can work with SSAS Entity Framework Provider (tm) knowing nothing about MDX
    • Refactoring Databases: Evolutionary Database Design

  • Online

    • Big Data, Bigger Brains Note: Hive ODBC
    • SSAS on top of MapReduce See page 3 "Hadoop Hive Connector: Big Data Integration"
    • Why the current obsession with "big" data?
    • Scale-Out Querying with Analysis Services
    • Handling and Tuning Really Large Analysis Services Cubes (video)
    • OLAP Internals Why are OLAP servers so much better at processing ad hoc queries?
      The same sorts of aggregations that might take hours to process in an ordinary relational database can be processed in milliseconds in an OLAP cube.
      What are the underlying mechanics of the model that make that possible?
    • OLAP Using ASP.NET (it is 2004, but it describes cube schema from our usage examples, skip 2 last sections)
    • Codd's Paper (OLAP description by Dr. E.F. Codd, a father of relational model and OLAP term)
    • OLAP
    • Just What Are Cubes Anyway? (A Painless Introduction to OLAP Technology)
    • Cubes (Analysis Services)
    • Creating OLAP Cube and Other SSAS Walkthroughs
    • Star vs. Snowflake in OLAP Land
    • De-normalised schema
    • SQL Server 2008 R2 Analysis Services Operations Guide (Microsoft)
    • Avoid Common SQL Server Analysis Services Problems
    • Database Explosion
    • OLAP Servers Comparison
    • MDX for Everyone (By Mosha Pasumansky, an MDX co-author)
      Note: you can work with SSAS Entity Framework Provider (tm) knowing nothing about MDX
    • eBay Architecture - what eBay did to scale

• .NET and LINQ

  • Books

    • C# 4.0 in a Nutshell: The Definitive Reference
    • Entity Framework 4.0 Recipes: A Problem-Solution Approach (Expert's Voice in .NET)
    • Programming Entity Framework, Second Edition

  • Online

    • Why LINQ beats SQL (most points are applicable to MDX too)
    • 101 LINQ Samples
    • Entity Framework FAQ
    • Entity Framework Learning Guide
    • Top-down vs Bottom-up in design