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 ;-)
About these ads

About Ed Watson

Florida Gator and Certified SQL Server Enthusiast, Star Wars fanatic and is there anything else...oh yeah PS3! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on November 8, 2011, in SQL Saturday, Training and tagged , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,404 other followers

%d bloggers like this: