Browse by Tags

Tagged Content List
  • Blog Post: SQLCAT.Com - eBook Downloads

    As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication. MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated...
  • Blog Post: 32- and 64-Bit Connectivity from the Same Machine

    Author: Chuck Heinzelman Reviewers: Steve Howard, Carl Rabeler, Shaun Tinline-Jones, Mike Weiner, Murshed Zaman I was recently involved in a customer lab testing the Microsoft Business Intelligence stack. I noticed an interesting behavior when working on one of my test servers. Here’s...
  • Blog Post: 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 you see a fact record that cannot be resolved...
Page 1 of 1 (3 items)