May 2005 - Posts

• Surrogate key generation in SSIS

  In the last few days I tested several ways to generate surrogate keys when loading a dimension into a data mart. The classical approach with SQL Server is to rely on a INT IDENTITY column. It works fine, but you don't know what surrogate key has been Read More... Posted Monday, May 30, 2005 2:47 PM by Marco Russo (SQLBI) | 2 Comments

• Cascading many-to-many dimensions: unsupported scenario?

  I already opened a bug and written on newsgroup about this specfic scenario, but I still haven't received an answer. This morning I met Chris Webb in Munich (I'm attending SQL Pass Europe ) and he told me that one year ago someone of MS told him that Read More... Posted Thursday, May 12, 2005 11:33 AM by Marco Russo (SQLBI) | 0 Comments

• Database snapshots to feed a data warehouse?

  I just attended the pre-conference of Kimberly Tripp at SQL Pass 2005 Europe . The topic was "New SQL Server 2005 features that a DBA need to learn" and I took advantage of this day to cover an area of SQL2005 I still haven't explored. One consideration Read More... Posted Wednesday, May 11, 2005 3:41 PM by Marco Russo (SQLBI) | 0 Comments