Blog Archives

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 ;-)

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 ;-)

SQL Saturday #86: Tampa BI Edition

SQL Saturday #86 was held on November 7, 2011, at K-Force Technology in beautiful Ybor City hosted by Jose Chinchilla, President of the Tampa Bay BI User Group.  This event was a great success for a little over a hundred attendees even though I did not win the iPad.  In addition, I believe this was the first time that a SQL Saturday event was dedicated solely to the Business Intelligence platform. 

This was my second SQL Saturday event and it was well worth the investment of my time and travel to attend.  I am going to post separate blogs detailing some of the things either that I learned or  that stood out for me.  Stay tuned for those posts.

Let the Gator Growl!

Follow

Get every new post delivered to your Inbox.

Join 1,291 other followers