Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

Browse by Tags

All Tags » BI » ETL   (RSS)
Assigning surrogate keys to early arriving facts using Integration Services
In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When Read More...
Posted: Wednesday, May 13, 2009 4:26 PM by tkejser | 5 Comments
Filed under: , , , , ,
Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008
Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server 2005 instance and then reattaching them to a completely new SQL Server 2008 instance. If you choose this upgrade strategy, you should be aware that you Read More...
Posted: Friday, March 20, 2009 1:06 PM by tkejser | 2 Comments
Filed under: , , , ,
Page view tracker