SQLSat86 Session Review: Adam Jorgensen’s “0 to SSAS”

The first session of the morning for me was Adam Jorgensen’s ”0 to SSAS” presentation.  Before this event, I had never had the privilege of attending one of Adam’s sessions and I do not work directly with SSAS, but his reputation as a good speaker enticed me to attend.  Needless to say that I was not disappointed.  Below are some random things that I learned from Adam:

• AS is the most powerful engine in the SQL Server line (designed to do table scans which would kill the DB engine)
• The Standard Edition for SQL Server is missing some of the AS functionality.
• AS uses BIDS aka Visual Studio with different project types
• AS works best with the STAR schema but might get the job done if your snowflake schema is not too diluted and you do not mind manually adding the dimensions.
• “Add related tables” will only find one level of relations which makes the STAR schema optimized for this.
• It was not said but I am guessing that the constellation schema would kill the engine