blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

Browse by Tags

All Tags » SSIS » SQL Server Anal... » SQL Server Integration Services
  • SSIS/SSAS: Process SSAS dimensions and measure groups individually

    On my current project I am implementing SQL Server Analysis Services (SSAS) and recently I was having a problem doing a full process of my cube. I've got many many measure groups in the cube each containing twelve partitions and the cube process was hanging due to lack of resource issues on the Analysis Server. Those issues needed sorting ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on July 18, 2006
  • Interesting reads

    If you're interested in BI solutions on the Microsoft platform and you have nothing better to do then you could do worse than readig a couple of whitepapers that I have recently encountered: ETL Performance: Unisys and Microsoft SQL Server Speed Up The Process - Understand how 64-bit computing can dramatically increase performance of ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on April 9, 2006
  • SSIS: A use for the XML type with the Analysis Services Processing Task

    Here's a little tip for you. Some database pros are skeptical about the arrival of the XML data type in SQL Server 2005. They see it as an opportunity for cowboy developers to store all of their data in a single field with no regard for atomicity, normalisation or referential integrity. OK, I'm exaggerating a bit but you get the point. Well the ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on April 3, 2006
Powered by Community Server (Personal Edition), by Telligent Systems