September 2006 - Posts

• The many-to-many revolution: paper finally released!

  After a month of editing, I finally released my paper titled "The many-to-many revolution". I copied in this post the introduction of the 84-page paper that is published (for free!) on a dedicated dimensional modeling page of SQLBI.EU web site. I would Read More... Posted Sunday, September 24, 2006 6:56 PM by Marco Russo (SQLBI) | 0 Comments

• Refresh of a linked dimension in SSAS

  I started to evaluate the use of linked dimension across different database on the same server. I encountered the first issue after a few minutes: when you link a dimension, VS editor create a dimension file that copies the structure of the dimension, Read More... Posted Tuesday, September 12, 2006 10:37 AM by Marco Russo (SQLBI) | 4 Comments

• How to handle schema in Visio database modeling

  Alberto Ferrari wrote a nice post with a workaround to generate tables in different SQL Server 2005 schemas starting from a single Visio document. The trick includes a SQL script to do the magic. I hope that next Visio version would be able to do that Read More... Posted Wednesday, September 06, 2006 8:49 AM by Marco Russo (SQLBI) | 0 Comments