Friday, September 17, 2010

My takeaways from Adam Jorgensen's 24HOP session -- Zero to cube

Here are my takeaways from today's fantastic session of Adam

  • The first basic point was you can use "." instead of "localhost" to choose the localhost server.
  • Defining the attribute relationship was very clearly explained that the relatiosnhps should be from the lowest level to the highest level.
  • Proactive caching -- available in from SQL SERver 2008 but the refresh property is available in Excel 2007 but sometimes may not work properly.

The following two resources which are quite useful was also discussed.

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

Microsoft SQL Server Product Samples: Database

No comments:

My first experience with SQL Server Database Partitioning

At my work I have inherited a database where the partitioning was not done correctly.  This database holds millions and millions of records...